Skip to content
mcp/harbor
Claude Desktop

Google Sheets for Claude Desktop

io.github.mcp-z/mcp-sheets

Google Sheets integration with OAuth, spreadsheet management, batch operations, and formatting

client:Claude Desktop transport:stdio runtime:npm

Install Google Sheets 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-sheets": {
      "command": "npx",
      "args": [
        "-y",
        "@mcp-z/mcp-sheets"
      ],
      "env": {
        "GOOGLE_CLIENT_ID": "<GOOGLE_CLIENT_ID>",
        "GOOGLE_CLIENT_SECRET": "<GOOGLE_CLIENT_SECRET>",
        "GOOGLE_SERVICE_ACCOUNT_KEY_FILE": "<GOOGLE_SERVICE_ACCOUNT_KEY_FILE>",
        "AUTH_MODE": "<AUTH_MODE>",
        "HEADLESS": "<HEADLESS>",
        "REDIRECT_URI": "<REDIRECT_URI>",
        "RESOURCE_STORE_URI": "<RESOURCE_STORE_URI>",
        "PORT": "<PORT>",
        "BASE_URL": "<BASE_URL>",
        "LOG_LEVEL": "<LOG_LEVEL>"
      }
    }
  }
}

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

Google Sheets in other clients

Google Sheets MCP server