sheet.setCells
Update multiple spreadsheet cells efficiently with one call, supporting both static values and formulas for sparse data modifications.
Instructions
Set multiple cells in one call - efficient for sparse updates. Values starting with "=" are treated as formulas.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| nodeId | Yes | Sheet node ID or name | |
| cells | Yes | Array of cell updates: [{ row: 0, col: 2, value: "text" }, { row: 5, col: 2, value: "=A6*B6" }] |