Google Sheets
gs_batch_write
Write values to multiple ranges at once. More efficient than multiple gs_write_values calls.
Remote node2flow/google-sheets
Other tools also called gs_batch_write?
See providers with this name
Input Schema
{
"type": "object",
"properties": {
"data": {
"type": "array",
"items": {
"type": "object",
"required": [
"range",
"values"
],
"properties": {
"range": {
"type": "string",
"description": "A1 notation range"
},
"values": {
"type": "array",
"items": {
"type": "array",
"items": {}
},
"description": "2D array of values"
}
}
},
"description": "Array of {range, values} objects. Example: [{\"range\":\"A1:B2\",\"values\":[[\"a\",\"b\"],[\"c\",\"d\"]]}]"
},
"spreadsheet_id": {
"type": "string",
"description": "The spreadsheet ID"
},
"value_input_option": {
"type": "string",
"description": "How input is interpreted: \"USER_ENTERED\" (default) or \"RAW\""
}
}
}