Google Sheets MCP Server

Customize > Connectors > Add > Add custom connector, paste this URL and sign in. It syncs to Claude Desktop and mobile. docs

https://sheetsmcp.googleapis.com/mcp/v1

The free plan allows one custom connector. On Team and Enterprise an owner adds it under Organization settings > Connectors.

chatgpt.com/plugins > + > Add custom MCP server, paste the URL, set up sign-in and create it as a plugin. Then @-mention it in a chat. docs

https://sheetsmcp.googleapis.com/mcp/v1

Workspace admins can turn custom MCP plugins off.

Add to ~/.cursor/mcp.json (all projects) or .cursor/mcp.json (this project), or use the install button. docs

{
  "mcpServers": {
    "google-sheets": {
      "url": "https://sheetsmcp.googleapis.com/mcp/v1"
    }
  }
}

Add to .vscode/mcp.json (note the "servers" key and the type), or use the install button. Command Palette > "MCP: Open User Configuration" for all workspaces. docs

{
  "servers": {
    "google-sheets": {
      "type": "http",
      "url": "https://sheetsmcp.googleapis.com/mcp/v1"
    }
  }
}

Run codex mcp add google-sheets --url https://sheetsmcp.googleapis.com/mcp/v1 (then codex mcp login google-sheets), or add this to ~/.codex/config.toml. The CLI, IDE extension and Codex app share it. docs

[mcp_servers.google-sheets]
url = "https://sheetsmcp.googleapis.com/mcp/v1"

Run in a terminal (-s user adds it for all projects), then /mcp auth to sign in. In ~/.gemini/settings.json the key is httpUrl. docs

gemini mcp add -s user --transport http google-sheets https://sheetsmcp.googleapis.com/mcp/v1

Run in a terminal; it writes ~/.copilot/mcp-config.json. docs

copilot mcp add --transport http google-sheets https://sheetsmcp.googleapis.com/mcp/v1

Add to mcp_config.json: ~/.config/devin/mcp_config.json on macOS and Linux (older installs: ~/.codeium/windsurf/mcp_config.json), %APPDATA%\devin\ on Windows. docs

{
  "mcpServers": {
    "google-sheets": {
      "serverUrl": "https://sheetsmcp.googleapis.com/mcp/v1"
    }
  }
}

Add to Zed's settings.json (or Settings > AI > MCP Servers > Add Server). Remote servers without an Authorization header sign in with OAuth. docs

{
  "context_servers": {
    "google-sheets": {
      "url": "https://sheetsmcp.googleapis.com/mcp/v1"
    }
  }
}

Add to opencode.json in the project (or ~/.config/opencode/opencode.json). Sign in with opencode mcp auth google-sheets. docs

{
  "$schema": "https://opencode.ai/config.json",
  "mcp": {
    "google-sheets": {
      "type": "remote",
      "url": "https://sheetsmcp.googleapis.com/mcp/v1",
      "enabled": true
    }
  }
}

Add to ~/.kiro/settings/mcp.json (all projects) or .kiro/settings/mcp.json (this project). docs

{
  "mcpServers": {
    "google-sheets": {
      "url": "https://sheetsmcp.googleapis.com/mcp/v1"
    }
  }
}

MCP Servers > Configure > Configure MCP Servers opens cline_mcp_settings.json; add this entry. docs

{
  "mcpServers": {
    "google-sheets": {
      "type": "streamableHttp",
      "url": "https://sheetsmcp.googleapis.com/mcp/v1"
    }
  }
}