Files & calendar · gsheets_pivot
Create a pivot table (Google Sheets)
Pivot table in a Google Sheets spreadsheet: rows, columns and values by header name.
- Price
- included
- Requirements
- Google Drive
- set it up in Settings → Integrations
- Human approval
- Yes, by default
- outside-facing write: a human validates
- Reliability
- Verified
- not measured yet
Input
| Field | Type | Description |
|---|---|---|
| spreadsheet * | string | Spreadsheet id or URL. |
| source * | string | Source range in A1 notation, e.g. "Données!A1:F500". |
| rows * | array | |
| columns | array | |
| values * | array | |
| anchor | string | Cell where the pivot table starts, e.g. "Synthèse!A1". |
Call this tool
Through the HTTP API, or from the MCP server with the run meta-tool.
curl https://api.ezyagents.fr/gateway/v1/run \
-H "Authorization: Bearer ezk_…" -H "Content-Type: application/json" \
-d '{"tool":"gsheets_pivot","input":{"spreadsheet":"…","source":"…","rows":[],"columns":[]}}'$
run({ "tool": "gsheets_pivot", "input": {"spreadsheet":"…","source":"…","rows":[],"columns":[]} })