mcp-gsheets

local MCP server

Installation

Terminal

claude mcp add mcp-gsheets -e GOOGLE_PROJECT_ID=... -e GOOGLE_APPLICATION_CREDENTIALS=... -e GOOGLE_SERVICE_ACCOUNT_KEY=... -e GOOGLE_PRIVATE_KEY=... -e GOOGLE_CLIENT_EMAIL=... -- npx -y mcp-gsheets

Run in your project folder. Add --scope user to use it everywhere.

Claude Desktop, Cursor & other clients

Add to claude_desktop_config.json or .cursor/mcp.json.

{
  "mcpServers": {
    "mcp-gsheets": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-gsheets"
      ],
      "env": {
        "GOOGLE_PROJECT_ID": "...",
        "GOOGLE_APPLICATION_CREDENTIALS": "...",
        "GOOGLE_SERVICE_ACCOUNT_KEY": "...",
        "GOOGLE_PRIVATE_KEY": "...",
        "GOOGLE_CLIENT_EMAIL": "..."
      }
    }
  }
}

Fill in the environment variables with your own credentials.

Summary

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

Questions

mcp-gsheets is a local MCP server distributed as the npm package mcp-gsheets.

Run: claude mcp add mcp-gsheets -e GOOGLE_PROJECT_ID=... -e GOOGLE_APPLICATION_CREDENTIALS=... -e GOOGLE_SERVICE_ACCOUNT_KEY=... -e GOOGLE_PRIVATE_KEY=... -e GOOGLE_CLIENT_EMAIL=... -- npx -y mcp-gsheets

Run: codex mcp add mcp-gsheets --env GOOGLE_PROJECT_ID=... --env GOOGLE_APPLICATION_CREDENTIALS=... --env GOOGLE_SERVICE_ACCOUNT_KEY=... --env GOOGLE_PRIVATE_KEY=... --env GOOGLE_CLIENT_EMAIL=... -- npx -y mcp-gsheets

Similar MCP servers

NameStars

remote-filesystemcom.pulsemcp/remote-filesystem80
email-mcpio.github.marlinjai/email-mcp22
Google Workspaceio.github.mindstone/mcp-server-google-workspace12
mcp-server-searchio.github.bytedance/mcp-server-search39K
Desktop Commanderio.github.wonderwhy-er/desktop-commander9,802
DBHubio.github.bytebase/dbhub3,574
Radar Kubernetes MCP Serverio.github.skyhook-io/radar3,517
ProxmoxMCP-Plusio.github.RekklesNA/proxmox-mcp-plus559