Setup
SheetSync has no formulas to write. You link a range from inside the sheet itself, in a few clicks.
Select a range
Select the range you want to keep in sync, then open Manage Links → Add link. This selection becomes the "own side" of the link.
Pick the target spreadsheet
Use Browse… to pick the target spreadsheet with Google's own file picker. SheetSync then auto-detects that spreadsheet's sheet names, so the target sheet is chosen from a list instead of typed by hand.
Confirm — same shape required
The target range must have the same number of rows and columns as your selection, and a single link can cover at most 50,000 cells (rows × columns). Confirm, and the link is live immediately — both sides start syncing according to the spreadsheet's current sync mode.
⚠ Both spreadsheets need SheetSync installed, with edit access on both under the same Google account — otherwise syncing to (or from) that spreadsheet fails.
Linking
A few rules decide what you can and can't link, to keep sync predictable on a shared sheet.
One range, several targets
The exact same range can be linked to more than one target at once — a "hub" setup where one master range feeds several others. Editing it syncs to all of them; each link still runs independently.
What counts as a link
One connection between a source range and a target range counts as one link, even though sync itself is bidirectional (edits flow both ways, but it is still one link, not two). A link counts against the account that created it, totalled across all of that account's spreadsheets — not per spreadsheet.
For example, with a plan that includes 1 link: once you link a range in sheet X to a range in sheet Y, you've used your link, and you can't add another between two different sheets. With a plan that includes 5 links, you get 5 in total, spread across your spreadsheets however you like. Sharing a spreadsheet with a colleague doesn't use up your links; links they create count against their own account.
Sync modes
Sync mode is a per-spreadsheet setting, chosen from the Sync Mode sidebar — it applies to every link on that spreadsheet.
Auto
mode: real-timeEvery edit syncs immediately to the other side of the link. The default, and the closest thing to "just works."
Manual
mode: on-demandNothing syncs automatically. Use the Sync now menu item (or the sidebar button) whenever you want to push your current values out.
💡 The menu shows when you last synced — “Sync now (last: 2 h ago)” — and the sidebar shows the same, so a forgotten sync is easy to spot. Prefer not to remember? Auto and Scheduled (paid plans) do it for you.
Scheduled
mode: intervalSyncs automatically on a fixed interval — hourly up to once a day — instead of on every edit. Useful for a reporting sheet that doesn't need to move in real time.
🔄 Scheduled keeps running when the spreadsheet is closed; Auto reacts to edits, so someone has to be working in it.
💡 "Sync now" still works regardless of the current mode — in Auto or Scheduled it's just a harmless extra push.
Protections
Two guardrails stop a link setup from silently doing the wrong thing.
Overlap protection
A new link is rejected if either side's range partially overlaps an existing link's range on the same spreadsheet. Without this, two spreadsheets that were never directly linked could silently affect each other through a shared cell.
Linking the exact same range to a different target is still allowed — that's the intentional hub/fan-out case.
Orphaned-link warning
If a target spreadsheet becomes unreachable (deleted, or access revoked), the link is flagged with a warning in Saved Links instead of failing silently forever — sync to it stops until you fix access or remove the link.
Good to know
A few behaviours that aren't a setting in the dialog, but decide whether SheetSync does what you expect.
Sync is genuinely bidirectional
There's no "source" and "copy" side — edit either range and the other updates. That also means a link can propagate an edit back and forth between more than two spreadsheets in a hub setup, which is why overlap protection exists.
Every spreadsheet in a link needs its own install
SheetSync must be installed on every spreadsheet in the link, both source and target, with edit access on both under the same Google account. A spreadsheet without the add-on installed can't be synced to or from. To write the synced values, SheetSync adds its own service account as an Editor of the two linked spreadsheets (visible in the Share dialog) and removes it again when the last link is deleted.
What the free plan covers
New accounts get a 14-day trial with full access — up to 20 links, all sync modes. After that you drop to the free plan: 1 link, manual sync only, no time limit. A paid plan lifts both limits.
💡 If a paid plan lapses, links over your new limit are paused, not deleted — upgrading resumes them exactly as they were.