sheetcanvas.com

describeSheet

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 columnIds so they are echoed in requestedColumns even on wide sheets.

Page: /

Input schema

{
  "type": "object",
  "properties": {
    "sheetId": {
      "type": "string"
    },
    "columnIds": {
      "type": "array",
      "items": {
        "type": "string",
        "pattern": "^[A-Z]+$"
      }
    }
  },
  "required": [
    "sheetId"
  ],
  "additionalProperties": false
}