Skip to content
MCP server

Google Sheets

Google Sheets integration with OAuth, spreadsheet management, batch operations, and…

Install
Runs
Locally or Remotely
Version
2.6.1
Listing updated
5 days ago

About Google Sheets

Google Sheets is an MCP server. It can run locally on your machine or as a hosted remote server.

Google Sheets integration with OAuth, spreadsheet management, batch operations, and formatting

Install

Run in a terminal

claude mcp add mcp-sheets --env GOOGLE_CLIENT_ID='<GOOGLE_CLIENT_ID>' --env GOOGLE_CLIENT_SECRET='<GOOGLE_CLIENT_SECRET>' -- npx -y @mcp-z/mcp-sheets

Add to claude_desktop_config.json

{
  "mcpServers": {
    "mcp-sheets": {
      "command": "npx",
      "args": [
        "-y",
        "@mcp-z/mcp-sheets"
      ],
      "env": {
        "GOOGLE_CLIENT_ID": "<GOOGLE_CLIENT_ID>",
        "GOOGLE_CLIENT_SECRET": "<GOOGLE_CLIENT_SECRET>"
      }
    }
  }
}

Add to ~/.cursor/mcp.json

{
  "mcpServers": {
    "mcp-sheets": {
      "command": "npx",
      "args": [
        "-y",
        "@mcp-z/mcp-sheets"
      ],
      "env": {
        "GOOGLE_CLIENT_ID": "<GOOGLE_CLIENT_ID>",
        "GOOGLE_CLIENT_SECRET": "<GOOGLE_CLIENT_SECRET>"
      }
    }
  }
}

Add to .vscode/mcp.json

{
  "servers": {
    "mcp-sheets": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@mcp-z/mcp-sheets"
      ],
      "env": {
        "GOOGLE_CLIENT_ID": "<GOOGLE_CLIENT_ID>",
        "GOOGLE_CLIENT_SECRET": "<GOOGLE_CLIENT_SECRET>"
      }
    }
  }
}

Add to ~/.codeium/windsurf/mcp_config.json

{
  "mcpServers": {
    "mcp-sheets": {
      "command": "npx",
      "args": [
        "-y",
        "@mcp-z/mcp-sheets"
      ],
      "env": {
        "GOOGLE_CLIENT_ID": "<GOOGLE_CLIENT_ID>",
        "GOOGLE_CLIENT_SECRET": "<GOOGLE_CLIENT_SECRET>"
      }
    }
  }
}

Add to your client's MCP settings (most use this shape)

{
  "mcpServers": {
    "mcp-sheets": {
      "command": "npx",
      "args": [
        "-y",
        "@mcp-z/mcp-sheets"
      ],
      "env": {
        "GOOGLE_CLIENT_ID": "<GOOGLE_CLIENT_ID>",
        "GOOGLE_CLIENT_SECRET": "<GOOGLE_CLIENT_SECRET>"
      }
    }
  }
}

Using several servers? Build one config file with the MCP config generator.

Configuration

  • GOOGLE_CLIENT_IDGoogle OAuth client ID (required for OAuth authentication modes)Required
  • GOOGLE_CLIENT_SECRETGoogle OAuth client secret (optional for public clients)
  • GOOGLE_SERVICE_ACCOUNT_KEY_FILEPath to service account JSON key file (required for service-account auth mode)
  • AUTH_MODEAuthentication mode
  • HEADLESSDisable browser auto-open, return auth URL instead (true/false)
  • REDIRECT_URIOAuth redirect URI (optional, default: ephemeral loopback)
  • RESOURCE_STORE_URIResource store URI for exported files (file://)
  • PORTHTTP server port (overrides --port)
  • BASE_URLBase URL for HTTP transport (used for OAuth/DCR endpoints and file links)
  • LOG_LEVELLogging level
  • GOOGLE_CLIENT_IDGoogle OAuth client ID (required for OAuth authentication modes)Required
  • GOOGLE_CLIENT_SECRETGoogle OAuth client secret (optional for public clients)
  • GOOGLE_SERVICE_ACCOUNT_KEY_FILEPath to service account JSON key file (required for service-account auth mode)
  • AUTH_MODEAuthentication mode
  • HEADLESSDisable browser auto-open, return auth URL instead (true/false)
  • REDIRECT_URIOAuth redirect URI (optional, default: ephemeral loopback)
  • DCR_MODEDynamic Client Registration mode
  • DCR_VERIFY_URLExternal verification endpoint URL (required for external DCR mode)
  • DCR_STORE_URIDCR client storage URI (for self-hosted DCR mode)
  • RESOURCE_STORE_URIResource store URI for exported files (file://)
  • PORTHTTP server port (overrides --port)
  • BASE_URLBase URL for HTTP transport (used for OAuth/DCR endpoints and file links)
  • LOG_LEVELLogging level

Google Sheets FAQ

How do I add Google Sheets to Claude Code?

Run this command in your terminal: claude mcp add mcp-sheets --env GOOGLE_CLIENT_ID='<GOOGLE_CLIENT_ID>' --env GOOGLE_CLIENT_SECRET='<GOOGLE_CLIENT_SECRET>' -- npx -y @mcp-z/mcp-sheets

Where this comes from

  • Description: from the official MCP Registry entry.
  • Install steps: from the official MCP Registry entry.

How AIPoweredBot checks servers