No questions match “”.
What does SheetSync do? ▼
It keeps a range in one spreadsheet automatically in sync — in both directions — with a range on another spreadsheet. Edit either side, the other updates. Use Manage Links to link a range and Sync Mode to choose how that sync happens.
How do I link two spreadsheets? ▼
Select the range you want to link, open Manage Links → Add link, and use Browse… to pick the target spreadsheet. The target range must have the same number of rows and columns as your selection. A single link can cover at most 50,000 cells (rows × columns).
The file picker says “Can’t access your Google Account”. What do I do? ▼
The picker runs in a Google-hosted frame and needs to read your Google session. It fails when your browser blocks third-party cookies for Google, or when you’re signed in to several Google accounts and a different one is the default. Allow third-party cookies for google.com and googleusercontent.com, or open the sheet in a window where only the account you use with SheetSync is signed in. As a fallback you can paste the ID of a spreadsheet you have already used SheetSync in.
Does the add-on need to be installed on both spreadsheets? ▼
Yes — SheetSync must be installed on every spreadsheet in the link, both source and target. You also need edit access on both, using the same Google account. Without that, syncing to (or from) that spreadsheet will fail.
SheetSync checks this when you create a link and on every sync: view-only or comment-only access is not enough. Choose the target with Browse… — that is what lets SheetSync verify your access to it. A pasted ID only works for a spreadsheet you have already used SheetSync in or picked before.
Sharing with SheetSync. To write the synced values, SheetSync’s backend needs to be an Editor of both spreadsheets. When you create a link, the add-on adds SheetSync’s service account to those two spreadsheets for you (you’ll see it in the Share dialog; no e-mail is sent). You only need permission to share the file — if sharing is restricted, ask the owner to allow editors to share, or to add the address shown in the error message as an Editor. Removing that Editor stops the sync for that spreadsheet. When the last link to a spreadsheet is deleted, SheetSync removes itself again.
Using Google Workspace with restricted sharing? Your administrator may need to allow sharing with the SheetSync address (domain gsspro.iam.gserviceaccount.com) — see the Workspace administrator note.
Can one range sync to more than one other spreadsheet? ▼
Yes — the exact same range can be linked to several different targets at once (a “hub” setup). Editing it syncs to all of them. What you can't do is link two different, overlapping ranges to different targets — that's blocked to prevent two spreadsheets that were never directly linked from silently affecting each other through a shared cell.
What counts as one “link”? ▼
One connection between a source range and a target range, created once via Manage Links → Add link. Even though sync is bidirectional (edits flow both ways), that's still one link, not two. A link counts against the account that created it, added up across all of that account's spreadsheets — not per spreadsheet.
Example: with a plan that includes 1 link, linking a range in sheet X to a range in sheet Y uses it up, so you can't add another link 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.
What's the difference between Auto, Manual, and Scheduled? ▼
- Auto — every edit syncs immediately. The default.
- Manual — nothing syncs automatically. Use the Sync now menu item whenever you want to push your current values out.
- Scheduled — syncs automatically on a fixed interval (hourly up to once a day) instead of on every edit.
Sync mode applies to the whole spreadsheet, not to individual links.
Does “Sync now” only work in Manual mode? ▼
No — it works regardless of the current mode. In Auto or Scheduled mode it's just a harmless extra push; in Manual mode it's how you sync at all.
I use Manual mode. How do I avoid forgetting to sync? ▼
SheetSync can't tell when you close a spreadsheet, so it can't warn you at that moment. What it does is show when you last synced: the SheetSync menu reads Sync now (last: 2 h ago), and the Sync Mode sidebar shows Last synced. The menu label appears once you have opened the Sync Mode sidebar on that spreadsheet.
If you'd rather not think about it, switch to Auto or Scheduled. Both need a paid plan; the free plan is Manual only.
Does the spreadsheet have to be open for syncing to work? ▼
The spreadsheet you are linked to never has to be open — SheetSync writes to it from our servers. For the spreadsheet where the change happens, it depends on the mode:
- Auto — a sync runs when a cell is edited, so someone is working in it.
- Manual — you click Sync now.
- Scheduled — runs on its interval even when nobody has the spreadsheet open. It runs under the account of the person who chose Scheduled; if that person loses access to the spreadsheet, syncing stops.
A link shows a warning in Saved Links — what does that mean? ▼
The target spreadsheet couldn't be found or is no longer accessible (deleted, or sharing access revoked). Sync to that link fails silently until it's fixed — either restore access, or remove the link.
I've reached my link limit — what now? ▼
Your plan has a maximum number of links. Check the Account tab in Manage Links for your current usage and upgrade options.
The trial says “full access” — why is there a 20-link cap? ▼
“Full access” means every sync mode is unlocked during the trial — Manual, Auto and Scheduled — not literally unlimited links. Every sync runs on our servers, and a very high number of links with rapid automatic edits can cost a lot to run, so we keep a limit per account while we learn how SheetSync is used in practice. 20 is also the most the largest individual plan can buy, so the trial lets you try the maximum. We may raise this limit in a future update once we have seen real usage.
Need more than 20 links, or running this across a team? Look at a Team plan, or send us a message through the feedback form in Manage Links → Account.
My trial or plan ran out and I have more links than my new limit allows — what happens to them? ▼
Nothing gets deleted. Links over your new limit are paused, not removed — they stop syncing but stay visible in Saved links with an “Upgrade to resume” prompt. Your oldest link (by creation date) stays active; newer ones pause first. Upgrading reactivates paused links immediately, oldest first, exactly as they were.
How do I upgrade or buy more links? ▼
Open Manage Links → Account, pick a plan under Subscription, and complete checkout in the tab that opens. Payments are processed by Stripe; we never see your card details.
Changing the number of links on a monthly or yearly plan is prorated: the difference for the rest of the current billing period is added to your next invoice, and if you reduce the number of links you get a credit on that invoice instead. Lifetime is different — there is no billing period, so upgrading to a bigger tier costs the fixed price difference between the tiers, one time.
How does a Team plan work? ▼
One subscription covers everyone on your organization's Google Workspace domain — a personal @gmail.com account has no domain for teammates to join, so the team plan isn't available to it. Whoever purchases it picks the links-per-seat allowance; teammates on the same domain get a seat automatically the first time they open SheetSync. The purchaser can add or remove specific teammates from the Team seats panel on the Account tab — and tick "Email them the install link" to send a new teammate the link straight away.
Need more (or fewer) seats later? Change the count on the Account tab's Team subtab. It shows the prorated amount before you confirm; the difference lands on your next invoice, and the new rate applies from then on.
Is there a limit on how big a linked range can be? ▼
Yes: one link can cover at most 50,000 cells, counted as rows × columns (for example A1:E10000). If your range is larger, SheetSync asks you to split it into several smaller links, for example one per block of rows. Each of those links counts toward your plan like any other link. Links you created before the limit existed keep working.
I inserted or deleted rows or columns — why did my link stop? ▼
A link is tied to fixed cell addresses. After rows or columns are inserted or removed, those addresses may no longer match your data, and syncing on would write to the wrong cells. SheetSync therefore stops the links on that sheet and marks them Needs review in Saved links. If the ranges are still right, click the check mark to resume; otherwise use the pencil to change the range. Adding rows far below your range also triggers this — one click resumes it.
I'm on a Team plan — can I add links with my own subscription? ▼
Not on top of the team limit. An active individual subscription (monthly, yearly or lifetime) replaces your team limit for your own account; the two are never added together. If the team gives you 12 links and you buy 4, you have 4 — fewer than before. Buy individually only if you need more than the team provides, and then at least that many.
If you need more links for everyone, the team admin can raise the links per account on the Account tab's Team subtab. That applies to the whole team.
Your team seat is not removed when you buy individually. If your individual subscription ends or you cancel it, your account goes back to the team limit the next time you open SheetSync. If the team plan itself expires, you fall back to your own limit until the admin renews it — the Account tab tells you which situation applies.
Can I give up my Team seat myself? ▼
Yes — on the Account tab, click Give up my seat. No admin involvement needed. Getting a seat back afterwards does require the domain purchaser to re-add you from the Team seats panel — it's not automatic just by reopening SheetSync again.
Why does SheetSync cost more than a simple add-on? ▼
SheetSync syncs data live between multiple spreadsheets through a backend server (Firestore + Cloud Functions) — every sync costs server-side processing, unlike add-ons that do everything locally inside your sheet. That infrastructure is what makes automatic and scheduled sync possible, even while your sheet isn't open.