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

1. Go to Google Cloud Console
2. Create a new project (or select existing)
3. Enable the following APIs:
   • Gmail API
   • Google Calendar API
   • Google Sheets API
   • Google Docs API
   • Google Drive API
4. Go to APIs & Services > Credentials
5. Click Create Credentials > OAuth client ID
6. Select Desktop app as application type
7. Download the JSON file
8. 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:

1. Open a browser window for Google sign-in
2. Ask you to authorize the app
3. 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

1. 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

2. 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)

Calendar (5 tools)

Sheets (11 tools)

Docs (12 tools)

Drive (17 tools)

Local Storage (21 tools)

Memory System (22 tools)

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

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

Authentication errors

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

Database errors

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

License

MIT License