Read a Google Sheet range
read_sheetRetrieve cell data from a Google Sheet by providing its spreadsheet ID or URL, with optional A1 range, returning values as a 2-D array.
Instructions
Read cells from a Google Sheet Hermoso can reach — one it created, or one the user handed over with the Google file picker in the app (that is how an EXISTING spreadsheet becomes readable; find its id with list_drive_files). Pass the spreadsheetId (from create_sheet) OR paste a Google Sheets URL as sheetUrl. If Google answers that the file was not found, the user has not picked it yet — ask them to pick it in the app rather than retrying. Returns a 2-D array of values.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| range | No | A1 range, e.g. "A1:D50" (default A1:Z1000) | |
| sheetUrl | No | a Google Sheets URL to read — the spreadsheet id is extracted from it | |
| spreadsheetId | No | the spreadsheet id (from create_sheet) |