gsheets_spreadsheets_values_get
Retrieve values from a specified Google Sheets range to read spreadsheet data for reports, briefs, or workflows. Use spreadsheet ID and A1/R1C1 range to fetch rows or columns.
Instructions
Returns a range of values from a spreadsheet.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| range | Yes | The A1 notation or R1C1 notation of the range to retrieve values from. | |
| spreadsheetId | Yes | The ID of the spreadsheet to retrieve data from. | |
| majorDimension | No | The major dimension that results should use. For example, if the spreadsheet data in Sheet1 is: A1=1,B1=2,A2=3,B2=4, then requesting range=Sheet1!A1:B2?majorDimension=ROWS returns [[1,2],[3,4]], whereas requesting range=Sheet1!A1:B2?majorDimension=COLUMNS returns [[1,3],[2,4]]. | |
| valueRenderOption | No | How values should be represented in the output. The default render option is FORMATTED_VALUE. | |
| dateTimeRenderOption | No | How dates, times, and durations should be represented in the output. This is ignored if valueRenderOption is FORMATTED_VALUE. The default dateTime render option is SERIAL_NUMBER. |