1. What SheetSync adds to a spreadsheet
When a user creates a link, the add-on shares the two linked spreadsheets with SheetSync’s backend identity as an Editor:
sheetsync-runtime@gsspro.iam.gserviceaccount.com
- It shows up in the spreadsheet’s Share dialog like any other editor. No notification e-mail is sent (the identity has no inbox).
- It is added to only the spreadsheets in a link — never to a folder, a shared drive as a whole, or anything else in the user’s Drive.
- The backend uses it for one thing: writing the synced cell values into the linked range. It only handles the ranges users explicitly linked.
- The user must be allowed to share the spreadsheet (the owner, or an editor when editors may share). A viewer cannot create a link.
- When the last link that involves a spreadsheet is deleted, the add-on removes this editor again. If the permission is inherited (from a folder or shared drive) it cannot be removed per file and stays until you remove it there; it does nothing without a link.
2. Why a sharing setting may block it
To your organisation the identity above is an external account (its domain is gsspro.iam.gserviceaccount.com, not yours). If Drive sharing is restricted, adding it fails and the user sees a message that SheetSync could not be given edit access.
3. What to allow
In the Admin console, under Apps → Google Workspace → Drive and Docs → Sharing settings (names can differ slightly between editions):
- Sharing outside of your organisation: turn it on, or — if you only allow specific domains — add
gsspro.iam.gserviceaccount.comto the allowed domains. - If users get a warning when sharing outside the organisation, they can confirm it. You can also scope the setting to an organisational unit or group that uses SheetSync.
- Shared drives: in the drive’s settings, allow people outside the organisation to access files, or add the identity to the drive as a member.
- If you restrict Marketplace apps, make sure the SheetSync add-on is on your allow list.
4. Revoking access
- Per spreadsheet: remove the editor in the Share dialog. The link to that spreadsheet then stops syncing.
- Organisation-wide: block the domain
gsspro.iam.gserviceaccount.comin the sharing settings, or remove the add-on in your Marketplace settings.
5. What data is handled
Only the cell values of ranges that users linked, the spreadsheet IDs and the user’s e-mail. Nothing is shared with third parties. See the privacy policy for details, or contact us with questions.