Back to Directory/Communication

Sheets MCP

Read, edit, format and chart Google Sheets, with a live in-chat preview of every change.

CommunicationTypeScriptv1.3.1
View on GitHub

Sheets MCP

Let Claude read, edit, format and chart your Google Sheets. Ask for a new column, a cleaner layout or a chart, and Claude makes the change directly in your spreadsheet.

See all features and watch the demo at sheetsmcp.io →

Claude adds a profit column, totals, currency formatting and a chart while a live preview of the sheet updates in the chat

Free and open source · Runs on your computer · Works in Claude Desktop and Claude Code

If Sheets MCP saves you time, a ⭐ on GitHub helps other people find it.

Install

Claude Desktop (easiest, no setup)

  1. Install Claude Desktop and sign in.
  2. Download sheets-mcp.mcpb.
  3. 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:

  1. Choose your Google account.
  2. Google shows "Google hasn't verified this app". Click Advanced, then Go to Sheets MCP.
  3. 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)
  • "Undo that"

More example requests and everything Sheets MCP can do →

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.

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

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. To find a sheet by name, 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 <email>  # choose the default account
npx @sheetsmcp/server accounts remove <email>   # sign out an account

Learn more

Installation

Source-derived launch command. Check the maintainer’s required arguments and credentials before running:

bash
npx -y @sheetsmcp/server

Set up in your AI client

Merge this template into ~/Library/Application Support/Claude/claude_desktop_config.json. Keep existing servers. Add any arguments, credentials, and permissions required by the maintainer; this template has not been install-tested.

json
{
  "mcpServers": {
    "io-github-atc07-sheets-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "@sheetsmcp/server"
      ]
    }
  }
}

Restart Claude Desktop completely for changes to take effect. Confirm the server appears connected in the client’s tool list, then try a read-only example from its documentation.

Claude Desktop setup reference

Package

@sheetsmcp/servernpm

Compatible MCP Clients

Sheets MCP works with any MCP-compatible client. Copy the config snippet from the Configuration section above and add it to the file shown for your client, then restart the application.

  • Claude Desktop~/Library/Application Support/Claude/claude_desktop_config.jsonRestart Claude Desktop completely for changes to take effect.
  • Cursor~/.cursor/mcp.jsonRestart Cursor for changes to take effect.
  • VS Code.vscode/mcp.jsonReload VS Code window for changes to take effect.
  • Windsurf~/.codeium/windsurf/mcp_config.jsonRestart Windsurf for changes to take effect.
  • Claude Code.mcp.jsonSave at the project root, then start Claude Code in that project and review the MCP server approval prompt. Keep real credentials out of shared files.

Learn More

Zendesk MCP Server vs Intercom MCP Server: Full ComparisonIntercom's engineering team maintains its own MCP server, six tools, hosted only, US workspaces only. Zendesk has no confirmed first-party equivalent, just a handful of community repos with different tool coverage and different auth models. Both can work well, but they're two very different kinds of bet.Read articleIntercom MCP Server: AI-Powered Support Conversation SearchIntercom has an official MCP server for US workspaces plus a community alternative built for speed. Here is how each one authenticates, what they can search, and which one fits a high-volume support team.Read articleTwilio MCP Server: SMS and Voice in AI Agent WorkflowsMCPFind's communication category indexes 190 MCP servers for messaging, voice, and team chat tools. This guide covers configuring the Twilio MCP server in Claude Desktop, what SMS and voice capabilities it exposes, how to scope credentials safely, and how Twilio fits alongside email and Slack MCP tools in multi-channel agent workflows.Read article