xing5/mcp-google-sheets
Free用于与 Google Sheets 交互的模型上下文协议服务器。提供创建、读取、更新和管理电子表格的工具。
FreeFree tier
About xing5/mcp-google-sheets
mcp-google-sheets is a Python-based Model Context Protocol (MCP) server that acts as a bridge between any MCP-compatible client (such as Claude Desktop) and the Google Sheets API. It enables users to create, read, update, and manage Google Spreadsheets programmatically through a defined set of tools, facilitating powerful automation and data manipulation workflows driven by AI. The server supports authentication via Google Cloud Service Accounts (recommended) or OAuth, and can be quickly started with a single uvx command.
Key Features
Bridges MCP-compatible clients (e.g., Claude Desktop) to Google Sheets API
Create, read, update, and manage spreadsheets via a defined set of tools
Supports Service Account and OAuth authentication methods
Quick start with a single uvx command (uvx mcp-google-sheets@latest)
Optional tool filtering to reduce context usage
Includes an ID Reference Guide for identifying Google resources
Open-source Python implementation, easily extensible
Pros & Cons
Pros
- Free and open-source with full source code available on GitHub
- Works seamlessly with any MCP-compatible client (Claude Desktop, others)
- Simple setup using uvx – no complex configuration needed beyond credentials
- Leverages official Google Sheets API for reliable operations
- Actively maintained with recent updates and community support
Cons
- Requires Google Cloud Platform setup (creating a project, enabling APIs, and generating a service account key) – not fully plug-and-play
- Environment variables must be configured for authentication (may add friction for non-technical users)
- Limited to Google Sheets; no support for other spreadsheet providers
- Dependency on uv (Python package manager) – users without uv need to install it first
Best For
AI-powered automation of spreadsheet tasks (creation, updates, data extraction)Integrating AI assistants with Google Sheets for data manipulation workflowsBuilding custom chatbots or agents that can read/write to Google SheetsAutomating report generation and data logging in Google Sheets
FAQ
What is mcp-google-sheets?
It is a Python-based MCP server that acts as a bridge between MCP-compatible clients (like Claude Desktop) and the Google Sheets API, allowing AI-driven creation and modification of spreadsheets.
How do I set up authentication?
The recommended method is to create a Google Cloud Service Account, download the JSON key file, and set the SERVICE_ACCOUNT_PATH and DRIVE_FOLDER_ID environment variables. OAuth is also supported via CREDENTIALS_CONFIG.
Can I run it without installing anything?
Yes, you can run it directly using uvx mcp-google-sheets@latest, which automatically downloads and executes the latest version. You only need to have uv installed.
Which MCP clients are compatible?
Any client that supports the Model Context Protocol, such as Claude Desktop. The server is client-agnostic.