Google Sheets MCP Server

Connect to Google Sheets

Hosted endpoint — paste into any MCP client.

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.

• Website