Google Super
GOOGLESUPER_BATCH_UPDATE
Updates a specified range in a Google Sheet with given values, or appends them as new rows if `first_cell_location` is omitted. Auto-expands grid for large datasets, preventing range errors. Requirements: Target sheet must exist and spreadsheet must contain at least one worksheet.
Remote googlesuper
Other tools also called GOOGLESUPER_BATCH_UPDATE?
See providers with this name
Input Schema
{
"type": "object",
"properties": {
"values": {
"type": "array",
"items": {
"type": "array",
"items": {
"anyOf": [
{
"type": "string"
},
{
"type": "integer"
},
{
"type": "number"
},
{
"type": "boolean"
},
{
"type": "null"
}
]
},
"properties": {}
},
"title": "Values",
"examples": [
[
[
"Item",
"Cost",
"Stocked",
"Ship Date"
],
[
"Wheel",
20.5,
true,
"2020-06-01"
],
[
"Screw",
0.5,
true,
"2020-06-03"
],
[
"Nut",
0.25,
false,
"2020-06-02"
]
]
],
"description": "A 2D array of cell values where each inner array represents a row. Values can be strings, numbers, booleans, or None/null for empty cells. Ensure columns are properly aligned across rows."
},
"sheet_name": {
"type": "string",
"title": "Sheet Name",
"examples": [
"Sheet1",
"Sales Data",
"Budget"
],
"description": "The name of the specific sheet (tab) within the spreadsheet to update. Case-sensitive."
},
"spreadsheet_id": {
"type": "string",
"title": "Spreadsheet Id",
"examples": [
"1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms"
],
"description": "The unique identifier of the Google Sheets spreadsheet to be updated. Can be found in the spreadsheet URL."
},
"valueInputOption": {
"enum": [
"RAW",
"USER_ENTERED"
],
"type": "string",
"title": "Value Input Option",
"default": "USER_ENTERED",
"examples": [
"USER_ENTERED",
"RAW"
],
"description": "How input data should be interpreted. 'USER_ENTERED': Values are parsed as if typed by a user (e.g., strings may become numbers/dates, formulas are calculated). 'RAW': Values are stored exactly as provided without parsing (e.g., '123' stays as string, '=SUM(A1:B1)' is not calculated)."
},
"first_cell_location": {
"type": "string",
"title": "First Cell Location",
"examples": [
"A1",
"D3"
],
"description": "The starting cell for the update range, specified in A1 notation (e.g., 'A1', 'B2'). The update will extend from this cell to the right and down, based on the provided values. If omitted, values are appended to the sheet."
},
"includeValuesInResponse": {
"type": "boolean",
"title": "Include Values In Response",
"default": false,
"examples": [
true,
false
],
"description": "If set to True, the response will include the updated values from the spreadsheet after the update is applied."
}
}
}