Skip to content
MCP server

Google_sheets

MCP server giving AI clients read, write, append and create access to Google Sheets

Install
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/mcp

Add to Settings → Connectors → Add custom connector

https://gateway.pipeworx.io/google_sheets/mcp
Install in CursorOpens Cursor, which asks you to confirm. Or add it by hand:

Add to ~/.cursor/mcp.json

{
  "mcpServers": {
    "google_sheets": {
      "url": "https://gateway.pipeworx.io/google_sheets/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": {
      "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.

How AIPoweredBot checks servers