sheetcanvas.com WebMCP Tools, Schemas & Agent Capabilities

sheetcanvas.com

live Unverified (seed import) Productivity & Business 21 tools imperative implementation

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

createSparkline

act imperative

Creates a compact KPI table: one row per metric/group with a mini trend line over dateCol, a current value, and a Change cell colored by direction-of-good (green=better, red=worse). Good default for "overview" requests. mode:"metrics" charts each dataCols entry as a row (dataCols required). mode:"group" pivots groupCol into rows, aggregating valueCol with operation (all required). compareMode sets the delta column (default vs_avg). In-cell sparkline: use applyFormat visual:"sparkline".

Page: /

Input schema

Property	Type	Required	Description
`sheetId`	string	yes	—
`dateCol`	string	yes	—
`mode`	string	yes	—
`compareMode`	string	no	—
`dataCols`	array	no	—
`groupCol`	string	no	—
`valueCol`	string	no	—
`operation`	string	no	—
`summaryColumns`	array	no	Optional extra columns appended after the Change column: "avg" (mean), "minmax" (min and max), "share" (share-of-total as an in-cell bar). The Change
`goodDirections`	object	no	Per-metric direction of good, keyed by label. "up"=higher better (revenue); "down"=lower better (cost, churn). Inferred if omitted.
`title`	string	no	—

Raw JSON schema

{
  "type": "object",
  "properties": {
    "sheetId": {
      "type": "string"
    },
    "dateCol": {
      "type": "string",
      "pattern": "^[A-Z]+$"
    },
    "mode": {
      "type": "string",
      "enum": [
        "metrics",
        "group"
      ]
    },
    "compareMode": {
      "type": "string",
      "enum": [
        "vs_prev",
        "vs_avg",
        "vs_first"
      ]
    },
    "dataCols": {
      "type": "array",
      "items": {
        "type": "string",
        "pattern": "^[A-Z]+$"
      }
    },
    "groupCol": {
      "type": "string",
      "pattern": "^[A-Z]+$"
    },
    "valueCol": {
      "type": "string",
      "pattern": "^[A-Z]+$"
    },
    "operation": {
      "type": "string",
      "enum": [
        "SUM",
        "COUNT",
        "AVG",
        "MIN",
        "MAX"
      ]
    },
    "summaryColumns": {
      "description": "Optional extra columns appended after the Change column: \"avg\" (mean), \"minmax\" (min and max), \"share\" (share-of-total as an in-cell bar). The Change",
      "type": "array",
      "items": {
        "type": "string",
        "enum": [
          "avg",
          "minmax",
          "share"
        ]
      }
    },
    "goodDirections": {
      "description": "Per-metric direction of good, keyed by label. \"up\"=higher better (revenue); \"down\"=lower better (cost, churn). Inferred if omitted.",
      "type": "object",
      "propertyNames": {
        "type": "string"
      },
      "additionalProperties": {
        "type": "string",
        "enum": [
          "up",
          "down",
          "unknown"
        ]
      }
    },
    "title": {
      "type": "string"
    }
  },
  "required": [
    "sheetId",
    "dateCol",
    "mode"
  ],
  "additionalProperties": false
}