Sheets MCP

Name: Sheets MCP
Author: atc07

作者：atc07版本 1.4.0i★ –i在你的电脑上运行

注册名称io.github.atc07/sheets-mcp

安装

概览

作者提供的说明（英文原文）

Google Sheets for agent workflows in Claude Code and Claude Desktop: APIs, files, schedules, undo.

PopNx MCP 的三大支柱

这三项永远不会合并成一个分数：意见、测量和人气是不同的东西。

用户评价i暂无评价评价功能将在后续阶段与账户功能一起开放
我们的基础检查i1 项中通过 1 项依据公开信息检查；尚未扫描代码
使用情况i尚未统计★ –

它能帮你做什么

我们还没有为它写通俗的介绍。下面是我们从注册中心读取到的事实。

连接方式: 在你的电脑上运行
传输方式: stdio
分类: 文档、表格与办公

安装

选择你使用的 AI 应用，然后复制设置。

安装之前

基础检查：1 项中通过 1 项
在你的电脑上运行，拥有你的用户账户的权限（文件、网络、应用）。
注册中心没有列出需要填写的密钥。

你需要

npm已安装 Node.js（用于 npx 命令）

你用的是哪个应用？

ClaudeClaude CodeCursorVS CodeChatGPT

在上方选择你的应用。我们会记住它，下次按钮会显示“安装到 …”。

打开 Claude Desktop → Settings → Developer → Edit Config，把下面的内容粘贴到 claude_desktop_config.json

{
  "mcpServers": {
    "sheets": {
      "command": "npx",
      "args": [
        "-y",
        "@sheetsmcp/server"
      ]
    }
  }
}

在终端中运行这条命令

claude mcp add sheets -- npx -y @sheetsmcp/server

在 Cursor 中打开

或者自己复制设置

粘贴到项目中的 .cursor/mcp.json，或 ~/.cursor/mcp.json

{
  "mcpServers": {
    "sheets": {
      "command": "npx",
      "args": [
        "-y",
        "@sheetsmcp/server"
      ]
    }
  }
}

浏览器会先询问是否打开应用，然后应用会显示设置并请你确认。密钥的值会留空，由你自己填写。

在 VS Code 中打开

或者自己复制设置

粘贴到项目中的 .vscode/mcp.json

{
  "servers": {
    "sheets": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@sheetsmcp/server"
      ]
    }
  }
}

浏览器会先询问是否打开应用，然后应用会显示设置并请你确认。密钥的值会留空，由你自己填写。

这个服务器在你的电脑上运行，而 ChatGPT 只能连接互联网上的服务器。请选择其他应用。

你的选择通过 Cookie 保存在这台设备上，无需账户。

这些设置是根据作者在注册中心的条目生成的。如果 README 的写法不同，请以 README 为准。

它能做什么

它在你的电脑上运行；安装后，工具列表会显示在你的 AI 应用中。

基础检查i

我们检查的是任何人都能看到的信息；我们没有阅读代码。不适用的检查项不计入总数。 · 检查于 2026年11月7日

✓ 通过
作者与仓库一致
注册名称已通过 GitHub 账户 atc07 验证，该账户拥有此仓库
… 尚未检查
仍在维护
我们还没有从 GitHub 读取这个仓库
… 尚未检查
有许可证
我们还没有从 GitHub 读取这个仓库
– 不适用
端点有响应
它在你的电脑上运行，没有互联网端点
– 不适用
使用 OAuth 登录
在你的电脑上运行，改用本地设置
… 尚未检查
工具描述中没有隐藏指令
它在你的电脑上运行；我们只能读取互联网端点的工具列表

与“文档、表格与办公”中的其他服务器比较i

星标数多于此分类中其他 2186 个服务器的 0%
发布到注册中心的时间比此分类中其他 2186 个服务器的 73% 更新
基础检查结果等于或优于此分类中其他 2186 个服务器的 100%

与注册中心里这个分类中所有活跃的服务器比较。只有当发布者拥有该仓库时，星标数才计入。

常见问题

Sheets MCP 安全吗？

它在 1 项适用的基础检查中通过了 1 项。我们没有阅读代码。在添加密钥或令牌之前，请先看看这个服务器要求哪些权限，并使用只具备所需权限的密钥。

它需要哪些密钥或代码？

注册中心没有列出必需的密钥，不过有些服务器会在首次使用时要求你登录。

它在我的电脑上运行还是在云端？

它在你的电脑上运行。你的 AI 应用会在需要时启动它，数据不会经过作者的服务器（除非它自己调用在线服务）。

它还在维护吗？

GitHub 仓库最后更新于–，最新版本（1.4.0）于11天前进入注册中心。

哪些应用可以使用它？

支持 MCP 的应用，例如 Claude Desktop、Claude Code、Cursor 和 VS Code。你的电脑上还需要有 Node.js。

有什么可以替代它？

同一分类中有：Agent-Native Calendar, Excel MCP Server, MCP Server for Excel

替代选择

同一分类中其他作者的服务器，按星标数排序。

如何看卡片：★ GitHub 星标i三大支柱：评价 · 检查 · 使用情况i更新 = 最新版本发布到注册中心的时间i

Agent-Native Calendar

作者：BuilderIO

Agent-Native Google Calendar - manage events, sync, and public booking

在云端运行★ 7,620MIT2个月前更新

安装

Excel MCP Server

作者：haris-musa

Create and edit Excel files with AI: charts, PivotTables, formulas. No Excel needed.

在你的电脑上运行★ 4,276MIT6天前更新

安装

MCP Server for Excel

作者：sbroenne

Excel automation for AI - Sheets, Power Query, DAX, VBA, Tables, Ranges and more. Windows only.

在你的电脑上运行★ 847MIT3天前更新

安装

作者的 README

打开 README

按原文从作者的仓库复制。PopNx MCP 没有审查或背书其内容。HTML、图片和脚本已被移除。链接会离开本站。

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 →](https://sheetsmcp.io/?utm_source=github&utm_medium=readme&utm_campaign=top)

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](https://sheetsmcp.io/downloads/sheets-mcp.mcpb) (a .mcpb file; 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.

The extension works in both the Chat and Code tabs. For long, multi-step jobs, the Code tab is the more dependable choice: it runs everything on your computer.

Claude Code

Requires Node.js 18 or newer. Run:

claude mcp add --scope user google-sheets -- npx -y @sheetsmcp/server

Then start a new Claude Code session.

Sign in

The first time Claude uses Google Sheets, a Google sign-in page opens in your browser:

Choose your Google account.
Google shows "Google hasn't verified this app". Click Advanced, then Go to Sheets MCP.
Click Continue to allow access to your spreadsheets.

To use more than one Google account, ask Claude to *"sign in to another Google account"*. When you paste a sheet link, Sheets MCP uses whichever of your accounts can open it.

To open the Google sign-in in a particular browser without changing your default, add "browser": "Google Chrome" (or another app name) to ~/.sheets-mcp/settings.json.

If your company's Google Workspace blocks the sign-in, your Workspace admin can allow Sheets MCP under Admin console → Security → API controls.

Try asking

In Claude Desktop, click + and choose Get started with Google Sheets for a quick tour. When more than one Google account is connected, Claude asks which account to use before creating a spreadsheet, or when a sheet can be opened by more than one of your accounts.

"Summarize this sheet: "
"Add a Profit column that subtracts Cost from Revenue, and format it as currency"
"Chart spending by month in this sheet: "
"Freeze the header row, bold it, and auto-fit the column widths"
"Summarize revenue by region and product in a pivot table"
"Change that chart to a line chart and move it next to the table"
"Create a new spreadsheet called Trip Planner"
"Open my budget sheet" (works for sheets you've used with Sheets MCP before)
"Pull last week's Stripe payouts into the Cash tab" (Claude Code)
"Combine the East and West sales sheets into a new Q3 summary with a chart"
"Copy the Q4 forecast from my work account into the board sheet on my personal account"
"Undo that"

More example requests and everything Sheets MCP can do →

Recently worked on

Sheets MCP keeps a list of the spreadsheets you've used with it, on your computer. In Claude Desktop, start talking about your sheets ("let's work on my budget") or ask "show my recent sheets", and a searchable list opens in the chat: pin the ones you use most, open them in Google Sheets, or tick several (even from different Google accounts) and send them to Claude with what you want done. In Claude Code, type /mcp__google-sheets__recent_sheets or ask "which sheets have I used?".

Live preview

In Claude Desktop, Claude opens a live preview of your sheet in the chat while it works. You see each range it reads and each change it makes as it happens, charts included, and the preview folds away when Claude is done. Open in Sheets jumps to the same cells in Google Sheets.

Ask Claude to explain a sheet ("walk me through how this model works") and the preview becomes a walkthrough: a progress bar while Claude reads, then Claude's explanation played on the sheet one point at a time. Claude's cursor outlines the cells for each point and types a short note beside them, and the walkthrough waits for you to click Next. Type a question about the point in the walkthrough and Claude answers there, stepping through the cells it's talking about. It's drawn in the preview only, so nothing changes in the sheet and collaborators see nothing.

After updating Sheets MCP, quit and reopen Claude Desktop so it loads the new preview.

The preview draws in the Claude desktop app. If you follow a session from your phone with Remote Control, Sheets MCP keeps working on your computer and the preview is there when you're back at it.

Watch it in action on sheetsmcp.io →

Privacy

Sheets MCP runs on your computer. Your Google sign-in is stored only on your computer (in ~/.sheets-mcp), and requests go straight from your computer to Google. There is no Sheets MCP server in between. It asks Google for access to your spreadsheets only, not the rest of your Drive. For finding sheets by name and the Recently worked on list, it keeps a list of the spreadsheets you've used with it in ~/.sheets-mcp/recent.json on your computer; delete that file to clear the list. Spreadsheet data Claude reads becomes part of your Claude conversation. See the privacy policy.

To disconnect, ask Claude to *"sign out of Google Sheets"*, or remove Sheets MCP at myaccount.google.com/permissions.

Command line (optional)

npx @sheetsmcp/server auth                      # sign in to a Google account

npx @sheetsmcp/server accounts # list signed-in accounts npx @sheetsmcp/server accounts default # choose the default account npx @sheetsmcp/server accounts remove # sign out an account

Learn more

[sheetsmcp.io](https://sheetsmcp.io/?utm_source=github&utm_medium=readme&utm_campaign=footer): full feature list, demo, setup guide and FAQ
Privacy policy · Terms
Questions or bugs: open an issue

Sheets MCP

概览

PopNx MCP 的三大支柱

它能帮你做什么

安装

安装之前

它能做什么

基础检查i

作者与仓库一致

仍在维护

有许可证

端点有响应

使用 OAuth 登录

工具描述中没有隐藏指令

与“文档、表格与办公”中的其他服务器比较i

常见问题

替代选择

Agent-Native Calendar

Excel MCP Server

MCP Server for Excel

作者的 README

Sheets MCP

Sheets MCP or Claude's built-in Google Sheets integration?

Install

Claude Desktop (easiest, no setup)

Claude Code

Sign in

Try asking

Recently worked on

Live preview

Privacy

Command line (optional)

Learn more