Google Services MCP Server

MCP (Model Context Protocol) server for Claude Desktop that provides access to Google Sheets, Gmail, and Google Calendar.

Features

• 13 MCP Tools:
  • Google Sheets (4 tools): Read, write, append, and get sheet info
  • Gmail (4 tools): List, search, get details, and send emails
  • Google Calendar (5 tools): List, create, update, delete, and get event details

Prerequisites

• Python 3.8 or higher
• Google Cloud Project with APIs enabled:
  • Google Sheets API
  • Gmail API
  • Google Calendar API
• OAuth 2.0 credentials (credentials.json)
• Claude Desktop installed

Installation

1. Clone and Install Dependencies

# Navigate to project directory
cd mcplatestv1

# Install dependencies
pip install -r requirements.txt

2. Setup Google OAuth

1. Download credentials.json from Google Cloud Console
2. Place credentials.json in the project root directory
3. Run the setup script to authenticate:

python src/setup.py

4. Follow the prompts to authorize access to your Google account
5. The script will create tokens.json with your access tokens

3. Configure Your Services

Edit config.json:

{
  "google": {
    "clientId": "your-client-id",
    "clientSecret": "your-client-secret",
    "redirectUri": "http://localhost",
    "spreadsheetId": "your-spreadsheet-id",
    "calendarId": "primary"
  }
}

Note: spreadsheetId and calendarId are optional - you can specify them per tool call.

Claude Desktop Setup

Step 1: Find Claude Desktop Config File

Windows:

%APPDATA%\Claude\claude_desktop_config.json

Example: C:\Users\YourName\AppData\Roaming\Claude\claude_desktop_config.json

Mac:

~/Library/Application Support/Claude/claude_desktop_config.json

Linux:

~/.config/Claude/claude_desktop_config.json

Step 2: Edit Config File

Open the config file (create it if it doesn't exist) and add:

{
  "mcpServers": {
    "google-services": {
      "command": "python",
      "args": [
        "D:\\mcplatestv1\\src\\mcp_server.py"
      ],
      "env": {}
    }
  }
}

Important:

• Update the path to match your actual project location
• On Windows, use double backslashes (\\) in the path
• On Mac/Linux, use forward slashes (/)

Step 3: Restart Claude Desktop

Completely quit and restart Claude Desktop for the changes to take effect.

Step 4: Verify Connection

After restarting:

1. Claude Desktop will automatically start the MCP server
2. All 13 tools should be available
3. Test by asking Claude: "What tools do you have access to?"

Usage

Once connected, you can ask Claude to:

• Read from Sheets: "Read the data from Sheet1!A1:B10"
• Write to Sheets: "Write these values to my spreadsheet: [['Name', 'Age'], ['John', '30']]"
• List Emails: "Show me my last 10 emails"
• Send Email: "Send an email to john@example.com with subject 'Hello' and body 'Test message'"
• Create Events: "Create a calendar event for tomorrow at 2pm titled 'Meeting'"

Available Tools

Google Sheets

• read_sheet - Read data from a range
• write_sheet - Write data to a range
• append_sheet - Append data to a sheet
• get_sheet_info - Get spreadsheet information

Gmail

• list_emails - List emails from inbox
• get_email_detail - Get detailed email information
• send_email - Send an email
• search_emails - Search emails with a query

Google Calendar

• list_calendar_events - List upcoming events
• create_calendar_event - Create a new event
• update_calendar_event - Update an existing event
• delete_calendar_event - Delete an event
• get_calendar_event - Get event details

Troubleshooting

Server Won't Start

1. Check Python path: Make sure Python is in your system PATH

   • Test: Open terminal and type python --version
   • If not found, use full path: "C:\\Python\\python.exe"

2. Check file path: Verify the path to mcp_server.py is correct

   • Use absolute path in config file
   • Windows: D:\\mcplatestv1\\src\\mcp_server.py
   • Mac/Linux: /path/to/mcplatestv1/src/mcp_server.py

3. Check dependencies: Make sure all packages are installed

   pip install -r requirements.txt
   

Tools Not Appearing

1. Check Claude Desktop logs:

   • Look for error messages in Claude Desktop console
   • Check if server process is running

2. Verify authentication:

   • Make sure tokens.json exists and is valid
   • Re-run python src/setup.py if needed

3. Restart Claude Desktop:

   • Completely quit (not just close window)
   • Restart and check again

Authentication Errors

1. Re-authenticate: Run python src/setup.py again
2. Check credentials: Verify credentials.json is valid
3. Check scopes: Ensure all required APIs are enabled in Google Cloud Console

Project Structure

mcplatestv1/
├── src/
│   ├── mcp_server.py          # Main MCP server (stdio protocol)
│   ├── google_auth.py         # Google OAuth handling
│   ├── google_sheets.py       # Google Sheets functions
│   ├── google_gmail.py        # Gmail functions
│   ├── google_calendar.py     # Calendar functions
│   ├── agent.py               # Automatic decision logic
│   └── setup.py               # Initial setup script
├── config.json                # Configuration (your credentials)
├── config.example.json        # Configuration template
├── credentials.json           # Google OAuth credentials (download from Cloud Console)
├── tokens.json               # OAuth tokens (generated by setup.py)
├── requirements.txt           # Python dependencies
├── claude_desktop_config.json # Example Claude Desktop config
└── README.md                  # This file

License

This project is for personal use. Make sure to keep your credentials.json and config.json files secure and never commit them to version control.