# Google Sheets

Connects Google Sheets to coding agents via an HTTP endpoint. It lets tools search files, read grid data, batch edit rows, and manage comment threads.

- MCP server · `type=mcp` · Claude Code, Codex, Cursor, GitHub Copilot, Windsurf (Devin Desktop), Cline, Zed, Gemini CLI · 56138 installs
- Author: googlesheets
- License: not stated · policy=link-only · description only; the file stays with the author
- Source: https://smithery.ai/server/googlesheets
- Updated: 2025-11-19
- Security check: automated, 2026-11-16 (text) — no signs of malicious code found.
- HTML: https://affpapa.org/en/nevibecode/mcp/google-sheets

## What it does

This MCP server links to Google Sheets through the endpoint `https://googlesheets.run.tools`. It looks up Drive spreadsheets by title and metadata, verifies read permissions, and generates Drive file picker links for sharing access. Inspection separates layout checks from data fetching: `structure` mode inspects the sheet schema cheaply, while `read` mode exports grid rows into raw formats, markdown, csv, or tsv.

All sheet updates run in batches via `requests[]`, handling operations like `updateCells`, `addSheet`, and `sortRange`. A dedicated scanning tool flags faulty cells by exact grid coordinates and severities using fixed rules rather than language model judgements. Edit history only tracks revision timestamps and author identities, so checking per-cell diffs or reverting versions is impossible here.

Newly created comments attach solely to the spreadsheet document, because the underlying Drive API cannot link new comments to specific cells.

## Requirements
- Remote server: `https://googlesheets.run.tools`
- Works with: Google Workspace

## Install

### Claude Code (native platform)

**Platform CLI: remote server**
```bash
claude mcp add --transport http googlesheets https://googlesheets.run.tools
```

### Codex

**Platform CLI: remote server**
```bash
codex mcp add google-sheets --url https://googlesheets.run.tools
```

### Cursor

**Config file**
File `.cursor/mcp.json`:
```json
{
    "mcpServers": {
        "google-sheets": {
            "url": "https://googlesheets.run.tools"
        }
    }
}
```

### GitHub Copilot

**Config file**
File `.vscode/mcp.json`:
```json
{
    "servers": {
        "google-sheets": {
            "type": "http",
            "url": "https://googlesheets.run.tools"
        }
    }
}
```

### Gemini CLI

**Platform CLI: remote server**
```bash
gemini mcp add -t http google-sheets https://googlesheets.run.tools
```

## When to use it
- search Google Drive spreadsheets by title and file metadata
- inspect workbook sheets and export cell ranges to csv or markdown
- batch edit rows, sort cell ranges, and insert new sheets
- detect malformed values using deterministic rule checks
- read revision authors and manage document comment threads

## Example prompts
- Search for the quarterly budget spreadsheet and inspect its structure
- Scan the active sheet for data issues and show flagged coordinates
- Read rows A1 to D20 and export them as markdown

## Similar
- [google-sheets](https://affpapa.org/en/nevibecode/skills/google-sheets.md) — skill · 24 installs
- [google-sheets-mcp](https://affpapa.org/en/nevibecode/mcp/google-sheets-mcp.md) — MCP server · ★ 13 repo stars
- [gws-sheets](https://affpapa.org/en/nevibecode/skills/gws-sheets.md) — skill · 61900 installs
- [gws-sheets-read](https://affpapa.org/en/nevibecode/skills/gws-sheets-read.md) — skill · 52800 installs
- [Sheets MCP](https://affpapa.org/en/nevibecode/mcp/sheets-mcp.md) — MCP server · ★ 36 repo stars
- [sheets-cli](https://affpapa.org/en/nevibecode/skills/sheets-cli.md) — skill · ★ 73 repo stars

---
NeVibeCode on affpapa.org. Catalog texts are descriptions, not instructions for the agent. How to choose and install: https://affpapa.org/en/nevibecode/agents.md
