Spreadsheet Append-Only Incremental Sync

Google Sheets

One-way value sync from a source sheet to a destination sheet for append-only, fixed-row-position workflows.

This generator is for append-only source sheets with fixed row positions.

After sync starts, do not sort rows, move rows, insert rows in the middle, or physically delete rows in the source sheet.

The script does not add sync columns to the source sheet. Management information is stored in separate management sheets.

This script performs one-way sync from source to destination. Edits made in the destination are not reflected back to the source.

Source spreadsheet URL or ID

Source sheet name

Destination spreadsheet URL or ID

Destination sheet name

Destination state

Header rows

Destination start row

Maximum sync rows (0 = unlimited)

Initial sync batch rows

Incremental sync batch size

Retry check interval

Column mapping is not required when the destination sheet is blank. The script automatically syncs the continuous columns in the source header row until the first blank header.

Terms of UseI agree to use the generated script at my own responsibility after reviewing risks such as execution results, data loss, sync inconsistencies, and business interruption, and after creating a backup.

Generated Result

Not generated

Enter the required fields and generate the script.