这是一个本地的 Google Sheets MCP 服务器，用于 Claude Code 和 Claude Desktop 中的代理工作流程：编写 API、脚本和文件输出到表格中，合并电子表格，按计划刷新，跨越......
概览
Claude 中 Google Sheets 的强大工具。一个免费的开源 MCP 服务器，将你的电子表格连接到 Claude Desktop 和 Claude Code 的所有功能：从 API 和文件拉取数据到表格，从其他表格中构建新表格，按计划更新，并跨多个 Google 账户运行。包含公式、格式、图表和数据透视表，每次写入都可进行撤销和公式错误检查。它运行在你的电脑上，直接与 Google 通信。 免费且开源 ·运行于您的电脑 ·仅限电子表格的Google访问 ·Claude桌面版和Claude代码 如果 Sheets MCP 能帮你节省时间，GitHub 上的 MCP ⭐ 也能帮助其他人找到它。 Claude现在在付费套餐上有了自己的Google Sheets集成。两者都允许Claude编辑你的电子表格;它们适合不同的工作。 在付费套餐上，只想让Claude在你面前编辑表格？内置集成是最简单的。想让Claude免费帮你把表格和其他所有内容一起拉在一起吗？用Sheets MCP。
概述（AI 翻译）
Claude 中 Google Sheets 的强大工具。一个免费的开源 MCP 服务器，将你的电子表格连接到 Claude Desktop 和 Claude Code 的所有功能：从 API 和文件拉取数据到表格，从其他表格中构建新表格，按计划更新，并跨多个 Google 账户运行。包含公式、格式、图表和数据透视表，每次写入都可进行撤销和公式错误检查。它运行在你的电脑上，直接与 Google 通信。
查看所有功能并观看演示，请访问 sheetsmcp.io →
免费且开源 ·运行于您的电脑 ·仅限电子表格的Google访问 ·Claude桌面版和Claude代码
如果 Sheets MCP 能帮你节省时间，GitHub 上的 MCP ⭐ 也能帮助其他人找到它。
Sheets MCP 还是 Claude 内置的 Google Sheets 集成？
Claude现在在付费套餐上有了自己的Google Sheets集成。两者都允许Claude编辑你的电子表格;它们适合不同的工作。
| 图纸 MCP | Claude 内置集成 | |
|---|---|---|
| 最佳用途 | 超出单一工作表的工作：API、文件、其他工作表、日程表 | 在你打开的表内快速编辑 |
本页由 AI 翻译，技术细节请以原文为准。
README
以下为原文 README 节选，完整内容请查看原文。
Sheets MCP
The power tool for Google Sheets in Claude. A free, open-source MCP server that connects your spreadsheets to everything Claude Desktop and Claude Code can do: pull data from APIs and files into a sheet, build new sheets from your other sheets, keep them updated on a schedule, and work across several Google accounts. Formulas, formatting, charts and pivot tables included, with undo and formula-error checks on every write. It runs on your computer and talks to Google directly.
See all features and watch the demo at sheetsmcp.io →
Free and open source · Runs on your computer · Spreadsheet-only Google access · Claude Desktop and Claude Code
If Sheets MCP saves you time, a ⭐ on GitHub helps other people find it.
Sheets MCP or Claude’s built-in Google Sheets integration?
Claude now has its own Google Sheets integration on paid plans. Both let Claude edit your spreadsheets; they suit different jobs.
| Sheets MCP | Claude’s built-in integration | |
|---|---|---|
| Best for | Work that reaches beyond one sheet: APIs, files, other sheets, schedules | Quick edits inside the sheet you have open |
| Price | Free, and works on the free Claude plan in Claude Desktop | Paid Claude plans |
| Where it works | Claude Desktop (Chat and Code tabs) and Claude Code | Claude chat, and a sidebar inside Google Sheets |
| Setup | One-click extension or one command. Google shows an “unverified app” screen at sign-in for now | Built in |
| Where your data goes | From your computer straight to Google, with access to spreadsheets only. No other servers | Through Anthropic’s hosted connector |
| Code | Open source (MIT): read it, change it, run your own | Anthropic’s product |
| Extras | Several Google accounts, undo, formula-error checks, live preview in the chat | Sidebar in Sheets, edit approvals, Python for data cleaning |
In short: on a paid plan and only want Claude to edit the sheet in front of you? The built-in integration is the simplest. Want Claude to pull your sheets together with everything else, for free? Use Sheets MCP. You can use both.
Install
Claude Desktop (easiest, no setup)
- Install Claude Desktop and sign in.
- Download Sheets MCP for Claude Desktop (a
.mcpbfile; see what’s new). - Double-click the file, then click Install in Claude Desktop.
New to Claude Desktop? Follow the step-by-step setup guide.
安装
npx @sheetsmcp/server auth # sign in to a Google account