mcp-gsheets

mcp-gsheets is a local MCP server: MCP server for Google Sheets API — read, write, format, batch operations. Install it from npm as mcp-gsheets.

Claude CodeCodexAntigravity

commandprompt

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.

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.

• Runtime: Node.js 18+ (runs with npx).
• MCP client: Claude Code, Codex, Antigravity, Claude Desktop, Cursor or any other client that speaks MCP over stdio.
• Environment variables: GOOGLE_PROJECT_ID, GOOGLE_APPLICATION_CREDENTIALS, GOOGLE_SERVICE_ACCOUNT_KEY, GOOGLE_PRIVATE_KEY, GOOGLE_CLIENT_EMAIL