atlas_sheet_append
Append a new row to a spreadsheet tab by mapping column header names to values, validating headers before writing and verifying the entry by read-back. Use it to add new item or parameter rows.
Instructions
Append a new row to a spreadsheet tab by mapping column header names to values.
Use this tool when adding a new entry (e.g. a new unit, item, or parameter row) to a bound spreadsheet.
To modify cells of an existing row, use `atlas_sheet_update` instead.
Behavior & Output:
- Not idempotent: each non-dry-run call appends a new row at the bottom of the table and verifies it by read-back.
- Validates all keys in `values` against the tab's header row before writing.
- Returns JSON `{ok, sheet, tab, values, range, verified, resynced, dry_run}` and updates the local search index.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| tab | Yes | Exact worksheet/tab name inside the spreadsheet (e.g. 'Units'). Use `atlas_sheets` to discover valid tab names. | |
| sheet | No | Optional spreadsheet name or ID when multiple spreadsheets are bound to the project. | |
| values | Yes | Mapping of `{column_header_name: value}` for the new row (e.g. `{"ID": "monster_goblin", "Name": "Goblin", "HP": 100}`). Omitted columns are left empty. | |
| dry_run | No | If true, validate column headers and preview the row without writing to the spreadsheet (default false). |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |