set_block_cells
Update spreadsheet block cells atomically by specifying block, row key, field, and value. Supports batching multiple writes into one transaction for consistent data changes.
Instructions
Write one or more cells inside any block(s) in a single atomic transaction. Each change addresses a cell by (block ref name, row_key, field) — the LLM never deals with raw (sheet, row, col).
Pass changes as an array; one-cell writes are just length-1 arrays. Batching is the cheap default — putting N writes in one call is one transaction, one calc pass, one undo entry.
Rejected up-front (whole tx aborts) when any change:
targets a non-existent block / row_key / field, or
targets a field with a
value_formulaon its schema (engine-computed; use set_field_rule to change the rule instead).
Value can be a literal (string / number / boolean) or a formula prefixed with '='. null clears the cell.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| changes | Yes |