G

Google Sheets MCP

MCP server · by A1-x-Tech

Developer Tools npm v1.0.0

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

View source ↗ Website ↗ Generate config for multiple servers More servers

Install

registry version 1.0.0

npm
npx -y @a1-x-tech/mcp-google-sheets

Setup by client

Pick your client — the config below is generated for this server (local stdio). Copy respects the “Pin version” switch above.

claude_desktop_config.json

{
  "mcpServers": {
    "mcp-google-sheets": {
      "command": "npx",
      "args": [
        "-y",
        "@a1-x-tech/mcp-google-sheets"
      ],
      "env": {
        "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>"
      }
    }
  }
}

Format verified against the official Claude Desktop docs ↗.

Environment variables

Defined in the server's official registry manifest. Required secrets are shown as <YOUR_…> placeholders in the configs above.

  • 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).

GitHub

⭐ 1 stars · 最近更新于 25 天前 · MIT license

About this server

Google Sheets MCP English Русский A1 Google Sheets MCP lets an AI app work with Google Sheets in plain language. Find a spreadsheet, read its data, write and append rows, shape sheets and formatting, build charts and share the result. It uses the G…

Summary from the project README — github.com/A1-x-Tech/mcp-google-sheets

Distributed as npm, listed under Developer Tools. Review our MCP security guide before granting access to real data.

Frequently asked questions

What does the Google Sheets MCP MCP server do?

Google Sheets MCP English Русский A1 Google Sheets MCP lets an AI app work with Google Sheets in plain language. Find a spreadsheet, read its data, write and append rows, shape sheets and formatting, build charts and share the result. It uses the G

How do I install Google Sheets MCP?

Run the install command shown above, then paste the config for your client (Claude Desktop, Claude Code, Cursor, VS Code or Windsurf) into its MCP settings and restart the client.

Is Google Sheets MCP free to use?

The MCP server itself is free to install. The source is public on https://github.com/A1-x-Tech/mcp-google-sheets. Any third-party service it calls may require its own API key and account.

Which clients support Google Sheets MCP?

Any MCP-compatible client can use it, including Claude Desktop, Claude Code, Cursor, VS Code, Windsurf and custom agents.

Add this badge

Publish this server? Link back with a badge on your README or site — copy either snippet.

Listed on MCPNav

Markdown

[![Listed on MCPNav](https://mcpnav.net/badge/mcp-google-sheets.svg)](https://mcpnav.net/server/mcp-google-sheets/)

HTML

<a href="https://mcpnav.net/server/mcp-google-sheets/"><img src="https://mcpnav.net/badge/mcp-google-sheets.svg" alt="Listed on MCPNav" height="20"></a>