MCP ServerSTDIOOfficialv1.0.7

Google Sheets MCP Server

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

io.github.mcp-z/mcp-sheets

Hosted URL

https://github.com/mcp-z/mcp-sheets#readme

Transport

STDIO

Auth

2 required env vars

What the Google Sheets MCP server does

How models use it and what it is built for.

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

Connect to Google Sheets

Hosted endpoint — paste into any MCP client.

https://github.com/mcp-z/mcp-sheets#readme

Environment variables

Configuration this server reads at startup.

  • GOOGLE_CLIENT_IDRequired

    Google OAuth client ID (required for OAuth authentication modes)

  • GOOGLE_CLIENT_IDRequired

    Google OAuth client ID (required for OAuth authentication modes)

  • GOOGLE_CLIENT_SECRETSecret

    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

  • GOOGLE_CLIENT_SECRETSecret

    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)

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

  • 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

Resources

Where to find authoritative docs and source for Google Sheets.

Skip the local setup — run MCP in your browser

MCP Playground runs 10,000+ hosted MCP servers — GitHub, Linear, Notion, Stripe, Sentry and more — across Claude, GPT, Gemini, DeepSeek and 30+ AI models. Compare model answers side-by-side, save agent presets, share runs. Zero install.

Open Agent Studio

Related servers

More on MCP Playground