get_sheet_data
Read spreadsheet sheet rows as JSON records, optionally selecting columns and paging through large sheets for easier processing.
Instructions
Return a sheet's rows as JSON records, optionally limited to some columns and paged.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| path | Yes | Path to the spreadsheet file (absolute, or relative to the first allowed directory) | |
| limit | No | Max rows to return (max 5000) | |
| sheet | No | Sheet name. Defaults to the first sheet. | |
| offset | No | Data rows to skip, for paging | |
| columns | No | Only return these columns. Defaults to all. | |
| header_row | No | 1-based row holding column names; 0 means no header (columns named A, B, C...) |