
Google_sheets
MCP server giving AI clients read, write, append and create access to Google Sheets
- Pricing
- Freemium
- Platforms
- API, CLI, vscode
- Runs
- Locally or Remotely
- Version
- 0.2.1
- Listing updated
- today
Similar MCP servers
About Google_sheets
Google_sheets is a freemium MCP server for files and documents. It can run locally on your machine or as a hosted remote server.
The README describes this as a Pipeworx pack that exposes Google Sheets operations to MCP clients through the Pipeworx gateway rather than running a standalone local server. Five tools cover reading a range, overwriting a range, appending rows to a table, inspecting a spreadsheet's tabs and properties, and creating a new spreadsheet that returns its ID and sharing URL.
The endpoint can be added to Claude.ai, Claude Desktop, Claude Code, Cursor or VS Code, or run through an npm stdio bridge. Without an API key calls are anonymous and capped at 50 per day; a free Pipeworx account raises the cap to 200 per day. The page notes that the default endpoint also lists shared gateway meta-tools such as ask_pipeworx alongside the pack's own tools.
The pack is aimed at developers and agent builders who want an assistant to work with spreadsheet data, and it is an unofficial integration not affiliated with Google.
Install
Run in a terminal
claude mcp add --transport http google_sheets https://gateway.pipeworx.io/google_sheets/mcpAdd to Settings → Connectors → Add custom connector
https://gateway.pipeworx.io/google_sheets/mcpAdd to ~/.cursor/mcp.json
{
"mcpServers": {
"google_sheets": {
"url": "https://gateway.pipeworx.io/google_sheets/mcp"
}
}
}Add to .vscode/mcp.json
{
"servers": {
"google_sheets": {
"type": "http",
"url": "https://gateway.pipeworx.io/google_sheets/mcp"
}
}
}Add to ~/.codeium/windsurf/mcp_config.json
{
"mcpServers": {
"google_sheets": {
"serverUrl": "https://gateway.pipeworx.io/google_sheets/mcp"
}
}
}Add to your client's MCP settings (most use this shape)
{
"mcpServers": {
"google_sheets": {
"type": "http",
"url": "https://gateway.pipeworx.io/google_sheets/mcp"
}
}
}Using several servers? Build one config file with the MCP config generator.
Configuration
PIPEWORX_API_KEYOptional Pipeworx API key. Without it calls are anonymous and capped daily; a free key raises the cap.
Tools this server provides (5)
Taken from the project documentation; the running server may differ.
- sheets_read
- Read data from a Google Sheet range. Specify sheet name and range (e.g., 'A1:C10'). Returns rows as arrays of cell values.
- sheets_write
- Write data to a Google Sheet range, overwriting existing values. Specify sheet name, range (e.g., 'A1:C10'), and row data.
- sheets_append
- Append new rows to the end of a Google Sheet table. Specify sheet name and row data to add.
- sheets_get_spreadsheet
- Explore a spreadsheet's structure. Returns title, sheet/tab names, and properties. Use before reading or writing data.
- sheets_create
- Create a new Google Spreadsheet. Optionally set title and initial sheet names. Returns spreadsheet ID and sharing URL.
What it does
- Range reading
- Reads cell values from a named sheet and A1-style range and returns them as arrays of rows.
- Range overwriting
- Writes row data into a specified range, replacing existing values in that range.
- Table appending
- Adds new rows to the end of a sheet table without touching existing content.
- Spreadsheet structure lookup
- Returns the spreadsheet title, tab names and properties so clients can locate data before reading or writing.
- Spreadsheet creation
- Creates a new spreadsheet with an optional title and initial tab names, returning its ID and sharing URL.
Good for
- Let an AI assistant pull rows from a team tracking sheet for analysis
- Append generated records or logs to an existing spreadsheet from an agent workflow
- Create a fresh spreadsheet for exported results and share the link
- Inspect tab names in a workbook before writing data to the right place
Pricing
Freemium, from $49 a month
Free tier with 200 tool calls per day on a registered account; paid credits and subscriptions for higher use.
Prices change. Check pipeworx.io before you buy.
Google_sheets FAQ
Does the server work without an API key?
Yes. The README says calls without a Pipeworx key are anonymous and capped at 50 per day; a free account raises the cap to 200 per day.
Which tools does the pack provide?
The README lists sheets_read, sheets_write, sheets_append, sheets_get_spreadsheet and sheets_create.
Is this an official Google integration?
No. The README states it is an independent, unofficial integration not affiliated with or endorsed by the upstream provider.
Is Google_sheets free?
Google_sheets has a free plan, with paid plans for more usage or features. Paid plans start at $49 a month.
How do I add Google_sheets to Claude Code?
Run this command in your terminal: claude mcp add --transport http google_sheets https://gateway.pipeworx.io/google_sheets/mcp
What are the best alternatives to Google_sheets?
The closest alternatives to Google_sheets are Google_drive, Google Sheets MCP Server, MCP Gee Sweet, Onedrive and GridPath.
Where this comes from
- Description: written from the project's README, the project's website and its MCP Registry entry.
- Install steps: from the official MCP Registry entry.
