Google Sheets

liveSaaSProductivity

Read, write, append, and create Google Sheets spreadsheets via OAuth — rows, ranges, and metadata.

5tools
0msauth
free tier50 calls/day

Tools

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.

No parameters required.

▶Try it
sheets_write

Write data to a Google Sheet range, overwriting existing values. Specify sheet name, range (e.g., 'A1:C10'), and row data.

No parameters required.

▶Try it
sheets_append

Append new rows to the end of a Google Sheet table. Specify sheet name and row data to add.

No parameters required.

▶Try it
sheets_get_spreadsheet

Explore a spreadsheet's structure. Returns title, sheet/tab names, and properties. Use before reading or writing data.

No parameters required.

▶Try it
sheets_create

Create a new Google Spreadsheet. Optionally set title and initial sheet names. Returns spreadsheet ID and sharing URL.

No parameters required.

▶Try it

Test with curl

The gateway speaks JSON-RPC 2.0 over HTTP POST. You can test any pack directly from the terminal.

List available tools
bash
curl -X POST https://gateway.pipeworx.io/google_sheets/mcp \
  -H "Content-Type: application/json" \
  -d '{"jsonrpc":"2.0","id":1,"method":"tools/list"}'
Call a tool
bash
curl -X POST https://gateway.pipeworx.io/google_sheets/mcp \
  -H "Content-Type: application/json" \
  -d '{"jsonrpc":"2.0","id":2,"method":"tools/call","params":{"name":"sheets_read","arguments":{}}}'

Use with the SDK

Install @pipeworx/sdk to call tools from any TypeScript/Node project.

TypeScript
import { Pipeworx } from '@pipeworx/sdk';
const px = new Pipeworx();
const result = await px.call("sheets_read", {});
ask_pipeworx
// Or ask in plain English:
const answer = await px.ask("read, write, append, and create google sheets spreadsheets via oauth — rows, ranges, and metadata");