Sync a spreadsheet with your schema
2 min · 3 steps
The Sync sub-tab keeps your scaffolded app in step with the source workbook — drift detection, push, and pull.
When you scaffold from a spreadsheet, Avery records the source file path in `.nxr/spreadsheet-source.json`. The Sync sub-tab reads it and offers three actions: detect drift (compare workbook vs. schema), push (write app rows back to the workbook), and pull (apply workbook edits to the database). The diff viewer color-codes severity so renames + new columns stand out from harmless edits.
Steps
- Open Database → Sync.
Empty until the project has a recorded spreadsheet source. Scaffold from a workbook to populate it.
- Click 'Check for drift'.
Avery compares the workbook's current state against the schema + last-synced row hashes. The diff viewer renders any deltas.
- Choose Push or Pull.
Push writes app changes back to the workbook (round-trip). Pull applies workbook edits to your data per the configured policy.
Live recipes need the desktop
This article is a static preview. The in-app Help sidecar inside Avery NXR can fire each step against your live project — install the desktop to use it interactively.