Replace (Overwrite) & Append (Log) Modes

In addition to Smart Upsert, Smart Sheet Sync supports two traditional synchronization modes designed for specific workflows.

---

1. Replace (Overwrite) Mode

• How It Works: Clears the destination range from row 2 downward and writes the latest source data snapshot in full.
• When to Use:
  • Clean reporting dashboards where you only want the current state of source systems.
  • Workbooks where no manual note columns are maintained adjacent to synced data.
  • Tables that frequently delete expired records that should disappear from the destination.

---

2. Append (Historical Log) Mode

• How It Works: Identifies new rows in the source and appends them at the very bottom of the destination table, never modifying or clearing existing rows.
• When to Use:
  • Creating audit trails or historical transaction ledgers.
  • Daily or hourly snapshot backups.
  • Ingesting time-series events and POS logs from CSV files.