sheetcanvas.com
Connect Claude, Codex, or another MCP-capable agent to SheetCanvas so messy business data becomes durable tables, charts, pivots, notes, and dashboards.
First seen 2026-09-14 · Last seen 2026-09-14 · Source: webmcp.com
Answer 10 · Act 10 · Transact 1 · Score: Not yet scored
Tool inspector
createPivot
Creates a pivot-table sheet derived from a source sheet; recomputes when the source changes. Use for chartable aggregation or a reusable summary from row-level data — build the pivot, then createChart on it (for one-off exploration with no persistent output, use querySheet instead). rowLabelCol groups rows; colLabelCol (optional) splits into columns for a 2-D pivot; values is one or more metric cards with operation, optional label, COUNT semantics, and AND-only SUMIF/COUNTIF conditions.
Page: /
Input schema
| Property | Type | Required | Description |
|---|---|---|---|
sheetId |
string | yes | — |
rowLabelCol |
string | yes | — |
colLabelCol |
string | no | — |
values |
array | yes | — |
showRowTotals |
boolean | no | — |
showColTotals |
boolean | no | — |
title |
string | no | — |
Raw JSON schema
{
"type": "object",
"properties": {
"sheetId": {
"type": "string"
},
"rowLabelCol": {
"type": "string",
"pattern": "^[A-Z]+$"
},
"colLabelCol": {
"type": "string",
"pattern": "^[A-Z]+$"
},
"values": {
"minItems": 1,
"type": "array",
"items": {
"type": "object",
"properties": {
"column": {
"type": "string",
"pattern": "^[A-Z]+$"
},
"operation": {
"type": "string",
"enum": [
"SUM",
"COUNT",
"AVG",
"MIN",
"MAX"
]
},
"label": {
"type": "string",
"minLength": 1,
"maxLength": 80
},
"conditions": {
"type": "array",
"items": {
"anyOf": [
{
"type": "object",
"properties": {
"columnId": {
"type": "string",
"pattern": "^[A-Z]+$"
},
"type": {
"type": "string",
"const": "text"
},
"operator": {
"type": "string",
"enum": [
"contains",
"equals",
"startsWith",
"endsWith"
]
},
"value": {
"type": "string"
}
},
"required": [
"columnId",
"type",
"operator",
"value"
],
"additionalProperties": false
},
{
"oneOf": [
{
"type": "object",
"properties": {
"columnId": {
"type": "string",
"pattern": "^[A-Z]+$"
},
"type": {
"type": "string",
"const": "number"
},
"operator": {
"type": "string",
"enum": [
"gt",
"lt",
"eq",
"neq"
]
},
"value": {
"type": "number"
}
},
"required": [
"columnId",
"type",
"operator",
"value"
],
"additionalProperties": false
},
{
"type": "object",
"properties": {
"columnId": {
"type": "string",
"pattern": "^[A-Z]+$"
},
"type": {
"type": "string",
"const": "number"
},
"operator": {
"type": "string",
"const": "range"
},
"value": {
"minItems": 2,
"maxItems": 2,
"type": "array",
"items": {
"type": "number"
}
}
},
"required": [
"columnId",
"type",
"operator",
"value"
],
"additionalProperties": false
}
]
},
{
"oneOf": [
{
"type": "object",
"properties": {
"columnId": {
"type": "string",
"pattern": "^[A-Z]+$"
},
"type": {
"type": "string",
"const": "date"
},
"operator": {
"type": "string",
"enum": [
"before",
"after",
"on"
]
},
"value": {
"type": "string"
}
},
"required": [
"columnId",
"type",
"operator",
"value"
],
"additionalProperties": false
},
{
"type": "object",
"properties": {
"columnId": {
"type": "string",
"pattern": "^[A-Z]+$"
},
"type": {
"type": "string",
"const": "date"
},
"operator": {
"type": "string",
"const": "range"
},
"value": {
"minItems": 2,
"maxItems": 2,
"type": "array",
"items": {
"type": "string"
}
}
},
"required": [
"columnId",
"type",
"operator",
"value"
],
"additionalProperties": false
}
]
}
]
}
},
"countRows": {
"type": "boolean"
}
},
"required": [
"operation"
],
"additionalProperties": false
}
},
"showRowTotals": {
"type": "boolean"
},
"showColTotals": {
"type": "boolean"
},
"title": {
"type": "string"
}
},
"required": [
"sheetId",
"rowLabelCol",
"values"
],
"additionalProperties": false
}
Similar websites
eworker.ca
E-Worker is business infrastructure powered by AI, with focused apps and connected business work.
urban-planning-copilot.heisenbug.in
Urban Planning Copilot
vide.zerdalu.com
Vide
labspace-agent-twin.onrender.com
LabSpace Atlas — design laboratories, index exact locations, and let a browser agent plan, audit, and navigate the spatial twin.