Skip to content
MCP server

Sheets MCP

Let Claude pull APIs, files and other sheets into Google Sheets, locally and for free

Runs locallyStatus and history
Install
Pricing
Open source
Platforms
macOS, Windows, CLI
Runs
Locally
Version
1.4.0
Listing updated
2 days ago

About Sheets MCP

Sheets MCP is an open-source MCP server for productivity. It runs locally on your machine and is started by your AI client.

Sheets MCP runs on your own computer and talks straight to Google, with access limited to spreadsheets. Its pitch is work that reaches beyond one sheet: in Claude Code, Claude can call an API or run a script and write the results into a sheet, read several spreadsheets and build a new one with a summary and charts, or bring in CSV, Excel and PDF files from your disk without uploading them first.

It supports formulas, formatting, charts and pivot tables, with undo and formula-error checks on every write. You can sign in to several Google accounts and read from a work account while writing to a personal one in the same request. A scheduled task in Claude Desktop can refresh a sheet each morning, though the computer must be on. A local list of sheets you have used lets you search, pin and hand several to Claude at once, and a walkthrough feature points at cells with short notes when reviewing a model.

The README compares it with Claude's built-in Sheets integration, which suits quick edits in the open sheet. Sheets MCP is MIT-licensed, works on the free Claude plan in Claude Desktop, and shows Google's unverified-app screen once at sign-in.

Install

Run in a terminal

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

Add to claude_desktop_config.json

{
  "mcpServers": {
    "sheets-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "@sheetsmcp/server"
      ]
    }
  }
}
Install in CursorOpens Cursor, which asks you to confirm. Or add it by hand:

Add to ~/.cursor/mcp.json

{
  "mcpServers": {
    "sheets-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "@sheetsmcp/server"
      ]
    }
  }
}
Install in VS CodeOpens VS Code, which asks you to confirm. Or add it by hand:

Add to .vscode/mcp.json

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

Add to ~/.codeium/windsurf/mcp_config.json

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

Add to your client's MCP settings (most use this shape)

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

What it does

Cross-source building
Combine data from APIs, files and several spreadsheets into one sheet.
Local file import
Bring in CSV, Excel and PDF files from your computer.
Scheduled refresh
Refresh a sheet on a schedule through Claude Desktop.
Multiple Google accounts
Read from one account and write to another in a single request.
Safe writes
Undo and formula-error checks on every write.
Recent sheets list
Search, pin and select sheets used before.
Cell walkthroughs
Step through a model's cells with notes on each point.

Good for

  • Pull API results into a sheet every morning
  • Combine several budget sheets into a summary with charts
  • Import a bank CSV into a spreadsheet
  • Check a financial model for errors
  • Repeat a month-end close the same way each time

Pricing

Open source

Free, MIT licence

Prices change. Check sheetsmcp.io before you buy.

Sheets MCP FAQ

What do I need?

Claude Desktop or Claude Code and a Google account; Claude Code also needs Node.js 18 or newer.

Does my data pass through another server?

The README says it goes from your computer straight to Google, with no other servers.

What does it cost?

It is free and open source under the MIT licence.

Why does Google show a warning?

Sign-in shows a 'Google hasn't verified this app' screen; click Advanced, then continue.

Is Sheets MCP free?

Yes. Sheets MCP is open source, so you can use and self-host it for free.

How do I add Sheets MCP to Claude Code?

Run this command in your terminal: claude mcp add sheets-mcp -- npx -y @sheetsmcp/server

What are the best alternatives to Sheets MCP?

The closest alternatives to Sheets MCP are Ha MCP, Concord MCP, note1, CalderFlow and nicemails.

Alternatives to Sheets MCP

  1. Ha MCP

    MCP server

    MCP server for managing and automating Home Assistant from AI assistants

    Runs locally
    • 8 tools
    • Open source
    • 7.9K GitHub stars
    • Productivity
  2. Concord MCP

    MCP server

    Local-first MCP server for messaging and shared work-state between coding agents

    Runs locally
    • Freemium
    • 1.3K GitHub stars
    • Developer tools
  3. note1

    MCP server

    MCP server giving AI assistants search and summaries across your note1 meetings

    • 4 tools
    • Remote
    • Free trial
    • 1 GitHub star
    • Productivity
  4. CalderFlow

    MCP server

    Turn notes or specs into editable flowcharts, timelines and funnels from an AI assistant

    • 10 tools
    • Remote
    • Free
    • Design and media
  5. nicemails

    MCP server

    Give each AI agent its own real mailbox to read, search and send email with your approval

    • 8 tools
    • Remote
    • Freemium
    • Communication
  6. Transcribe audio and video links from Claude or ChatGPT and read the results

    Not checked yet
    • 5 tools
    • Remote
    • Freemium
    • Design and media