PluginBench
MCP Server
Active
MIT

Google Sheets MCP MCP Server

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

RepositoryRegistry
How to choose

What this kind of tool is for

  • Query, inspect, or seed a database without writing a one-off script.
  • Let your agent look up schema details before it writes migration code.
  • Move a small dataset between tools without leaving the terminal.

How to compare servers like this

Engine match:
Confirm it speaks your exact database and version, not just the family.
Access scope:
Read-only connections are the safe default — start there before granting writes.
Safety rails:
Check whether destructive statements need an explicit confirmation before they run.
Maintenance signal:
Database drivers change; a recently updated tool is less likely to break mid-query.

This page carries your copy-paste config: pick your MCP client in the install section on this page and use the copy button.

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
JSON config
{
  "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

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

1
TypeScript
MIT
View repository →

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

0
TypeScript
MIT
View repository →

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

View repository →

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

0
TypeScript
MIT
View repository →

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

0
TypeScript
MIT
View repository →

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

0
TypeScript
MIT
View repository →