sheetcanvas.com

Last change

None yetUnchanged since first read.

Declared read-only

9 of 21

llms.txt

Present

1. applyFilterDoes not say

   Replace filters on a sheet. Pass an empty array to clear filters.

   First seen 12 Oct 2026. Unchanged since.

2. applyFormatDoes not say

   Applies presentation formatting (units, decimals, dates, in-cell visuals) to an A1 range without changing values; works on normal and derived sheets. Pass exactly one of format or preset, not both. preset is a shortcut (integer, decimal, compactNumber, currency, compactCurrency, percent, date, datetime, duration, text, customD3); customD3 needs d3Format. Use visual:"bar" for a primary metric; use

   First seen 12 Oct 2026. Unchanged since.

3. applySortDoes not say

   Set or clear the sort on a sheet. Pass null to clear.

   First seen 12 Oct 2026. Unchanged since.

4. createChartDoes not say

   Creates a chart from a source sheet; response includes formDecisions. mode:"group" aggregates row-level data via groupCol/valueCol/operation. mode:"metrics" charts aggregated columns: labelColumn is X-axis, dataColumns are Y series. Time-series charts need timeRange and timeGranularity. Duplicate X labels in metrics mode mean data is too granular — use mode:"group" or createPivot first. For "does

   First seen 12 Oct 2026. Unchanged since.

5. createNoteDoes not say

   Creates a live report note: Markdown that can embed data-bound components staying live as sheets change. Embed up to three self-closing tags — <CellValue sheet="ID" cell="B4" format="currency"/>, <CanvasChart id="ID" height="240"/>, <Sparkline sheet="ID" range="B2:B12"/>; any other tag renders as inert text. sheet/id values MUST be real ids from earlier results (createQuerySheet, createPivot, crea

   First seen 12 Oct 2026. Unchanged since.

6. createPivotDoes not say

   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 ca

   First seen 12 Oct 2026. Unchanged since.

7. createSheetDoes not say

   Creates a new standalone sheet for manual, scratch, or agent-computed data (an assembled table, fill-in template, or derived summary). data is optional: rows of raw cell strings, row 1 is the header; a cell may be a literal or "=FORMULA(...)". Omit data for a blank grid. Has NO data source and does not auto-refresh — for connector data (ClickHouse, Google Analytics, Google Sheets) use createQueryS

   First seen 12 Oct 2026. Unchanged since.

8. createSparklineDoes not say

   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

   First seen 12 Oct 2026. Unchanged since.

9. deleteNoteDoes not say

   Permanently delete a report note from the canvas by id. This is destructive and cannot be undone by the agent (the user can still undo in-app). Only delete a note you created or the user explicitly asked to remove. Errors if the noteId does not exist.

   First seen 12 Oct 2026. Unchanged since.

10. describeConnectionDoes not say

    Describes one data connection and returns the schemaToken needed by queryConnection/createQuerySheet/updateQuerySheet, plus a queryShape (payloadSchema, requiredFields, examples) for building queryPayload — read it before any connector query. ClickHouse without table returns tables[] only; with table returns columns[] and schemaToken. Google Analytics needs propertyId, returns a dimensions[]/metri

    First seen 12 Oct 2026. Unchanged since.

11. describeSheetReads only

    Use this to inspect one sheet before querying or mutating it. Returns the schema and a small sample: compact columnIdSpan (for example A:BB), column ids/letters, header cells, data ranges, column headers, inferred types, row count, row-numbering convention, current filters and sort, and up to 5 sample rows with row numbers. If the user named specific column letters such as AU or BB, pass them in c

    First seen 12 Oct 2026. Unchanged since.

12. getRangeReads only

    Read the raw and computed values of a specific A1 range on a sheet.

    First seen 12 Oct 2026. Unchanged since.

13. getSelectionReads only

    Use this first for requests like "this data", "selected chart", "current sheet", or "what I selected", before deciding which sheet/chart to inspect or mutate. Returns what the user currently has selected: the active sheet cell/range selection plus selectedCanvas.items for whole selected sheets, charts, and notes.

    First seen 12 Oct 2026. Unchanged since.

14. listConnectionPropertiesReads only

    Use this after choosing a GA connection and before describeConnection — it lists selectable properties/resources for one data connection. Google Analytics returns a bounded properties[] page with propertyId, displayName, accountDisplayName, nextPageToken, truncated.

    First seen 12 Oct 2026. Unchanged since.

15. listConnectionsReads only

    Use this first before querying external data — it lists all configured data connections (ClickHouse, Google Analytics, Google Sheets). Returns connectionId, type, name, duplicate-name hints, best-effort health, GA property hints, sheets using each connection, plus selectedCanvas context.

    First seen 12 Oct 2026. Unchanged since.

16. listNotesReads only

    Use this to discover note ids before reading or updating a note — it lists all report notes currently on the canvas. Returns each note's noteId, a derived title (first heading/line), a short text preview, color, and format. Returns an empty list if there are no notes.

    First seen 12 Oct 2026. Unchanged since.

17. listSheetsReads only

    Use this first to discover what is on the canvas: lists all sheets with id, title, dimensions, compact columnIdSpan (for example A:BB), row-numbering convention, and column headers. Column ids like A, AU, or BB are spreadsheet column letters and may be used directly in tool inputs.

    First seen 12 Oct 2026. Unchanged since.

18. querySheetReads only

    Runs a read-only SQL SELECT against one sheet for exploration, validation, filtering, or previewing aggregates before writing anything. Results are temporary, not chartable — to chart an aggregate, build a summary with createPivot first, then createChart on it. The sheet is table "t"; column names come from schema.sqlName (sanitized, e.g. hostname) — inspect schema first. For a trend, pull ~8+ per

    First seen 12 Oct 2026. Unchanged since.

19. readNoteReads only

    Use this before updateNote so you edit against the real current text rather than guessing — it reads one report note by id. Returns its full raw Markdown source (content, exactly as stored — including any <CellValue>/<CanvasChart>/<Sparkline> tags), plus color and format. Errors if the noteId does not exist (get ids from listNotes or a prior createNote).

    First seen 12 Oct 2026. Unchanged since.

20. setCellsDoes not say

    Write cells on a sheet. Pass A1-keyed map of { raw } values. Use "=FORMULA(...)" for formulas. Will overwrite existing cells.

    First seen 12 Oct 2026. Unchanged since.

21. updateNoteDoes not say

    Updates an existing report note in place — revise wording, add/remove a section, or swap a chart. Requires noteId plus at least one of content or color. content REPLACES the entire Markdown body; there is no append/patch mode — read the note first with readNote, edit the full text, then send it back. Supports the same three live tags as createNote (<CellValue>, <CanvasChart>, <Sparkline>); unknown

    First seen 12 Oct 2026. Unchanged since.

Run this site? This page shows what your site told our crawler, ToolChronicleBot. To be left out, disallow it in robots.txt or write to hello@toolchronicle.com.