Skip to content
MCP server

Google Sheets MCP Server

Read and write Google Sheets through your own service account, hosted or self-run

Install
Pricing
Freemium
Platforms
API, self-hosted, Web
Runs
Remotely
Version
0.2.0
Listing updated
2 days ago

About Google Sheets MCP Server

Google Sheets MCP Server is a freemium MCP server for productivity. It runs as a hosted remote server, so there is nothing to install locally.

Access goes through a Google service account that you create, not through a shared OAuth app, so there is no common quota and nothing expires. The account can only open spreadsheets you have explicitly shared with it as Editor, and a missing share or wrong tab name comes back as a plain-English fix, such as the exact email address to share with.

Five tools cover the work: list_sheets, read_range, append_rows, update_range and export_dataset. Appended objects are matched to header names, and new fields become new columns; rows already in the tab can be skipped. Values are written as plain values, never formulas, and one call reads or writes at most 5,000 rows. export_dataset sends an Apify dataset into a tab by appending, replacing or adding only new rows.

There are two ways to run it. The hosted version runs on Apify and is billed to your Apify account at $0.001 per successful tool call and $0.0004 per exported row, with failed calls free, plus Apify's platform usage. Alternatively, clone the repository and run it yourself on Node.js 24 or newer. Your base64-encoded key is sent in a header over HTTPS and held in memory only.

Install

Run in a terminal

claude mcp add --transport http google-sheets-mcp https://oldjard--google-sheets-mcp.apify.actor/mcp

Add to Settings → Connectors → Add custom connector

https://oldjard--google-sheets-mcp.apify.actor/mcp
Install in CursorOpens Cursor, which asks you to confirm. Or add it by hand:

Add to ~/.cursor/mcp.json

{
  "mcpServers": {
    "google-sheets-mcp": {
      "url": "https://oldjard--google-sheets-mcp.apify.actor/mcp"
    }
  }
}
Install in VS CodeOpens VS Code, which asks you to confirm. Or add it by hand:

Add to .vscode/mcp.json

{
  "servers": {
    "google-sheets-mcp": {
      "type": "http",
      "url": "https://oldjard--google-sheets-mcp.apify.actor/mcp"
    }
  }
}

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

{
  "mcpServers": {
    "google-sheets-mcp": {
      "serverUrl": "https://oldjard--google-sheets-mcp.apify.actor/mcp"
    }
  }
}

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

{
  "mcpServers": {
    "google-sheets-mcp": {
      "type": "http",
      "url": "https://oldjard--google-sheets-mcp.apify.actor/mcp"
    }
  }
}

Tools this server provides (5)

Taken from the project documentation; the running server may differ.

list_sheets
Lists a spreadsheet's tabs with size and link.
read_range
Reads cells from a range or whole tab, paging long results.
append_rows
Adds rows below the last one, matching objects to header names.
update_range
Overwrites cells from a top-left cell and grows the tab if needed.
export_dataset
Writes an Apify dataset to a tab by appending, replacing or adding only new rows.

What it does

Five sheet tools
List tabs, read ranges, append rows, update ranges and export datasets.
Your own service account
No OAuth app to approve and no shared quota.
Header-aware appends
Objects map to column names and new fields create columns.
Paged reads
Long tabs return in pages with the next range to read.
Apify dataset export
Write a dataset into a tab as append, replace or new rows only.
Hosted or self-run
Use the pay-per-use Apify actor or run the code yourself.

Good for

  • Have an assistant log new leads to a sheet
  • Read a range of cells to answer a question
  • Fix a batch of cells in place
  • Push scraped results from an Apify dataset into a tab
  • Check which tabs exist in a spreadsheet

Pricing

Freemium

Self-hosting is free; hosted on Apify at $0.001 per successful call and $0.0004 per exported row.

Prices change. Check apify.com before you buy.

Google Sheets MCP Server FAQ

How is the hosted version billed?

$0.001 per successful tool call and $0.0004 per exported row, plus Apify platform usage.

Can it write formulas?

No. Values are written as plain values.

How many rows per call?

At most 5,000.

Is self-hosting free?

The README says yes; it needs Node.js 24 or newer.

Which sheets can it open?

Only those shared with your service account's email.

Is Google Sheets MCP Server free?

Google Sheets MCP Server has a free plan, with paid plans for more usage or features.

How do I add Google Sheets MCP Server to Claude Code?

Run this command in your terminal: claude mcp add --transport http google-sheets-mcp https://oldjard--google-sheets-mcp.apify.actor/mcp

What are the best alternatives to Google Sheets MCP Server?

The closest alternatives to Google Sheets MCP Server are Ha MCP, Concord MCP, note1, ASTra and CalderFlow.

Alternatives to Google Sheets MCP Server

  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. ASTra

    MCP server

    Let agents read, edit, validate and undo Word .docx files with exact operations

    Runs locally
    • 5 tools
    • Freemium
    • Files and documents
  5. CalderFlow

    MCP server

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

    • 10 tools
    • Remote
    • Free
    • Design and media
  6. CARTESIAN ECU

    MCP server

    Check and repair ECU and TCU flash-file checksums from Claude (Ultimate plan)

    Not checked yet
    • 5 tools
    • Remote
    • Paid
    • Files and documents