Frends.GoogleSheets.ReadSheet / 1.1.0
Summary
Reads a cell range and returns its values as rows, so the sheet becomes a data source a Process can loop over.
Typical use — spreadsheets people maintain by hand as the configuration or input for an integration
Essential parameters.
| Name | Type | Default | Example | Description |
|---|---|---|---|---|
| SpreadsheetId | String |
– | abcdef12345...98765ABC |
The ID of the spreadsheet. |
| Range | String |
Sheet1!A1:C10 |
Sheet1!A1:C10 |
The range of cells to read from the sheet, in A1 notation. |