Google Workspace MCP on Cloudflare Workers

This is a Model Context Protocol (MCP) server that runs on Cloudflare Workers and interacts with Google Docs, Sheets, and Drive. It allows AI assistants like Claude Desktop, Cursor, and others to securely access and manage your Google Workspace documents.

Features

• Google Drive: Search and list files with listDriveFiles.
• Google Docs:
  • Read document content with readDocument.
  • Create new documents with createDocument.
  • Append text to documents with appendDocumentText.
  • List document tabs with listDocumentTabs.
• Google Sheets: Read values from a range with readSheet.

Setup

1. Google Cloud Console Configuration

1. Go to the Google Cloud Console.
2. Create a new project.
3. Enable the following APIs:
   • Google Drive API
   • Google Docs API
   • Google Sheets API
4. Go to APIs & Services > Credentials.
5. Create an OAuth 2.0 Client ID (Web application).
6. Add http://localhost:8787/oauth/callback to the Authorized redirect URIs.
7. Note down your Client ID and Client Secret.

2. Configuration & Secrets

1. Create a KV namespace:

   npx wrangler kv:namespace create GOOGLE_AUTH_KV
   

2. Update your wrangler.jsonc with the KV namespace ID.
3. Set your Google OAuth secrets:

   npx wrangler secret put GOOGLE_CLIENT_ID
   npx wrangler secret put GOOGLE_CLIENT_SECRET
   

3. Deployment

npm install
npm run deploy

Authentication

Once deployed (or running locally with npm run dev), visit the following URL to authenticate with your Google account:

http://localhost:8787/oauth/login (or your deployed worker URL)

This will securely store your refresh token in Cloudflare KV.

MCP Configuration

Add the following to your MCP client configuration (e.g., claude_desktop_config.json):

{
  "mcpServers": {
    "google-workspace": {
      "command": "npx",
      "args": ["-y", "@modelcontextprotocol/sdk-server-sse", "http://localhost:8787/mcp"]
    }
  }
}

Development

npm run dev