read_cells
Read cell values from a specified spreadsheet range using A1 notation. Returns a JSON 2D array of the data, ready for further processing.
Instructions
Read cell values from a spreadsheet range.
Examples: - read_cells("abc123", "Sheet1!A1:D10") → Read 10 rows, 4 columns - read_cells("abc123", "Sheet1!A:A") → Read entire column A - read_cells("abc123", "A1:B5") → Read from first visible sheet
Args: spreadsheet_id: The ID from the spreadsheet URL. range_notation: A1 notation range. Use 'SheetName!A1:B5' format.
Returns: JSON 2D array of cell values. Empty cells may be omitted.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| range_notation | Yes | ||
| spreadsheet_id | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |