Skip to content
mcp/harbor
Claude Desktop

Google Sheets MCP for Claude Desktop

io.github.a1-x-tech/mcp-google-sheets

MCP server for the Google Sheets API: read and write ranges, sheets, formatting, charts, sharing.

client:Claude Desktop transport:stdio runtime:npm

Install Google Sheets MCP in Claude Desktop

~/Library/Application Support/Claude/claude_desktop_config.json · windows: %APPDATA%\Claude\claude_desktop_config.json

Held in this page only — never stored, logged, or sent anywhere but back to your screen. 

{
  "mcpServers": {
    "mcp-google-sheets": {
      "command": "npx",
      "args": [
        "-y",
        "@a1-x-tech/mcp-google-sheets"
      ],
      "env": {
        "GOOGLE_SHEETS_CLIENT_ID": "<GOOGLE_SHEETS_CLIENT_ID>",
        "GOOGLE_SHEETS_CLIENT_SECRET": "<GOOGLE_SHEETS_CLIENT_SECRET>",
        "GOOGLE_SHEETS_REFRESH_TOKEN": "<GOOGLE_SHEETS_REFRESH_TOKEN>",
        "GOOGLE_SHEETS_ACCESS_TOKEN": "<GOOGLE_SHEETS_ACCESS_TOKEN>",
        "GOOGLE_SHEETS_OAUTH_PORT": "<GOOGLE_SHEETS_OAUTH_PORT>",
        "GOOGLE_SHEETS_API_BASE": "<GOOGLE_SHEETS_API_BASE>",
        "GOOGLE_SHEETS_TIMEOUT_MS": "<GOOGLE_SHEETS_TIMEOUT_MS>",
        "GOOGLE_SHEETS_MAX_RETRIES": "<GOOGLE_SHEETS_MAX_RETRIES>"
      }
    }
  }
}

Settings → Developer → Edit Config opens this file. Restart the app after saving. Claude Desktop docs

Google Sheets MCP in other clients

Google Sheets MCP MCP server