PluginBench
MCP Server

io.github.freema/mcp-gsheets MCP Server

io.github.freema/mcp-gsheets

RepositoryRegistry

What is the io.github.freema/mcp-gsheets MCP server?

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

How to install io.github.freema/mcp-gsheets

Copy-paste configuration for popular MCP clients.

transport: stdio
Config generated by PluginBench — verify against the source before use.
Environment / auth
  • GOOGLE_PROJECT_ID
    required

    Google Cloud project ID

  • GOOGLE_APPLICATION_CREDENTIALS

    Path to service account key JSON file (auth method 1)

  • GOOGLE_SERVICE_ACCOUNT_KEY
    secret

    Service account key as JSON string (auth method 2)

  • GOOGLE_PRIVATE_KEY
    secret

    Service account private key in PEM format (auth method 3)

  • GOOGLE_CLIENT_EMAIL

    Service account email (auth method 3)

Claude Desktop
~/Library/Application Support/Claude/claude_desktop_config.json
{
  "mcpServers": {
    "mcp-gsheets": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-gsheets"
      ],
      "env": {
        "GOOGLE_PROJECT_ID": "<YOUR_GOOGLE_PROJECT_ID>",
        "GOOGLE_APPLICATION_CREDENTIALS": "<YOUR_GOOGLE_APPLICATION_CREDENTIALS>",
        "GOOGLE_SERVICE_ACCOUNT_KEY": "<YOUR_GOOGLE_SERVICE_ACCOUNT_KEY>",
        "GOOGLE_PRIVATE_KEY": "<YOUR_GOOGLE_PRIVATE_KEY>",
        "GOOGLE_CLIENT_EMAIL": "<YOUR_GOOGLE_CLIENT_EMAIL>"
      }
    }
  }
}
Cursor
~/.cursor/mcp.json
{
  "mcpServers": {
    "mcp-gsheets": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-gsheets"
      ],
      "env": {
        "GOOGLE_PROJECT_ID": "<YOUR_GOOGLE_PROJECT_ID>",
        "GOOGLE_APPLICATION_CREDENTIALS": "<YOUR_GOOGLE_APPLICATION_CREDENTIALS>",
        "GOOGLE_SERVICE_ACCOUNT_KEY": "<YOUR_GOOGLE_SERVICE_ACCOUNT_KEY>",
        "GOOGLE_PRIVATE_KEY": "<YOUR_GOOGLE_PRIVATE_KEY>",
        "GOOGLE_CLIENT_EMAIL": "<YOUR_GOOGLE_CLIENT_EMAIL>"
      }
    }
  }
}
Windsurf
~/.codeium/windsurf/mcp_config.json
{
  "mcpServers": {
    "mcp-gsheets": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-gsheets"
      ],
      "env": {
        "GOOGLE_PROJECT_ID": "<YOUR_GOOGLE_PROJECT_ID>",
        "GOOGLE_APPLICATION_CREDENTIALS": "<YOUR_GOOGLE_APPLICATION_CREDENTIALS>",
        "GOOGLE_SERVICE_ACCOUNT_KEY": "<YOUR_GOOGLE_SERVICE_ACCOUNT_KEY>",
        "GOOGLE_PRIVATE_KEY": "<YOUR_GOOGLE_PRIVATE_KEY>",
        "GOOGLE_CLIENT_EMAIL": "<YOUR_GOOGLE_CLIENT_EMAIL>"
      }
    }
  }
}
VS Code
.vscode/mcp.json
{
  "servers": {
    "mcp-gsheets": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "mcp-gsheets"
      ],
      "env": {
        "GOOGLE_PROJECT_ID": "<YOUR_GOOGLE_PROJECT_ID>",
        "GOOGLE_APPLICATION_CREDENTIALS": "<YOUR_GOOGLE_APPLICATION_CREDENTIALS>",
        "GOOGLE_SERVICE_ACCOUNT_KEY": "<YOUR_GOOGLE_SERVICE_ACCOUNT_KEY>",
        "GOOGLE_PRIVATE_KEY": "<YOUR_GOOGLE_PRIVATE_KEY>",
        "GOOGLE_CLIENT_EMAIL": "<YOUR_GOOGLE_CLIENT_EMAIL>"
      }
    }
  }
}
Claude Code
claude mcp add mcp-gsheets --env GOOGLE_PROJECT_ID=<YOUR_GOOGLE_PROJECT_ID> --env GOOGLE_APPLICATION_CREDENTIALS=<YOUR_GOOGLE_APPLICATION_CREDENTIALS> --env GOOGLE_SERVICE_ACCOUNT_KEY=<YOUR_GOOGLE_SERVICE_ACCOUNT_KEY> --env GOOGLE_PRIVATE_KEY=<YOUR_GOOGLE_PRIVATE_KEY> --env GOOGLE_CLIENT_EMAIL=<YOUR_GOOGLE_CLIENT_EMAIL> -- npx -y mcp-gsheets

Related MCP servers

OpenClaw MCP Server

MCP server bridging Claude.ai/Desktop with self-hosted OpenClaw via OAuth 2.1.

View repository →