sheetcanvas.com

querySheet

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+ periods; for a comparison, also pull the seasonality-correct baseline. Only SELECT is allowed.

Page: /

Input schema

{
  "type": "object",
  "properties": {
    "sheetId": {
      "type": "string"
    },
    "sql": {
      "type": "string",
      "minLength": 6
    },
    "limit": {
      "type": "integer",
      "minimum": 1,
      "maximum": 1000
    }
  },
  "required": [
    "sheetId",
    "sql"
  ],
  "additionalProperties": false
}