PluginBench
MCP Server

Google Sheets MCP Server

io.github.mcp-z/mcp-sheets

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

Google Sheets integration with OAuth, spreadsheet management, batch operations, and formatting

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_CLIENT_ID
    required

    Google OAuth client ID (required for OAuth authentication modes)

  • GOOGLE_CLIENT_SECRET
    secret

    Google OAuth client secret (optional for public clients)

  • GOOGLE_SERVICE_ACCOUNT_KEY_FILE

    Path to service account JSON key file (required for service-account auth mode)

  • AUTH_MODE

    Authentication mode

  • HEADLESS

    Disable browser auto-open, return auth URL instead (true/false)

  • REDIRECT_URI

    OAuth redirect URI (optional, default: ephemeral loopback)

  • RESOURCE_STORE_URI

    Resource store URI for exported files (file://)

  • PORT

    HTTP server port (overrides --port)

  • BASE_URL

    Base URL for HTTP transport (used for OAuth/DCR endpoints and file links)

  • LOG_LEVEL

    Logging level

  • DCR_MODE

    Dynamic Client Registration mode

  • DCR_VERIFY_URL

    External verification endpoint URL (required for external DCR mode)

  • DCR_STORE_URI

    DCR client storage URI (for self-hosted DCR mode)

~/Library/Application Support/Claude/claude_desktop_config.json
JSON config
{
  "mcpServers": {
    "mcp-sheets": {
      "command": "npx",
      "args": [
        "-y",
        "@mcp-z/mcp-sheets",
        "-y",
        "--auth",
        "--headless",
        "--redirect-uri",
        "--service-account-key-file",
        "--resource-store-uri",
        "--base-url",
        "--log-level"
      ],
      "env": {
        "GOOGLE_CLIENT_ID": "<YOUR_GOOGLE_CLIENT_ID>",
        "GOOGLE_CLIENT_SECRET": "<YOUR_GOOGLE_CLIENT_SECRET>",
        "GOOGLE_SERVICE_ACCOUNT_KEY_FILE": "<YOUR_GOOGLE_SERVICE_ACCOUNT_KEY_FILE>",
        "AUTH_MODE": "<YOUR_AUTH_MODE>",
        "HEADLESS": "<YOUR_HEADLESS>",
        "REDIRECT_URI": "<YOUR_REDIRECT_URI>",
        "RESOURCE_STORE_URI": "<YOUR_RESOURCE_STORE_URI>",
        "PORT": "<YOUR_PORT>",
        "BASE_URL": "<YOUR_BASE_URL>",
        "LOG_LEVEL": "<YOUR_LOG_LEVEL>",
        "DCR_MODE": "<YOUR_DCR_MODE>",
        "DCR_VERIFY_URL": "<YOUR_DCR_VERIFY_URL>",
        "DCR_STORE_URI": "<YOUR_DCR_STORE_URI>"
      }
    }
  }
}

Related MCP servers

Google Drive integration with file operations, folder navigation, search, and sharing

Gmail integration with OAuth authentication, message search, batch operations, and Sheets export

Outlook integration with OAuth, message search, batch operations, and calendar management

MCP server for creative PDF generation with full emoji, Unicode, and offline support

Consulta o Bulário Eletrônico da ANVISA: bulas, registros, tarjas e apresentações.

View repository →

Consulta o CNES (estabelecimentos de saúde): profissionais, leitos, equipamentos, serviços.

View repository →