Google Sheets MCP Server

io.github.domdomegg/google-sheets-mcp

Repository Registry

What is the Google Sheets MCP server?

Allow AI systems to read, write, and query spreadsheet data via Google Sheets.

How to install Google Sheets

Copy-paste configuration for popular MCP clients.

transport: stdio

Config generated by PluginBench — verify against the source before use.

Environment / auth

GOOGLE_ACCESS_TOKEN
required
secret
Google OAuth access token with Sheets scopes.
MCP_TRANSPORT
required
Transport type.
GOOGLE_CLIENT_ID
required
Google OAuth client ID.
GOOGLE_CLIENT_SECRET
required
secret
Google OAuth client secret.

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

{
  "mcpServers": {
    "google-sheets-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "google-sheets-mcp"
      ],
      "env": {
        "GOOGLE_ACCESS_TOKEN": "<YOUR_GOOGLE_ACCESS_TOKEN>",
        "MCP_TRANSPORT": "<YOUR_MCP_TRANSPORT>",
        "GOOGLE_CLIENT_ID": "<YOUR_GOOGLE_CLIENT_ID>",
        "GOOGLE_CLIENT_SECRET": "<YOUR_GOOGLE_CLIENT_SECRET>"
      }
    }
  }
}