Home › Databases & Data › mcp-gsheets

mcp-gsheets

MCP server for Google Sheets API — read, write, format, batch operations.

TypeScript Cloud

★ 100 stars Last pushed 2026-09-20 License: MIT

View repository →

Connect

Review any command before running it. Package names and URLs come from the server's own registry entry.

Package (npm 1.10.3)

npx -y mcp-gsheets@1.10.3

Or add to your MCP client config:

{
  "mcpServers": {
    "mcp-gsheets": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-gsheets@1.10.3"
      ],
      "env": {
        "GOOGLE_PROJECT_ID": "<YOUR_VALUE>",
        "GOOGLE_APPLICATION_CREDENTIALS": "<YOUR_VALUE>",
        "GOOGLE_SERVICE_ACCOUNT_KEY": "<YOUR_VALUE>",
        "GOOGLE_PRIVATE_KEY": "<YOUR_VALUE>",
        "GOOGLE_CLIENT_EMAIL": "<YOUR_VALUE>"
      }
    }
  }
}

GOOGLE_PROJECT_ID required — Google Cloud project ID
GOOGLE_APPLICATION_CREDENTIALS — Path to service account key JSON file (auth method 1)
GOOGLE_SERVICE_ACCOUNT_KEY secret — Service account key as JSON string (auth method 2)
GOOGLE_PRIVATE_KEY secret — Service account private key in PEM format (auth method 3)
GOOGLE_CLIENT_EMAIL — Service account email (auth method 3)