Google Sheets MCP MCP Server

io.github.A1-x-Tech/mcp-google-sheets

Repository Registry

What is the Google Sheets MCP MCP server?

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

How to install Google Sheets MCP

Copy-paste configuration for popular MCP clients.

transport: stdio

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

Environment / auth

GOOGLE_SHEETS_CLIENT_ID
Google OAuth2 client id (refresh-token flow).
GOOGLE_SHEETS_CLIENT_SECRET
secret
Google OAuth2 client secret (refresh-token flow). Treat it as a secret.
GOOGLE_SHEETS_REFRESH_TOKEN
secret
Google OAuth2 refresh token, exchanged for access tokens automatically. Treat it as a secret.
GOOGLE_SHEETS_ACCESS_TOKEN
secret
Static OAuth2 access token (~1h lifetime) — alternative to the refresh-token trio, mostly for testing.
GOOGLE_SHEETS_OAUTH_PORT
Fixed 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_BASE
Sheets API root override.
GOOGLE_SHEETS_TIMEOUT_MS
Per-request timeout in milliseconds.
GOOGLE_SHEETS_MAX_RETRIES
Retries on transient errors (429 always; 5xx/network for reads).

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

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

Related MCP servers

Google Slides MCP

Active

MCP server for the Google Slides API: presentations, slides, text, shapes, images and tables.

TypeScript

MIT

View repository →

Google Tag Manager MCP

Active

MCP server for the Google Tag Manager API v2: containers, workspaces, tags, triggers, publishing.

TypeScript

MIT

View repository →

Google Tasks MCP

MCP server for the Google Tasks API: task lists, subtasks, due dates, complete and move tasks.

View repository →

Shopify Admin MCP

Active

MCP server for the Shopify Admin API: products, orders, customers, inventory, discounts.

TypeScript

MIT

View repository →

Yandex Audience MCP

Active

MCP server for Yandex Audience API: segments (CRM, lookalike, pixel), pixels, grants.

TypeScript

MIT

View repository →

Yandex Delivery MCP

Active

MCP server for the Yandex Delivery B2B API: express claims, tracking, NDD/pickup-point orders.

TypeScript

MIT

View repository →