# MCP Google Sheets (MCP server)

> MCP Google Sheets is an MCP server that adds productivity tools to AI assistants such as Claude Desktop, Claude Code and Cursor. This MCP server integrates with your Google Drive and Google Sheets, to enable creating and modifying spreadsheets. It has 1,011 GitHub stars, is released under the MIT license and runs locally with uvx mcp-google-sheets.

Your AI Assistant's Gateway to Google Sheets! 📊 mcp-google-sheets is a Python-based MCP server that acts as a bridge between any MCP-compatible client (like Claude Desktop) and the Google Sheets API. It allows you to interact with your Google Spreadsheets using a defined set of tools, enabling powerful automation and data manipulation workflows driven by AI.

## Key facts

| Fact | Value |
|---|---|
| Repository | https://github.com/xing5/mcp-google-sheets |
| GitHub stars | 1,011 |
| License | MIT |
| Language | Python |
| Transport | stdio |
| Packages | pypi: mcp-google-sheets |
| Remote URL | none |
| Needs API key | yes |
| Official | no |
| Works with | Claude Desktop, Claude Code, Cursor, VS Code |
| Category | Productivity |
| Latest release | v0.6.3 (May 14, 2026) |
| Last commit | May 14, 2026 |

## Install

### Claude Desktop (claude_desktop_config.json)

```json
{
  "mcpServers": {
    "mcp-google-sheets": {
      "command": "uvx",
      "args": [
        "mcp-google-sheets"
      ],
      "env": {
        "CREDENTIALS_PATH": "your-value",
        "TOKEN_PATH": "your-value",
        "CREDENTIALS_CONFIG": "your-value",
        "GOOGLE_APPLICATION_CREDENTIALS": "your-value"
      }
    }
  }
}
```

Settings > Developer > Edit Config. macOS: ~/Library/Application Support/Claude/, Windows: %APPDATA%\Claude\. Restart Claude Desktop afterwards.

### Claude Code

```sh
claude mcp add --env CREDENTIALS_PATH=your-value --env TOKEN_PATH=your-value --env CREDENTIALS_CONFIG=your-value --env GOOGLE_APPLICATION_CREDENTIALS=your-value --transport stdio mcp-google-sheets -- uvx mcp-google-sheets
```

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

```json
{
  "mcpServers": {
    "mcp-google-sheets": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "mcp-google-sheets"
      ],
      "env": {
        "CREDENTIALS_PATH": "your-value",
        "TOKEN_PATH": "your-value",
        "CREDENTIALS_CONFIG": "your-value",
        "GOOGLE_APPLICATION_CREDENTIALS": "your-value"
      }
    }
  }
}
```

Project file; use ~/.cursor/mcp.json to enable it in every project.

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

```json
{
  "inputs": [
    {
      "type": "promptString",
      "id": "credentials_path",
      "description": "CREDENTIALS_PATH",
      "password": true
    },
    {
      "type": "promptString",
      "id": "token_path",
      "description": "TOKEN_PATH",
      "password": true
    },
    {
      "type": "promptString",
      "id": "credentials_config",
      "description": "CREDENTIALS_CONFIG",
      "password": true
    },
    {
      "type": "promptString",
      "id": "google_application_credentials",
      "description": "GOOGLE_APPLICATION_CREDENTIALS",
      "password": true
    }
  ],
  "servers": {
    "mcp-google-sheets": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "mcp-google-sheets"
      ],
      "env": {
        "CREDENTIALS_PATH": "${input:credentials_path}",
        "TOKEN_PATH": "${input:token_path}",
        "CREDENTIALS_CONFIG": "${input:credentials_config}",
        "GOOGLE_APPLICATION_CREDENTIALS": "${input:google_application_credentials}"
      }
    }
  }
}
```

Config formats checked against the official docs on 2026-10-07.

## Environment variables

- `SERVICE_ACCOUNT_PATH`: Shown in the README's example configuration.
- `ENABLED_TOOLS`: Shown in the README's example configuration.
- `DRIVE_FOLDER_ID`: Shown in the README's example configuration.
- `CREDENTIALS_PATH` (secret): Shown in the README's example configuration.
- `TOKEN_PATH` (secret): Shown in the README's example configuration.
- `CREDENTIALS_CONFIG` (secret): Shown in the README's example configuration.
- `GOOGLE_APPLICATION_CREDENTIALS` (secret): Shown in the README's example configuration.

## Similar MCP servers

- [Kaneo](https://appsgit.com/mcp-servers/kaneo): Official MCP server for Kaneo: manage tasks, projects, and labels from Claude and other MCP clients. (9,368 stars, MIT, official, needs API key)
- [PraisonAI](https://appsgit.com/mcp-servers/praisonai): AI Agents Framework with Self Reflection and MCP support. (9,192 stars, MIT)
- [Windows MCP](https://appsgit.com/mcp-servers/windows-mcp): An MCP Server for computer-use in Windows OS. (7,725 stars, MIT)
- [Excel MCP Server](https://appsgit.com/mcp-servers/excel-mcp-server): Create, read and edit Excel workbooks without Microsoft Excel. (4,212 stars, MIT)
- [Basic Memory](https://appsgit.com/mcp-servers/basic-memory): Local-first knowledge management with bi-directional LLM sync via Markdown files. (4,108 stars, AGPL-3.0)
- [RevoGrid DataGrid MCP](https://appsgit.com/mcp-servers/revogrid-datagrid-mcp): Token-free MCP server for structured RevoGrid Core, Pro, and Enterprise knowledge retrieval. (3,448 stars, MIT)

---

Canonical page: https://appsgit.com/mcp-servers/mcp-google-sheets
Source: appsgit (https://appsgit.com), the app store for github. Data from the GitHub API, refreshed nightly.
Machine access: JSON API https://appsgit.com/api/v1/apps (OpenAPI: https://appsgit.com/openapi.json), MCP server https://mcp.appsgit.com/mcp, full index https://appsgit.com/llms-full.txt.