Summary
Connects Claude to Google Sheets via the Pipeworx gateway with five core operations: read ranges, write to specific cells, append rows, inspect spreadsheet structure, and create new spreadsheets. You get the standard CRUD operations you'd expect, plus a sheets_get_spreadsheet tool to explore tabs and properties before manipulating data. Runs over streamable HTTP instead of stdio, and includes an ask_pipeworx wrapper that lets you query in natural language instead of calling tools directly. Useful if you're building workflows that need to read from or write to Google Sheets without managing the API directly. Part of Pipeworx's larger gateway covering 673+ data sources.
Keep your Mac awake while Claude Code and 40+ AI agents run. Sleeps when they're idle.
One time payment $9 →
Integrate web data into your AI product. One API to scrape website & brand data.
Get API Key Now →
Agent, run crypto. Access onchain data & trade routes via 1inch.
Install now →
On Capafy, your Skill runs online 24/7 as an agent product, and you get paid every time someone uses it.
Start earning →
mcp-google_sheets
Google Sheets MCP Pack
Part of Pipeworx — an MCP gateway connecting AI agents to 673+ live data sources.
Tools
| Tool | Description |
|---|---|
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. |
Quick Start
Add to your MCP client (Claude Desktop, Cursor, Windsurf, etc.):
{
"mcpServers": {
"google_sheets": {
"url": "https://gateway.pipeworx.io/google_sheets/mcp"
}
}
}
Or connect to the full Pipeworx gateway for access to all 673+ data sources:
{
"mcpServers": {
"pipeworx": {
"url": "https://gateway.pipeworx.io/mcp"
}
}
}
Using with ask_pipeworx
Instead of calling tools directly, you can ask questions in plain English:
ask_pipeworx({ question: "your question about Google_sheets data" })
The gateway picks the right tool and fills the arguments automatically.
More
License
MIT
Featured
Keep your Mac awake while Claude Code and 40+ AI agents run. Sleeps when they're idle.
One time payment $9 →Integrate web data into your AI product. One API to scrape website & brand data.
Get API Key Now →Agent, run crypto. Access onchain data & trade routes via 1inch.
Install now →On Capafy, your Skill runs online 24/7 as an agent product, and you get paid every time someone uses it.
Start earning →
