← MCP Catalog

batch_update_cells

Batch update multiple ranges in a Google Spreadsheet. Args: spreadsheet_id: The ID of the spreadsheet (found in the URL) sheet: The name of the sheet ranges: Dictionary mapping range strings to 2D arrays of values e.g., {'A1:B2': [[1, 2], [3, 4]], 'D1:E2': [['a', 'b'], ['c', 'd']]} Returns: Result of the batch update operation

MCPGoogle Sheets AuthorizationPrivate connector
Can change or delete data

Parameters

spreadsheet_idstring · required

sheetstring · required

rangesobject · required