Skip to content
MCP server

Google Sheets

Allow AI systems to read, write, and query spreadsheet data via Google Sheets.

Install
Pricing
Open source
Runs
Locally or Remotely
Version
1.2.1
Listing updated
5 days ago

About Google Sheets

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

Install

Run in a terminal

claude mcp add google-sheets-mcp --env GOOGLE_ACCESS_TOKEN='<GOOGLE_ACCESS_TOKEN>' -- npx -y google-sheets-mcp

Add to claude_desktop_config.json

{
  "mcpServers": {
    "google-sheets-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "google-sheets-mcp"
      ],
      "env": {
        "GOOGLE_ACCESS_TOKEN": "<GOOGLE_ACCESS_TOKEN>"
      }
    }
  }
}

Add to ~/.cursor/mcp.json

{
  "mcpServers": {
    "google-sheets-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "google-sheets-mcp"
      ],
      "env": {
        "GOOGLE_ACCESS_TOKEN": "<GOOGLE_ACCESS_TOKEN>"
      }
    }
  }
}

Add to .vscode/mcp.json

{
  "servers": {
    "google-sheets-mcp": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "google-sheets-mcp"
      ],
      "env": {
        "GOOGLE_ACCESS_TOKEN": "<GOOGLE_ACCESS_TOKEN>"
      }
    }
  }
}

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

{
  "mcpServers": {
    "google-sheets-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "google-sheets-mcp"
      ],
      "env": {
        "GOOGLE_ACCESS_TOKEN": "<GOOGLE_ACCESS_TOKEN>"
      }
    }
  }
}

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

{
  "mcpServers": {
    "google-sheets-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "google-sheets-mcp"
      ],
      "env": {
        "GOOGLE_ACCESS_TOKEN": "<GOOGLE_ACCESS_TOKEN>"
      }
    }
  }
}

Configuration

  • GOOGLE_ACCESS_TOKENGoogle OAuth access token with Sheets scopes.Required
  • MCP_TRANSPORTTransport type.Required
  • GOOGLE_CLIENT_IDGoogle OAuth client ID.Required
  • GOOGLE_CLIENT_SECRETGoogle OAuth client secret.Required

Pricing

Open source

Google Sheets FAQ

Is Google Sheets free?

Yes. Google Sheets is open source, so you can use and self-host it for free.

How do I add Google Sheets to Claude Code?

Run this command in your terminal: claude mcp add google-sheets-mcp --env GOOGLE_ACCESS_TOKEN='<GOOGLE_ACCESS_TOKEN>' -- npx -y google-sheets-mcp