Which integrations are available for this server?

Provides comprehensive email management including search with AI categorization, auto-categorization (work, personal, job applications, urgent, spam), smart summaries, calendar extraction from meeting invites, follow-up reminders, thread management, and sending/replying with AI assistance. Enables full-featured calendar management including event creation with attendees, conflict detection, smart reminders (15 minutes, 1 hour, 1 day before), focus time blocking, free slot finding, and daily/weekly summaries. Allows document search across entire Drive, AI summarization of documents, support for PDF, Docs, Sheets, and text files, email attachment integration, and smart caching for fast repeated access. Enables note management including creating and managing notes, secure API key storage in encrypted notes, quick capture from Claude, and task list creation and management. Provides full spreadsheet operations including read/write/append, auto-creation of trackers (job applications, email analytics), batch operations, formula support, and data export for analysis.

MCP Server for Google Services

A Model Context Protocol (MCP) server that integrates Google services with Claude Desktop. Provides 80+ tools for Gmail, Calendar, Drive, Sheets, and Docs operations.

Features

Gmail: Search, read, send, reply, label, and organize emails
Google Calendar: Create, update, delete events; find free slots
Google Drive: Search, list, read files and folders
Google Sheets: Read, write, append data; manage spreadsheets
Google Docs: Create and read documents
Memory System: Persistent storage for context and preferences
Database Support: Optional PostgreSQL and MongoDB integration

Project Structure

mcpwithgoogle/ ├── src/ │ ├── mcp_server.py # Main MCP server (80+ tools) │ ├── google_auth.py # OAuth authentication │ ├── google_gmail.py # Gmail operations │ ├── google_calendar.py # Calendar operations │ ├── google_drive.py # Drive operations │ ├── google_sheets.py # Sheets operations │ ├── google_docs.py # Docs operations │ ├── memory_system.py # Persistent memory │ ├── local_storage.py # Local data storage │ └── setup.py # OAuth setup script ├── config/ │ └── claude_desktop_config.json # Example Claude config ├── scripts/ │ └── setup_my_profile.py ├── config.example.json # Google OAuth config template ├── authenticate.py # Authentication script ├── requirements.txt ├── .env.example └── README.md

Prerequisites

Python 3.8+
Claude Desktop
Google Cloud Project with APIs enabled:
- Gmail API
- Google Calendar API
- Google Drive API
- Google Sheets API

Installation

Step 1: Clone the Repository

git clone https://github.com/pbulbule13/mcpwithgoogle.git cd mcpwithgoogle

Step 2: Install Dependencies

pip install -r requirements.txt

Step 3: Google Cloud Setup

Go to Google Cloud Console
Create a new project or select existing
Enable the following APIs:
- Gmail API
- Google Calendar API
- Google Drive API
- Google Sheets API
Go to Credentials > Create Credentials > OAuth 2.0 Client ID
Select Desktop app as application type
Download the credentials and save as credentials.json in the project root

Step 4: Configure

# Copy example config cp config.example.json config.json # Edit with your Google OAuth credentials

config.json:

{ "google": { "clientId": "YOUR_CLIENT_ID.apps.googleusercontent.com", "clientSecret": "YOUR_CLIENT_SECRET", "redirectUri": "http://localhost", "calendarId": "primary" } }

Step 5: Authenticate with Google

python authenticate.py

This opens a browser for Google OAuth. After authorization, tokens are saved locally.

Step 6: Configure Claude Desktop

Edit your Claude Desktop configuration file:

OS	Path
Windows	`%APPDATA%\Claude\claude_desktop_config.json`
macOS	`~/Library/Application Support/Claude/claude_desktop_config.json`
Linux	`~/.config/Claude/claude_desktop_config.json`

Add:

{ "mcpServers": { "google-workspace": { "command": "python", "args": [ "C:\\path\\to\\mcpwithgoogle\\src\\mcp_server.py" ], "env": {}, "cwd": "C:\\path\\to\\mcpwithgoogle" } } }

Important: Replace C:\\path\\to\\ with your actual absolute path.

Step 7: Restart Claude Desktop

Completely quit Claude Desktop (check system tray)
Restart Claude Desktop
The tools will be automatically available

Verify Installation

In Claude Desktop, type:

Show me available tools

You should see 80+ tools listed.

Available Tools

Email Tools

search_emails - Search Gmail with queries
get_email - Get email by ID
send_email - Send new email
reply_to_email - Reply to email
list_labels - List Gmail labels
create_label - Create new label
move_to_label - Move email to label

Calendar Tools

get_calendar_events - List events
create_calendar_event - Create event
update_calendar_event - Update event
delete_calendar_event - Delete event
find_free_slots - Find available times

Drive Tools

search_drive - Search files
list_drive_files - List files in folder
get_file_content - Read file content
create_folder - Create folder

Sheets Tools

read_sheet - Read spreadsheet data
write_sheet - Write to spreadsheet
append_sheet - Append rows
create_sheet - Create new spreadsheet

Docs Tools

create_doc - Create document
read_doc - Read document content

Memory Tools

remember - Store information
recall - Retrieve information
forget - Remove information
list_memories - List all stored items

Example Usage

In Claude Desktop:

"Show my unread emails from today" "Schedule a meeting tomorrow at 2 PM with john@example.com" "Find documents about 'project proposal' in my Drive" "What meetings do I have this week?" "Remember that my favorite color is blue"

Troubleshooting

MCP Server Not Appearing

Verify the path in claude_desktop_config.json is absolute and correct
Ensure Python is in your system PATH
Restart Claude Desktop completely
Check Claude Desktop logs for errors

Authentication Errors

Delete tokens.json and re-run python authenticate.py
Verify credentials.json exists in project root
Check Google Cloud Console for API quota issues

Import Errors

pip install --upgrade -r requirements.txt

Security Notes

Never commit credentials.json, tokens.json, or config.json to git
The .gitignore file excludes sensitive files by default
Store API keys in environment variables when possible

License

MIT License

Enhanced MCP Server