Get Sheet Data
get_sheet_dataRead cell values from a specified range in a Google Spreadsheet using A1 notation, such as 'Sheet1!A1:D10' or 'Sheet1' for an entire tab.
Instructions
Reads cell values from a range in A1 notation (e.g. 'Sheet1!A1:D10' or 'Sheet1' for the entire tab).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| range | Yes | A1 notation range, e.g. 'Sheet1!A1:D10' or 'Sheet1' for the entire tab | |
| spreadsheet | Yes | Target spreadsheet: a full Google Sheets URL (https://docs.google.com/spreadsheets/d/<ID>/edit...) or a bare spreadsheet ID |