Google Sheets
gs_batch_read
Read values from multiple ranges at once. More efficient than multiple gs_read_values calls.
Remote node2flow/google-sheets
Other tools also called gs_batch_read?
See providers with this name
Input Schema
{
"type": "object",
"properties": {
"ranges": {
"type": "array",
"items": {
"type": "string"
},
"description": "A1 notation ranges to read (e.g. [\"Sheet1!A1:B5\", \"Sheet2!A1:D10\"])"
},
"spreadsheet_id": {
"type": "string",
"description": "The spreadsheet ID"
},
"major_dimension": {
"type": "string",
"description": "How values are organized: \"ROWS\" (default) or \"COLUMNS\""
},
"value_render_option": {
"type": "string",
"description": "How values are rendered: \"FORMATTED_VALUE\" (default), \"UNFORMATTED_VALUE\", \"FORMULA\""
}
}
}