add_block_rows
Insert new rows into a spreadsheet block, appending at the end or before/after a specific row. Auto-installs validation and shifts sheet rows automatically.
Instructions
Add rows to an existing block. Appends at the end by default; pass after_key or before_key to insert at a position instead. Each row needs a key; values is an object keyed by field name. Fields with a value_formula are auto-materialized by the engine — don't pass them in values. Validation/editability shadows for the new rows are auto-installed by the engine at InsertRowsInBlock time, so no follow-up is needed. Also inserts the matching sheet rows (one block per sheet-row assumption — extends the sheet so downstream rows shift down).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| rows | Yes | ||
| block | Yes | Block ref name. | |
| after_key | No | Insert directly after the row with this key, instead of appending at the end. Mutually exclusive with before_key. | |
| before_key | No | Insert directly before the row with this key. Use the first key to insert at the top. Mutually exclusive with after_key. |