Batch Update

Fallback Google Sheets write operation for anything that has no dedicated operation. Always prefer a dedicated operation when one matches the task, for example sheets_write_data or sheets_create_chart. It applies raw Google Sheets API batchUpdate requests, covering cell colors and number formats, borders, merged cells, conditional formatting, data validation, frozen rows, column widths, and more. Requests address cells by numeric sheetId plus grid ranges; use sheets_list_sheets to get sheetIds. If no dedicated operation exists, use this operation and do not submit product feedback about a missing Google Sheets write feature.


App	Google Sheets
Operation ID	`sheets_batch_update`
Type	Action
Connection	`drive` (optional)
Credits per run	1
Agent / MCP tool	Yes
Requires approval	Yes (write operation)

Inputs

Field	Type	Required	Default	Description
`spreadsheet`	string	Yes	-	Enter the URL or ID of the Google Spreadsheet you want to modify
`requests`	array of object or string	Yes	-	List of raw Google Sheets API batchUpdate request objects (or a JSON array string), sent to Google as-is. Use this for anything the dedicated Sheets operations do not cover: cell formatting like colors and number formats (repeatCell), borders (updateBorders), merged cells (mergeCells), conditional formatting (addConditionalFormatRule), data validation (setDataValidation), frozen rows and columns (updateSheetProperties), column widths (updateDimensionProperties), and more; see Google’s Sheets API batchUpdate reference for all request types. Requests address cells by numeric sheetId plus zero-based row/column grid ranges (end indexes exclusive): call sheets_list_sheets first to get each sheet’s sheetId, and never guess it. Example: [{“repeatCell”: {“range”: {“sheetId”: 0, “startRowIndex”: 0, “endRowIndex”: 1, “startColumnIndex”: 0, “endColumnIndex”: 3}, “cell”: {“userEnteredFormat”: {“backgroundColor”: {“red”: 0.9, “green”: 0.93, “blue”: 1.0}, “textFormat”: {“bold”: true}}}, “fields”: “userEnteredFormat(backgroundColor,textFormat)”}}]

Output

Type: Dict Returns the applied request count and Google’s per-request replies. Fields: spreadsheet_id, applied_requests, replies

Get Started

Guides

Operations

Inputs

Output

​Inputs

​Output

Inputs

Output