Skip to content
MCP server

Google Sheets MCP

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

Runs locallyStatus and history
Install
Pricing
Open source
Runs
Locally
Version
1.1.2
Listing updated
4 days ago

About Google Sheets MCP

Google Sheets MCP is an open-source MCP server. It runs locally on your machine and is started by your AI client.

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

Install

Run in a terminal

claude mcp add mcp-google-sheets --env GOOGLE_SHEETS_CLIENT_SECRET='<GOOGLE_SHEETS_CLIENT_SECRET>' --env GOOGLE_SHEETS_REFRESH_TOKEN='<GOOGLE_SHEETS_REFRESH_TOKEN>' --env GOOGLE_SHEETS_ACCESS_TOKEN='<GOOGLE_SHEETS_ACCESS_TOKEN>' -- npx -y @a1-x-tech/mcp-google-sheets

Add to claude_desktop_config.json

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

Add to ~/.cursor/mcp.json

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

Add to .vscode/mcp.json

{
  "servers": {
    "mcp-google-sheets": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@a1-x-tech/mcp-google-sheets"
      ],
      "env": {
        "GOOGLE_SHEETS_CLIENT_SECRET": "<GOOGLE_SHEETS_CLIENT_SECRET>",
        "GOOGLE_SHEETS_REFRESH_TOKEN": "<GOOGLE_SHEETS_REFRESH_TOKEN>",
        "GOOGLE_SHEETS_ACCESS_TOKEN": "<GOOGLE_SHEETS_ACCESS_TOKEN>"
      }
    }
  }
}

Add to ~/.codeium/windsurf/mcp_config.json

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

Add to your client's MCP settings (most use this shape)

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

Configuration

  • GOOGLE_SHEETS_CLIENT_IDGoogle OAuth2 client id (refresh-token flow).
  • GOOGLE_SHEETS_CLIENT_SECRETGoogle OAuth2 client secret (refresh-token flow). Treat it as a secret.
  • GOOGLE_SHEETS_REFRESH_TOKENGoogle OAuth2 refresh token, exchanged for access tokens automatically. Treat it as a secret.
  • GOOGLE_SHEETS_ACCESS_TOKENStatic OAuth2 access token (~1h lifetime) — alternative to the refresh-token trio, mostly for testing.
  • GOOGLE_SHEETS_OAUTH_PORTFixed port for the loopback listener of the in-chat login (127.0.0.1 + PKCE). Set it when the client runs over SSH port forwarding; otherwise a free port is picked per login.
  • GOOGLE_SHEETS_API_BASESheets API root override.
  • GOOGLE_SHEETS_TIMEOUT_MSPer-request timeout in milliseconds.
  • GOOGLE_SHEETS_MAX_RETRIESRetries on transient errors (429 always; 5xx/network for reads).

Pricing

Open source

Google Sheets MCP FAQ

Is Google Sheets MCP free?

Yes. Google Sheets MCP is open source, so you can use and self-host it for free.

How do I add Google Sheets MCP to Claude Code?

Run this command in your terminal: claude mcp add mcp-google-sheets --env GOOGLE_SHEETS_CLIENT_SECRET='<GOOGLE_SHEETS_CLIENT_SECRET>' --env GOOGLE_SHEETS_REFRESH_TOKEN='<GOOGLE_SHEETS_REFRESH_TOKEN>' --env GOOGLE_SHEETS_ACCESS_TOKEN='<GOOGLE_SHEETS_ACCESS_TOKEN>' -- npx -y @a1-x-tech/mcp-google-sheets