Read-only Google Sheets MCP server with ADC auth for Cascade, Cursor, Copilot, Claude, and other MCP clients
Wellknown found it in public sources; nobody has proven control of it yet. Claiming takes one click if the repository is under your GitHub account, or a small file on your domain otherwise. Verified owners get the badge, 15-minute checks, status alerts, edits that outrank crawled data, and a ranking boost.
Agents can do it too: POST https://wellknown.network/api/v1/claims with {"agent":"g-sheet-mcp","method":"well_known_file"} — machine-readable steps at claim.json, guide at /docs/claim.
Everything here was measured by our prober or read from a registry. Nothing is self-reported.
Attributed to the source that supplied each field. Treated as claims, not facts.
# 📄 Google Sheets MCP `g-sheet-mcp` is a **read-only** [Model Context Protocol (MCP)](https://modelcontextprotocol.io) server that gives AI assistants (Claude, Cursor, Copilot, Cascade, and other MCP clients) direct access to Google Sheets data — authenticated via [Application Default Credentials (ADC)](https://cloud.google.com/docs/authentication/application-default-credentials). No service account JSON. No hardcoded secrets. One command to authenticate, works everywhere. Repo: `google-sheets-mcp` · [PyPI](https://pypi.org/project/g-sheet-mcp/) · CLI/package: `g-sheet-mcp` · Python import: `g_sheet_mcp` All examples in this repo are generic and sanitized for public release. --- ## ✨ Features | MCP Tool | Description | |---|---| | `get_spreadsheet_info` | Title, locale, timezone, and all sheet tab metadata | | `list_sheets` | List every worksheet tab with row/column dimensions | | `read_range` | Read an A1-notation range (e.g. `'Sheet1'!A1:D10`) | | `read_sheet` | Read an entire worksheet by tab name (spaces in name handled automatically) | | `read_sheet_as_records` | **Best for LLMs** — returns rows as `[{"col": val, ...}]` dicts | | `get_cell` | Read a single cell by 1-based row/column index | | `find_in_spreadsheet` | Substring search across all cells (with optional sheet filter) | | `batch_read_ranges` | Read multiple ranges in one API call | Both **full Google Sheets URLs** and **bare spreadsheet IDs** are accepted by all tools. Sheet names with **spaces** (e.g. `Example Sheet 1`) are quoted automatically. --- ## 🚀 Installation ### Prerequisites ```bash # Python 3.11+ and uv brew install uv # macOS # or: curl -LsSf https://astral.sh/uv/install.sh | sh # Google Cloud SDK brew install google-cloud-sdk # or: https://cloud.google.com/sdk/docs/install ``` ### Step 1 — ✨ Recommended: Install from PyPI (`uvx g-sheet-mcp`) This is the recommended setup for most users now that the package is published on PyPI. ```bash uvx g-…
Mapped onto the structured taxonomy from declared text and observed tool names. Confidence shown for derived entries.
Every source is kept verbatim. Field changes are logged as events.