PluginBench
MCP Server
Active

Google Sheets MCP Server

io.github.domdomegg/google-sheets-mcp

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 server?

Allow AI systems to read, write, and query spreadsheet data via Google Sheets.

How to install Google Sheets

Copy-paste configuration for popular MCP clients.

transport: stdio
Config generated by PluginBench — verify against the source before use.
Environment / auth
  • GOOGLE_ACCESS_TOKEN
    required
    secret

    Google OAuth access token with Sheets scopes.

  • MCP_TRANSPORT
    required

    Transport type.

  • GOOGLE_CLIENT_ID
    required

    Google OAuth client ID.

  • GOOGLE_CLIENT_SECRET
    required
    secret

    Google OAuth client secret.

~/Library/Application Support/Claude/claude_desktop_config.json
JSON config
{
  "mcpServers": {
    "google-sheets-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "google-sheets-mcp"
      ],
      "env": {
        "GOOGLE_ACCESS_TOKEN": "<YOUR_GOOGLE_ACCESS_TOKEN>",
        "MCP_TRANSPORT": "<YOUR_MCP_TRANSPORT>",
        "GOOGLE_CLIENT_ID": "<YOUR_GOOGLE_CLIENT_ID>",
        "GOOGLE_CLIENT_SECRET": "<YOUR_GOOGLE_CLIENT_SECRET>"
      }
    }
  }
}

Related MCP servers

Search and contribute to the Open Food Facts database.

3
TypeScript
MIT
View repository →
SHShell Exec logo

Execute bash commands with background job support.

6
TypeScript
View repository →

Allow AI systems to view and control your Starling Bank account via MCP.

1
TypeScript
MIT
View repository →

Get the current UTC time in RFC 3339 format.

Get the current UTC time in RFC 3339 format.

4
Python
MIT
View repository →

Secure permission layer between AI agents and your .env files

0
TypeScript
View repository →