Google Sheets MCP Server
Read and write Google Sheets through your own service account, hosted or self-run
- 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/mcpAdd to Settings → Connectors → Add custom connector
https://oldjard--google-sheets-mcp.apify.actor/mcpAdd to ~/.cursor/mcp.json
{
"mcpServers": {
"google-sheets-mcp": {
"url": "https://oldjard--google-sheets-mcp.apify.actor/mcp"
}
}
}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

Ha MCP
MCP serverMCP server for managing and automating Home Assistant from AI assistants
Runs locally- 8 tools
- Open source
- 7.9K GitHub stars
- Productivity

Concord MCP
MCP serverLocal-first MCP server for messaging and shared work-state between coding agents
Runs locally- Freemium
- 1.3K GitHub stars
- Developer tools

note1
MCP serverMCP server giving AI assistants search and summaries across your note1 meetings
- 4 tools
- Remote
- Free trial
- 1 GitHub star
- Productivity

ASTra
MCP serverLet agents read, edit, validate and undo Word .docx files with exact operations
Runs locally- 5 tools
- Freemium
- Files and documents

CalderFlow
MCP serverTurn notes or specs into editable flowcharts, timelines and funnels from an AI assistant
- 10 tools
- Remote
- Free
- Design and media

CARTESIAN ECU
MCP serverCheck and repair ECU and TCU flash-file checksums from Claude (Ultimate plan)
Not checked yet- 5 tools
- Remote
- Paid
- Files and documents