Google Sheets MCP Server

Connect this server

This server runs on your own machine — install it with the package manager and the client starts it for you. Package name taken from the official registry entry.

claude mcp add mcp-sheets -e 'GOOGLE_CLIENT_ID=<GOOGLE_CLIENT_ID>' -- npx -y @mcp-z/mcp-sheets

{
  "mcpServers": {
    "mcp-sheets": {
      "command": "npx",
      "args": [
        "-y",
        "@mcp-z/mcp-sheets"
      ],
      "env": {
        "GOOGLE_CLIENT_ID": "<GOOGLE_CLIENT_ID>"
      }
    }
  }
}

[mcp_servers.mcp-sheets]
command = "npx"
args = ["-y", "@mcp-z/mcp-sheets"]
env = { GOOGLE_CLIENT_ID = "<GOOGLE_CLIENT_ID>" }

{
  "mcpServers": {
    "mcp-sheets": {
      "command": "npx",
      "args": [
        "-y",
        "@mcp-z/mcp-sheets"
      ],
      "env": {
        "GOOGLE_CLIENT_ID": "<GOOGLE_CLIENT_ID>"
      }
    }
  }
}

{
  "servers": {
    "mcp-sheets": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@mcp-z/mcp-sheets"
      ],
      "env": {
        "GOOGLE_CLIENT_ID": "<GOOGLE_CLIENT_ID>"
      }
    }
  }
}

Put your own value in place of <GOOGLE_CLIENT_ID> (Google OAuth client ID (required for OAuth authentication modes)). The author’s registry entry marks it as required.

Optional settings from the registry entry, left out of the block above: GOOGLE_CLIENT_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)), 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).