Official description7 sourcesMCP servers8d ago

henilcalagiya/google-sheets-mcp

🐍 🏠 - Google Sheets automation tools

View on GitHub ↗Direct link · no redirect page

Config template (adjust for your client)

claude mcp add google-sheets-mcp -- npx -y google-sheets-mcp

A pasteable skeleton generated from the repository name. Check the project README for the exact package and arguments.

Star count: 13 ★ · henilcalagiya/google-sheets-mcp · read from the repository page · (checked 2026-10-16 20:00:20)
Source: collected from the punkpeye/awesome-mcp-servers list · type: MCP server
Harvest history: first seen 2026-10-09 · last seen 2026-10-16 · seen 32× · listed by 7 sources
Score: score 703 · 13 ★ · 7 sources · mcp

FAQ (answers come from our records)

How do I install it?

We did not find an install command for this repository (our install coverage is only about 4%). Check its README or releases page.

Who is it for?

We filed it under these tags: MCP 服务. The tags come from the entry itself, not a taxonomy we imposed.

Who maintains it?

repository henilcalagiya/google-sheets-mcp；first catalogued 2026-10-09；last seen 2026-10-16。There is no official certification or quality rating here — we record sources and dates only.

Third-party quality signals

Google Sheets MCP Server

以下摘录自该仓库的 README（片段） · 在 GitHub 读完整 README →

> Powerful tools for automating Google Sheets using Model Context Protocol (MCP)
**mcp-name: io.github.henilcalagiya/google-sheets-mcp**
Overview
Google Sheets MCP Server provides seamless integration of Google Sheets with any MCP-compatible client. It enables full spreadsheet automation — including creating, reading, updating, and deleting sheets — through a simple and secure API layer.
Features
- Full CRUD support for Google Sheets and tables
- Works with Continue.dev, Claude Desktop, Perplexity, and other MCP clients
- Secure authentication via Google Service Account
- Comprehensive tools for Google Sheets automation
- Automatic installation via uvx
Requirements
- Python 3.10+
- uv package manager (for uvx command)
- A Google Cloud project with a Service Account
- MCP-compatible client (e.g., Continue.dev)
**Install uv:**
---
Quick Start
1. Set Up Google Service Account
**Step 1: Create a Google Cloud Project**
1. Go to Google Cloud Console
2. Click "Select a project" → "New Project"
3. Enter a project name (e.g., "my-sheets-automation")
4. Click "Create"
**Step 2: Enable Required APIs**
1. In your project, go to "APIs & Services" → "Library"
2. Search for "Google Sheets API" → Click → "Enable"
3. Search for "Google Drive API" → Click → "Enable"
**Step 3: Create Service Account**
1. Go to "IAM & Admin" → "Service Accounts"
2. Click "Create Service Account"
3. Enter service account name (e.g., "sheets-mcp-service")
4. Click "Create and Continue"
5. Skip role assignment → Click "Continue"
6. Click "Done"
**Step 4: Generate JSON Key**
1. Click on your new service account email
2. Go to "Keys" tab → "Add Key" → "Create new key"
3. Choose "JSON" format → Click "Create"
4. The JSON file will download automatically
**Step 5: Extract Required Values**
Open the downloaded JSON file and note these values:
- project_id (e.g., "my-sheets-automation-123456")
- private_key_id (e.g., "a4ae73111b11b2c3b07cc01006e71eb8230dfa29")
- private_key (the long private key starting with "-----BEGIN PRIVATE KEY-----")
- client_email (e.g., "sheets-mcp-service@my-sheets-automation-123456.iam.gserviceaccount.com")
- client_id (e.g., "113227823918217958816")
- client_x509_cert_url (e.g., "https://www.googleapis.com/robot/v1/metadata/x509/sheets-mcp-service%40my-sheets-automation-123456.iam.gserviceaccount.com")
**Example Google service account JSON structure:**
Follow this guide if needed
2. Configure MCP Client
**💡 Pro Tip:** You can copy the values directly from your Google service account JSON file. The field names in the JSON file are used exactly as they are - no changes needed!
**🔄 Backward Compatibility:** The server also supports the old GOOGLE_ prefixed variable names (e.g., GOOGLE_PROJECT_ID) for existing configurations.