sheets_batch_update_values
Update multiple ranges in a Google Sheets spreadsheet with new values in one request. Specify spreadsheet ID, range-value pairs, and input interpretation (RAW or USER_ENTERED).
Instructions
Update values in multiple ranges of a Google Sheets spreadsheet
Input Schema
Name | Required | Description | Default |
---|---|---|---|
data | Yes | Array of range-value pairs to update | |
spreadsheetId | Yes | The ID of the spreadsheet (found in the URL after /d/) | |
valueInputOption | No | How the input data should be interpreted (default: USER_ENTERED) |
Input Schema (JSON Schema)
{
"properties": {
"data": {
"description": "Array of range-value pairs to update",
"items": {
"properties": {
"range": {
"description": "The A1 notation range to update",
"type": "string"
},
"values": {
"description": "A 2D array of values for this range",
"items": {
"type": "array"
},
"type": "array"
}
},
"required": [
"range",
"values"
],
"type": "object"
},
"type": "array"
},
"spreadsheetId": {
"description": "The ID of the spreadsheet (found in the URL after /d/)",
"type": "string"
},
"valueInputOption": {
"description": "How the input data should be interpreted (default: USER_ENTERED)",
"enum": [
"RAW",
"USER_ENTERED"
],
"type": "string"
}
},
"required": [
"spreadsheetId",
"data"
],
"type": "object"
}