Overview

SheetSync Guides

Walkthroughs for keeping ranges in sync across Google Sheets spreadsheets. Each one covers the formula and script routes as well as the add-on.

Each guide shows the no-add-on approaches first — a formula, an Apps Script trigger — then how SheetSync does the same thing from a dialog, with the limits stated.

Sync a range between two Google Sheets

Keep a range in one spreadsheet identical to a range in another: an IMPORTRANGE formula, an installable onEdit Apps Script, and SheetSync. Includes the limits of each.

Two-way sync between Google Sheets

Why IMPORTRANGE only goes one way, what two onEdit scripts can and cannot do, and how SheetSync keeps both sides identical without loops.

Copy one range to several Google Sheets

Maintain a master list once and have it appear in several other spreadsheets: IMPORTRANGE in each target, a script on the master, or one SheetSync link per target.

IMPORTRANGE alternatives for Google Sheets

Read-only cells, #REF! and no way back: what to use when the destination has to be editable, from an Apps Script copy to SheetSync.