Skip to main content

Permissions required by SyncWith Google Sheets

You'll need to grant SyncWith permissions to your Google spreadsheets when installing our Google Sheets addon

Updated this week

Scopes required

Scope

Explanation

https://www.googleapis.com/auth/userinfo.email

https://www.googleapis.com/auth/userinfo.profile

Required to access your google account and email

https://www.googleapis.com/auth/script.container.ui

Required for Google Sheets addons to display UI

https://www.googleapis.com/auth/script.external_request

Required to connect to SyncWith's backend service

https://www.googleapis.com/auth/script.scriptapp

Required to run scripts on your sheets

https://www.googleapis.com/auth/spreadsheets

Required to read and write from the spreadsheets on which you've installed SyncWith's Google Sheets addon

Questions

In general we strive to request as few permissions as possible. In this case, its an unfortunate result of how Google has setup its permissions and API methods

Some users have asked us why do we require the permission to access all of your Google Sheets spreadsheets, as it seems like its asking for more than necessary. We require this permission in order insert reports into your spreadsheets using the Google Spreadsheets API methods BatchUpdate. This method requires the scope https://www.googleapis.com/auth/spreadsheets which is unfortunately rather broad.

However, practically speaking SyncWith cannot access any of your spreadsheets except for the one(s) you install our addon in, because SyncWith cannot list your spreadsheets or find them.

Screenshots

Here is a screenshot from our addon in the Google Workspace Marketplace showing the permissions required.

Did this answer your question?