gsheets_read
Read data from native Google Sheets documents using spreadsheet ID and optional range or sheet parameters for targeted retrieval.
Instructions
Read data from Google Sheets (native Google Sheets only, not Excel/CSV files uploaded to Drive). For Excel files (.xlsx), use gdrive_read_file instead. Supports flexible range selection and formatting options.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| ranges | No | Optional array of A1 notation ranges like ['Sheet1!A1:B10']. If not provided, reads entire sheet. | |
| sheetId | No | Optional specific sheet ID to read. If not provided with ranges, reads first sheet. | |
| spreadsheetId | Yes | The ID of the Google Sheets spreadsheet (not Excel file ID). Must be a native Google Sheets document. |