mcp-gsheets

Indexed by io.github.freema

About

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

Use this server

Add it to your MCP client. The catalogue lists this config verbatim from its source — it does not run, download, or vouch for the server. Review the command before you run it.

Transportstdio (runs a local command)

Env varsGOOGLE_PROJECT_ID GOOGLE_APPLICATION_CREDENTIALS GOOGLE_SERVICE_ACCOUNT_KEY GOOGLE_PRIVATE_KEY GOOGLE_CLIENT_EMAIL

Claude Code

claude mcp add --env GOOGLE_PROJECT_ID= --env GOOGLE_APPLICATION_CREDENTIALS= --env GOOGLE_SERVICE_ACCOUNT_KEY= --env GOOGLE_PRIVATE_KEY= --env GOOGLE_CLIENT_EMAIL= mcp-gsheets -- npx mcp-gsheets

Cursor

Add to Cursor

If the button doesn't open Cursor, use the JSON below — Cursor accepts the same mcpServers config.

VS Code

code --add-mcp '{"name":"mcp-gsheets","command":"npx","args":["mcp-gsheets"],"env":{"GOOGLE_PROJECT_ID":"","GOOGLE_APPLICATION_CREDENTIALS":"","GOOGLE_SERVICE_ACCOUNT_KEY":"","GOOGLE_PRIVATE_KEY":"","GOOGLE_CLIENT_EMAIL":""}}'

JSON

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

Environment variables are listed by name only — fill in your own values. Entries never carry secrets.