Google Sheets
GOOGLESHEETS_BATCH_GET
Retrieves data from specified cell ranges in a Google Spreadsheet.
Remote googlesheets
Other tools also called GOOGLESHEETS_BATCH_GET?
See providers with this name
Input Schema
{
"type": "object",
"properties": {
"ranges": {
"type": "array",
"items": {
"type": "string"
},
"description": "A list of cell ranges in A1 notation (e.g., 'Sheet1!A1:B2', 'A1:C5') from which to retrieve data. If this list is omitted or empty, all data from the first sheet of the spreadsheet will be fetched. A range can specify a sheet name (e.g., 'Sheet2!A:A'); if no sheet name is provided in a range string (e.g., 'A1:B2'), it defaults to the first sheet. For sheet names with spaces or special characters, enclose in single quotes (e.g., \"'My Sheet'!A1:B2\").\nExamples:\n \"Sheet1!A1:B2\"\n \"Sheet1!A:A\"\n \"Sheet1!1:2\"\n \"'My Sheet'!A5:A\"\n \"A1:B2\""
},
"spreadsheet_id": {
"type": "string",
"maxLength": 100,
"description": "The unique identifier of the Google Spreadsheet from which data will be retrieved. This is the ID found in the spreadsheet URL after /d/.\nExample: \"1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms\""
},
"valueRenderOption": {
"enum": [
"FORMATTED_VALUE",
"UNFORMATTED_VALUE",
"FORMULA"
],
"type": "string",
"default": "FORMATTED_VALUE",
"description": "How values should be rendered in the output. FORMATTED_VALUE: Values are calculated and formatted (default). UNFORMATTED_VALUE: Values are calculated but not formatted. FORMULA: Values are not calculated; the formula is returned instead."
},
"dateTimeRenderOption": {
"enum": [
"SERIAL_NUMBER",
"FORMATTED_STRING"
],
"type": "string",
"default": "SERIAL_NUMBER",
"description": "How dates and times should be rendered in the output. SERIAL_NUMBER: Dates are returned as serial numbers (default). FORMATTED_STRING: Dates returned as formatted strings."
}
}
}