Google Workspace MCP Server

A comprehensive Model Context Protocol (MCP) server for Google Workspace integration with Claude Desktop. Provides 109 tools for Gmail, Calendar, Sheets, Docs, Drive, plus local storage and personal memory system.

Features

Gmail: Read, send, reply, forward emails, manage drafts and labels
Google Calendar: List, create, update, delete events
Google Sheets: Create, read, write spreadsheets with formatting
Google Docs: Create and edit documents with formatting
Google Drive: Upload, download, share files and folders
Local Storage: Profile, job applications, contacts, skills, tasks
Memory System: Personal preferences, behaviors, goals, patterns

Setup Guide

Prerequisites

Python 3.10 or higher
Claude Desktop installed
Google Cloud project with APIs enabled

Step 1: Clone or Download

git clone <repository-url>
cd google-mcp-server

Step 2: Install Dependencies

pip install -r requirements.txt

Required packages:

mcp>=0.9.0
google-api-python-client>=2.100.0
google-auth-httplib2>=0.2.0
google-auth-oauthlib>=1.2.0
python-dotenv>=1.0.0
requests>=2.31.0

Step 3: Set Up Google Cloud Project

Go to Google Cloud Console
Create a new project (or select existing)
Enable the following APIs:
- Gmail API
- Google Calendar API
- Google Sheets API
- Google Docs API
- Google Drive API
Go to APIs & Services > Credentials
Click Create Credentials > OAuth client ID
Select Desktop app as application type
Download the JSON file
Rename it to credentials.json and place in the google-mcp-server folder

Step 4: Authenticate with Google

Run the authentication script:

cd google-mcp-server
python src/google_auth.py

This will:

Open a browser window for Google sign-in
Ask you to authorize the app
Create a tokens.json file with your access tokens

Step 5: Set Up Database Folder (Optional)

Create a centralized database folder for all your data:

mkdir -p ~/Documents/pbdb/mcp
mkdir -p ~/Documents/pbdb/analytics
mkdir -p ~/Documents/pbdb/exports
mkdir -p ~/Documents/pbdb/backups

The MCP server stores data in:

~/Documents/pbdb/mcp/local_data.db - Job tracking, contacts, skills
~/Documents/pbdb/mcp/personal_memory.db - Personal memory system

Step 6: Configure Claude Desktop

Find your Claude Desktop config file:
- Windows: %APPDATA%\Claude\claude_desktop_config.json
- macOS: ~/Library/Application Support/Claude/claude_desktop_config.json
- Linux: ~/.config/Claude/claude_desktop_config.json
Add the MCP server configuration:

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

Windows Example:

{
  "mcpServers": {
    "google-workspace": {
      "command": "C:\\Users\\YourName\\miniconda3\\python.exe",
      "args": [
        "C:\\Users\\YourName\\google-mcp-server\\src\\mcp_server.py"
      ],
      "env": {},
      "cwd": "C:\\Users\\YourName\\google-mcp-server"
    }
  }
}

macOS/Linux Example:

{
  "mcpServers": {
    "google-workspace": {
      "command": "/usr/bin/python3",
      "args": [
        "/home/username/google-mcp-server/src/mcp_server.py"
      ],
      "env": {},
      "cwd": "/home/username/google-mcp-server"
    }
  }
}

Step 7: Restart Claude Desktop

Close and reopen Claude Desktop. The MCP server will initialize automatically.

Step 8: Verify Installation

In Claude Desktop, try these commands:

"Show my recent emails"
"What events do I have on my calendar?"
"List my Google Drive files"
"What do you know about me?"

Available Tools (109 Total)

Gmail (21 tools)

Tool	Description
`list_emails`	List emails from inbox
`get_email_detail`	Get full email content
`send_email`	Send a new email
`search_emails`	Search emails with query
`create_draft`	Create a draft email
`list_drafts`	List all drafts
`update_draft`	Update a draft
`send_draft`	Send a draft
`delete_draft`	Delete a draft
`reply_to_email`	Reply to an email
`forward_email`	Forward an email
`add_label`	Add label to email
`remove_label`	Remove label from email
`list_labels`	List all labels
`mark_as_read`	Mark email as read
`mark_as_unread`	Mark email as unread
`trash_email`	Move to trash
`archive_email`	Archive email
`create_followup_draft`	Create job follow-up draft
`create_thank_you_draft`	Create thank you draft

Calendar (5 tools)

Tool	Description
`list_calendar_events`	List upcoming events
`create_calendar_event`	Create a new event
`update_calendar_event`	Update an event
`delete_calendar_event`	Delete an event
`get_calendar_event`	Get event details

Sheets (11 tools)

Tool	Description
`create_spreadsheet`	Create new spreadsheet
`read_sheet`	Read data from sheet
`write_sheet`	Write data to sheet
`append_sheet`	Append rows to sheet
`get_sheet_info`	Get spreadsheet info
`create_sheet_tab`	Create new tab
`list_spreadsheets`	List all spreadsheets
`format_cells`	Format cells
`add_formula`	Add formula to cell
`share_spreadsheet`	Share spreadsheet
`create_job_tracker`	Create job tracker template

Docs (12 tools)

Tool	Description
`create_document`	Create new document
`read_document`	Read document content
`append_to_document`	Append text
`format_document_text`	Format text
`apply_paragraph_style`	Apply styles
`insert_table`	Insert table
`insert_bullet_list`	Insert bullet list
`insert_numbered_list`	Insert numbered list
`list_documents`	List all documents
`share_document`	Share document
`create_daily_report`	Create report template

Drive (17 tools)

Tool	Description
`list_files`	List files
`list_folders`	List folders
`create_folder`	Create folder
`upload_file`	Upload file
`download_file`	Download file
`move_file`	Move file
`copy_file`	Copy file
`delete_file`	Delete file
`search_files`	Search files
`share_file`	Share with user
`share_file_with_anyone`	Share with link
`get_file_metadata`	Get file info
`rename_file`	Rename file
`get_storage_quota`	Get storage info
`export_to_drive`	Export content

Local Storage (21 tools)

Tool	Description
`set_profile`	Set profile field
`get_profile`	Get profile
`get_full_profile`	Get complete profile
`add_job_application`	Add job application
`get_job_applications`	Get applications
`update_job_application`	Update application
`add_interview`	Add interview
`get_interviews`	Get interviews
`add_contact`	Add contact
`get_contacts`	Get contacts
`add_skill`	Add skill
`get_skills`	Get skills
`add_work_experience`	Add experience
`get_work_experience`	Get experience
`add_education`	Add education
`get_education`	Get education
`add_task`	Add task
`get_tasks`	Get tasks
`complete_task`	Complete task
`add_note`	Add note
`get_notes`	Get notes
`get_job_search_summary`	Get job stats

Memory System (22 tools)

Tool	Description
`save_about_me`	Save user info
`get_about_me`	Get user info
`remember`	Remember anything
`recall`	Recall memories
`add_behavior`	Store behavior pattern
`get_behaviors`	Get behaviors
`add_preference`	Store preference
`get_preferences`	Get preferences
`add_goal`	Store goal
`get_goals`	Get goals
`add_work_style`	Store work style
`get_work_style`	Get work style
`add_fact`	Store fact
`get_facts`	Get facts
`add_decision`	Log decision
`get_decisions`	Get decisions
`add_interaction`	Log interaction
`get_interactions`	Get interactions
`add_learning`	Store learning
`get_learnings`	Get learnings
`get_everything_about_user`	Get all user data
`search_memory`	Search memories

Project Structure

google-mcp-server/
├── src/
│   ├── mcp_server.py       # Main MCP server (109 tools)
│   ├── google_auth.py      # OAuth authentication
│   ├── google_gmail.py     # Gmail integration
│   ├── google_calendar.py  # Calendar integration
│   ├── google_sheets.py    # Sheets integration
│   ├── google_docs.py      # Docs integration
│   ├── google_drive.py     # Drive integration
│   ├── local_storage.py    # SQLite local storage
│   └── memory_system.py    # Personal memory system
├── credentials.json        # OAuth credentials (create this)
├── tokens.json            # Auth tokens (auto-generated)
├── config.json            # Configuration
├── requirements.txt       # Dependencies
└── README.md

Troubleshooting

Server not loading in Claude Desktop

Check the path in claude_desktop_config.json
Verify Python path is correct
Check logs at %APPDATA%\Claude\logs\mcp-server-google-workspace.log

Authentication errors

Delete tokens.json and re-authenticate
Verify credentials.json is valid
Check that APIs are enabled in Google Cloud Console

Database errors

Verify database folder exists at ~/Documents/pbdb/mcp/
Check file permissions
Delete .db files to reset (data will be lost)

License

MIT License