read_records
Read a Google Sheets tab as labelled records using a header row, returning each row's sheet row number for later updates.
Instructions
Read a tab as labelled records, using one row as the column headers.
Each record includes a _row field with its 1-based sheet row number, which
you can use to build an A1 range for a later update.
Args: spreadsheet_id: The long token from the spreadsheet URL. sheet_name: The tab name, e.g. "Sales". header_row: 1-based row number holding the column headers. limit: Maximum number of data records to return.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | ||
| header_row | No | ||
| sheet_name | Yes | ||
| spreadsheet_id | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||