📋 Copy MCP Install CLI { } Inspect JSON API Ground-Truth Source ↗

⚡ 1-Click Agent & Developer Install

Zero Auth · Ready for Grok Bot, Claude Code & Cursor

### Server Architecture & Capability Summary **Google Sheets Ledger, Range Batch-Update & Formula MCP Server** (`google-sheets-mcp`) is a verified **STDIO** Model Context Protocol (MCP) server curated with **@levelsio** for Grok Bot, Claude Code, and Cursor. Read and write Google Sheets cell ranges, append deduplicated finance or CRM rows, create new tabs, and inspect spreadsheet formulas from any MCP client. ### 1-Click CLI Installation Run the command below to register `google-sheets-mcp` in Claude Code or your MCP client: ```bash claude mcp add gsheets -- npx -y mcp-google-sheets ``` ### Standard `mcpServers` JSON Configuration (`.cursor/mcp.json` / `claude_desktop_config.json`) ```json { "mcpServers": { "google-sheets-mcp": { "command": "npx", "args": [ "-y", "mcp-google-sheets" ], "env": { "GOOGLE_APPLICATION_CREDENTIALS": "~/.config/gcloud/service-account.json" } } } } ``` ### Exposed MCP Tools - `gsheets_get_values` — Deterministic JSON-RPC 2.0 tool exposed by `google-sheets-mcp`. - `gsheets_batch_update` — Deterministic JSON-RPC 2.0 tool exposed by `google-sheets-mcp`. - `gsheets_append_rows` — Deterministic JSON-RPC 2.0 tool exposed by `google-sheets-mcp`. - `gsheets_create_sheet` — Deterministic JSON-RPC 2.0 tool exposed by `google-sheets-mcp`. ### Authentication & Environment Variables - **Transport Protocol:** `stdio` - **Auth Mechanism:** `oauth2` - `GOOGLE_APPLICATION_CREDENTIALS`: `~/.config/gcloud/service-account.json` - **Documentation / Source:** [https://github.com/xing5/mcp-google-sheets](https://github.com/xing5/mcp-google-sheets)

Tags: #google-sheets-mcp#stdio#finance-deals#mcp-server#gsheets-get-values#gsheets-batch-update

View All 14 Items by @levelsio →

template · ⚡ 82

Penny — Household Reorder & Price-Drop Approval Concierge

Tracks recurring household and office supply reorders, compares unit pricing across vendors, and stages carts with mandatory ask-first checkout approval.

use case · ⚡ 90

Zero-Ops Indie SaaS Health, Payment & Support Watchdog

Monitors HTTP endpoints, SQLite/Postgres disk headroom, Stripe webhook delivery, and priority customer emails for a portfolio of lean SaaS products.

template · ⚡ 82

Gridlock — Financial Model & Spreadsheet Formula Stress-Tester

Audits complex Google Sheets and Excel workbooks for broken cell references, hardcoded overrides, circular dependencies, and sensitivity edge cases.