sheets_update_values
Modify and update specific ranges of data in Google Sheets by providing a spreadsheet ID, A1 notation range, and new values in a 2D array.
Instructions
Update values in a Google Sheet range
Input Schema
Name | Required | Description | Default |
---|---|---|---|
range | Yes | A1 notation range | |
spreadsheet_id | Yes | ID of the spreadsheet | |
values | Yes | 2D array of values |
Input Schema (JSON Schema)
{
"properties": {
"range": {
"description": "A1 notation range",
"type": "string"
},
"spreadsheet_id": {
"description": "ID of the spreadsheet",
"type": "string"
},
"values": {
"description": "2D array of values",
"items": {
"items": {
"type": "string"
},
"type": "array"
},
"type": "array"
}
},
"required": [
"spreadsheet_id",
"range",
"values"
],
"type": "object"
}