sheets_get_values
Retrieve cell values from a Google Sheets spreadsheet using spreadsheet ID and A1 notation range. Returns data in the requested dimension and format.
Instructions
Get values from a specified range in a Google Sheets spreadsheet
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| range | Yes | The A1 notation range to retrieve (e.g., "Sheet1!A1:B10") | |
| spreadsheetId | Yes | The ID of the spreadsheet (found in the URL after /d/) | |
| majorDimension | No | The major dimension of the values (default: ROWS) | |
| valueRenderOption | No | How values should be represented (default: FORMATTED_VALUE) |