mcp-gsheetsTools Reference
sheets_batch_update_values
Write data to multiple ranges in one request
sheets_batch_update_values
Write data to multiple ranges in a single API call.
Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
spreadsheetId | string | Yes | The spreadsheet ID |
data | array | Yes | Array of range-value pairs |
valueInputOption | string | No | RAW or USER_ENTERED (default) |
Example
{
"tool": "sheets_batch_update_values",
"arguments": {
"spreadsheetId": "1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms",
"data": [
{
"range": "Sheet1!A1:B2",
"values": [
["Header1", "Header2"],
["Value1", "Value2"]
]
},
{
"range": "Sheet2!A1",
"values": [["Summary"]]
}
]
}
}