# Google Sheets MCP

> Google Sheets MCP is an open-source MCP server. MCP server for the Google Sheets API: read and write ranges, sheets, formatting, charts, sharing. It runs locally on your machine and is started by your AI client.

- **Kind:** MCP server
- **Pricing:** Open source
- **Repository:** https://github.com/a1-x-tech/mcp-google-sheets
- **MCP Registry name:** io.github.A1-x-Tech/mcp-google-sheets
- **Listing updated:** 2026-11-13

## About

MCP server for the Google Sheets API: read and write ranges, sheets, formatting, charts, sharing.

## Install

### Claude Code (Terminal)

```sh
claude mcp add mcp-google-sheets --env GOOGLE_SHEETS_CLIENT_SECRET='<GOOGLE_SHEETS_CLIENT_SECRET>' --env GOOGLE_SHEETS_REFRESH_TOKEN='<GOOGLE_SHEETS_REFRESH_TOKEN>' --env GOOGLE_SHEETS_ACCESS_TOKEN='<GOOGLE_SHEETS_ACCESS_TOKEN>' -- npx -y @a1-x-tech/mcp-google-sheets
```

### Claude Desktop (claude_desktop_config.json)

```json
{
  "mcpServers": {
    "mcp-google-sheets": {
      "command": "npx",
      "args": [
        "-y",
        "@a1-x-tech/mcp-google-sheets"
      ],
      "env": {
        "GOOGLE_SHEETS_CLIENT_SECRET": "<GOOGLE_SHEETS_CLIENT_SECRET>",
        "GOOGLE_SHEETS_REFRESH_TOKEN": "<GOOGLE_SHEETS_REFRESH_TOKEN>",
        "GOOGLE_SHEETS_ACCESS_TOKEN": "<GOOGLE_SHEETS_ACCESS_TOKEN>"
      }
    }
  }
}
```

### Cursor (~/.cursor/mcp.json)

```json
{
  "mcpServers": {
    "mcp-google-sheets": {
      "command": "npx",
      "args": [
        "-y",
        "@a1-x-tech/mcp-google-sheets"
      ],
      "env": {
        "GOOGLE_SHEETS_CLIENT_SECRET": "<GOOGLE_SHEETS_CLIENT_SECRET>",
        "GOOGLE_SHEETS_REFRESH_TOKEN": "<GOOGLE_SHEETS_REFRESH_TOKEN>",
        "GOOGLE_SHEETS_ACCESS_TOKEN": "<GOOGLE_SHEETS_ACCESS_TOKEN>"
      }
    }
  }
}
```

### VS Code (.vscode/mcp.json)

```json
{
  "servers": {
    "mcp-google-sheets": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@a1-x-tech/mcp-google-sheets"
      ],
      "env": {
        "GOOGLE_SHEETS_CLIENT_SECRET": "<GOOGLE_SHEETS_CLIENT_SECRET>",
        "GOOGLE_SHEETS_REFRESH_TOKEN": "<GOOGLE_SHEETS_REFRESH_TOKEN>",
        "GOOGLE_SHEETS_ACCESS_TOKEN": "<GOOGLE_SHEETS_ACCESS_TOKEN>"
      }
    }
  }
}
```

### Windsurf (~/.codeium/windsurf/mcp_config.json)

```json
{
  "mcpServers": {
    "mcp-google-sheets": {
      "command": "npx",
      "args": [
        "-y",
        "@a1-x-tech/mcp-google-sheets"
      ],
      "env": {
        "GOOGLE_SHEETS_CLIENT_SECRET": "<GOOGLE_SHEETS_CLIENT_SECRET>",
        "GOOGLE_SHEETS_REFRESH_TOKEN": "<GOOGLE_SHEETS_REFRESH_TOKEN>",
        "GOOGLE_SHEETS_ACCESS_TOKEN": "<GOOGLE_SHEETS_ACCESS_TOKEN>"
      }
    }
  }
}
```

### Other clients (your client's MCP settings (most use this shape))

```json
{
  "mcpServers": {
    "mcp-google-sheets": {
      "command": "npx",
      "args": [
        "-y",
        "@a1-x-tech/mcp-google-sheets"
      ],
      "env": {
        "GOOGLE_SHEETS_CLIENT_SECRET": "<GOOGLE_SHEETS_CLIENT_SECRET>",
        "GOOGLE_SHEETS_REFRESH_TOKEN": "<GOOGLE_SHEETS_REFRESH_TOKEN>",
        "GOOGLE_SHEETS_ACCESS_TOKEN": "<GOOGLE_SHEETS_ACCESS_TOKEN>"
      }
    }
  }
}
```

## FAQ

### Is Google Sheets MCP free?

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

### How do I add Google Sheets MCP to Claude Code?

Run this command in your terminal: claude mcp add mcp-google-sheets --env GOOGLE_SHEETS_CLIENT_SECRET='<GOOGLE_SHEETS_CLIENT_SECRET>' --env GOOGLE_SHEETS_REFRESH_TOKEN='<GOOGLE_SHEETS_REFRESH_TOKEN>' --env GOOGLE_SHEETS_ACCESS_TOKEN='<GOOGLE_SHEETS_ACCESS_TOKEN>' -- npx -y @a1-x-tech/mcp-google-sheets

---
Source: https://ai-powered.com/mcp/google-sheets-mcp-2
