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.
Form input fields
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.
Setup steps
Open Apps Script
Open Apps Script from the source spreadsheet.
Paste the script
Paste the generated Code.gs. Back up existing code before replacing it.
Run initial setup
Select setupSyncSystem from the function dropdown and run it manually. Management sheets and triggers are created in the source file.
Reload the spreadsheet
After setupSyncSystem finishes, reload the source spreadsheet so the KOKOCAL sync 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 generation, 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.
What the guide includes
The setup method, post-setup review points, generated script, settings JSON, and config hash are collected in one document. The setup method starts with a note that the generated script appears later in the guide.
Available formats
Choose Markdown (.md), Word (.docx), or the PDF save view.
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.