MCP serverCommunity

io.github.freema/mcp-gsheets

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

freema · ↓ 0 installs

Install

Add the config to your client settings. Replace values in <angle brackets> with your own.

claude_desktop_config.json

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

Tools

The tool list will appear once the server has a sandbox or the editors fill it in.

Report a problem ↗ (Opens GitHub in a new tab)