Gsheets MCP Server

by freemaio.github.freema/mcp-gsheetsv1.10.3

Google Sheets API integration for reading, writing, formatting and sheet management.

100Node.jsstdioofficial registry

context tax

queued

security

queued

cold start

queued

freshness

Active7d ago

Install Gsheets MCP server

claude mcp add gsheets -e GOOGLE_PROJECT_ID='<google-project-id>' -e GOOGLE_SERVICE_ACCOUNT_KEY='<google-service-account-key>' -e GOOGLE_PRIVATE_KEY='<google-private-key>' -- npx -y mcp-gsheets

{
  "mcpServers": {
    "gsheets": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-gsheets"
      ],
      "env": {
        "GOOGLE_PROJECT_ID": "<google-project-id>",
        "GOOGLE_SERVICE_ACCOUNT_KEY": "<google-service-account-key>",
        "GOOGLE_PRIVATE_KEY": "<google-private-key>"
      }
    }
  }
}

Add to ~/.cursor/mcp.json (global) or .cursor/mcp.json (project).

{
  "mcpServers": {
    "gsheets": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-gsheets"
      ],
      "env": {
        "GOOGLE_PROJECT_ID": "<google-project-id>",
        "GOOGLE_SERVICE_ACCOUNT_KEY": "<google-service-account-key>",
        "GOOGLE_PRIVATE_KEY": "<google-private-key>"
      }
    }
  }
}

Settings → Developer → Edit Config (claude_desktop_config.json), then restart.

{
  "servers": {
    "gsheets": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "mcp-gsheets"
      ],
      "env": {
        "GOOGLE_PROJECT_ID": "<google-project-id>",
        "GOOGLE_SERVICE_ACCOUNT_KEY": "<google-service-account-key>",
        "GOOGLE_PRIVATE_KEY": "<google-private-key>"
      }
    }
  }
}

Add to .vscode/mcp.json in your workspace.

{
  "mcpServers": {
    "gsheets": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-gsheets"
      ],
      "env": {
        "GOOGLE_PROJECT_ID": "<google-project-id>",
        "GOOGLE_SERVICE_ACCOUNT_KEY": "<google-service-account-key>",
        "GOOGLE_PRIVATE_KEY": "<google-private-key>"
      }
    }
  }
}

Add to ~/.codeium/windsurf/mcp_config.json.

Configuration

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

Freshness

Active — last maintenance signal 7d ago. The newest of the signals below sets the band.

Last commit (default branch)
2026-10-02 · 7d ago · GitHub
Latest release
2026-09-19 · 20d ago · GitHub · v1.10.3
Package published
no data · npm/PyPI
Registry entry updated
2026-09-19 · 20d ago · official registry · v1.10.3

FAQ

›How do I install the Gsheets MCP server in Claude Code?

Run: claude mcp add gsheets -e GOOGLE_PROJECT_ID='<google-project-id>' -e GOOGLE_SERVICE_ACCOUNT_KEY='<google-service-account-key>' -e GOOGLE_PRIVATE_KEY='<google-private-key>' -- npx -y mcp-gsheets. For Cursor, VS Code, Claude Desktop and Windsurf, use the install tabs above.

›Does Gsheets require an API key?

Yes. It expects GOOGLE_PROJECT_ID, GOOGLE_SERVICE_ACCOUNT_KEY, GOOGLE_PRIVATE_KEY, of which 2 are secrets.

›Can I use Gsheets as a remote (hosted) MCP server?

No hosted endpoint is published; it runs locally over stdio.

›Is Gsheets in the official MCP registry?

Yes, as io.github.freema/mcp-gsheets.