Smart Upsert Mode & Preserving Safe Columns

The biggest drawback of standard Google Sheets synchronization tools is row shifting. When rows are sorted, inserted, or removed in the source spreadsheet, any manual comments or approval checkboxes written to the right in the destination sheet remain stuck in place—corrupting your records.

---

How Smart Upsert Works

Smart Upsert matches incoming rows against existing destination rows using your chosen Primary Key Column (such as Order_ID, Email, or SKU):

1. Existing Record Modified: If a row with a matching Key ID already exists in the destination, only the synced columns are updated. Adjacent columns (your “Safe Columns”) remain untouched.
2. New Record Added: If a new Key ID is found in the source, it is appended as a fresh row, leaving empty cells for your team to fill in notes.
3. Record Re-ordered: If the source table is sorted alphabetically or by date, Smart Upsert updates each record by its ID, ensuring adjacent notes stay locked to the right entity.

---

Safe Columns Definition

Columns located to the right of the synced data range are automatically designated as Safe Columns. Smart Sheet Sync will never overwrite, blank out, or displace user formulas and notes written in these columns.