Guide
Spreadsheet Append-Only Incremental Sync Guide
A guide for syncing append-only Google Form responses and operational sheets as values with Google Apps Script.
Keep source rows in place and sync changes to the destination one way.
When the destination is blank, continuous source columns are detected from the header row.
Deletes and out-of-scope structural changes are not propagated to the destination.
What this generator is for
This generator creates an Apps Script that copies values from a source spreadsheet to a destination spreadsheet.
It is designed for append-only workflows such as Google Form responses or sheets where new rows are added at the end.
The sync is one way. Edits made in the destination sheet are not reflected back to the source sheet.
Source, destination, and sync processing settings
Source spreadsheet URL or ID
Enter the Google Sheets file to use as the source. You can paste the full URL or only the file ID.
Source sheet name
The sheet that contains the data to process.
Destination spreadsheet URL or ID
Enter the destination Google Sheets file. This script syncs one way from source to destination.
Destination sheet name
The sheet where synced values will be written. A blank or newly created sheet can start without column mapping.
Destination state
Use automatic header-based sync for blank destinations. Use column mapping only for existing sheets.
Header rows
The number of header rows at the top of the source sheet. Usually this is 1.
Destination start row
The row number where destination data starts. Use 2 when row 1 is the header.
Maximum sync rows (0 = unlimited)
Maximum rows to process during initial sync. Use 0 for no limit.
Initial sync batch rows
Rows read and written at once during initial sync.
Incremental sync batch size
Number of queued changes processed at once during incremental sync.
Retry check interval
How often to retry queued changes or temporary errors.
Column mapping
Use this only when syncing into an existing destination sheet.
Eligible sheet conditions
Append-only rows
Best for Google Form responses or operational sheets where new rows are added at the end.
Fixed row positions
Sorting, moving rows, inserting rows in the middle, and physical deletion are outside the safe operating model.
One-way sync
Values are copied from the source to the destination. Edits in the destination are not sent back.
Setup steps
Open Apps Script
Open Apps Script from the source spreadsheet.
Create KOKOCAL_Menu.gs and KOKOCAL_IncrementalSync.gs
Create KOKOCAL_Menu.gs and KOKOCAL_IncrementalSync.gs in Apps Script, then paste the generated content into each file. Back up existing code before editing it.
Run initial setup
Select KOKOCAL_IncrementalSync_setup from the function dropdown and run it manually. Management sheets and triggers are created in the source file.
Reload the spreadsheet
After KOKOCAL_IncrementalSync_setup finishes, reload the source spreadsheet so the KOKOCAL menu appears.
Run initial sync
Run the initial sync from the menu. If the destination is blank, headers and values are created automatically.
Save the implementation guide
After generating the script, use Download setup guide at the top right of the generated result column to save the information needed for setup. Generated results disappear when you leave the page, so saving the guide before setup is recommended.
Post-setup review points
Source sheet is not modified
Confirm that source sheet columns and cell values do not change before and after setup.
Form response rows
Confirm that new form response rows are queued and added to the destination.
Manual row updates
Confirm that manual edits become UPDATE queue entries and only target columns are synced.
Row count decrease
Confirm that the script stops safely if the source row count decreases.
Full rebuild
Confirm that the destination and sync index can be rebuilt from the source data.
Sensitive logs
Confirm that business values such as company names, addresses, and phone numbers are not stored in logs or errors.
Notes
Review before use
Review this point before using the generated script in production.
Important note
Review this point before using the generated script in production.
Important note
Review this point before using the generated script in production.
Review before use
Review this point before using the generated script in production.
Review before use
Review this point before using the generated script in production.
Ready to generate the script
One-way value sync from a source sheet to a destination sheet for append-only, fixed-row-position workflows.
Guide
Related guides
Review these guides together with this page to make setup and operation smoother.
Getting started
Review the input column, generated result column, code, setup steps, review points, and JSON menu.
Apps Script basics
Review .gs files, HTML files, saving, first authorization, triggers, and other basics before setup.
Using multiple scripts
Learn how to organize KOKOCAL_Menu.gs, feature files, the shared menu, triggers, and permissions when combining generated scripts.