We advise Google Workspace admins to install our Awesome Table app via the Google Apps Marketplace to avoid authorization pop-ups when people view Awesome Table apps.
This article describes the required steps to install the Marketplace app. Learn more about why we advise installing this app: A new authentication flow.
Install the Awesome Table app
Log in with a valid admin account for your Google Workspace domain and open the Awesome Table add-on from the marketplace.
Click the Domain Install button to install the app on your domain.
Click Continue.
Select the checkbox to agree to the Terms of Use and Privacy Policy and click Allow to accept the authorizations:
If required, you can change the Turn ON for: switch and select an organizational unit or domain.
You can choose to install the Awesome Table app for a given organizational unit (OU) or a whole domain. We advise installing for app on the whole domain to ensure the app is available to all people who may need access to an Awesome Table app. If you install on a given OU, people outside this OU will be prompted to authorize Awesome Table to view apps.
Authorization Scopes |
Explanation of Awesome Table scope usage |
---|---|
View your email address | These are generic scopes that are mandatory for any app published on the Google Apps Marketplace. We store this information in our database to create user profiles.* |
See your personal info, including any personal info you've made publicly available | |
See, edit, create, and delete your spreadsheets in Google Drive | This is the most important permission. We ask for this permission as per Google requirements as of September 14, 2016. You can see their public announcement here. |
Display and run third-party web content in prompts and sidebars inside Google applications | This scope is required to display sidebars inside Google applications. |
Connect to an external service |
Needed to call the Awesome Table API to create an Awesome Table app. This scope is required to send/retrieve information from Firebase, a real-time database from Google. Even if this authorization is described as an 'external service', it still stays within Google environment. |
View your Google Spreadsheets |
The add-on allows the user to copy an Awesome Table template spreadsheet to fill his spreadsheet. The scope is required to allow access to the template spreadsheet. |
View and manage spreadsheets that this application has been installed in |
Allows the add-on to add template data in the user spreadsheet. |
*Those scopes are only mandatory when you Install Awesome Table with an admin account for a domain.
Click Done.
The data from your spreadsheet is never stored in an external database. Learn more in the Confidentiality & Data security section of our Terms of Use.
You can choose to install the Awesome Table app for a given organizational unit (OU) or a whole domain. We advise installing for app on the whole domain to ensure the app is available to all people who may need access to an Awesome Table app. If you install on a given OU, people outside this OU will be prompted to authorize Awesome Table to view apps.
Monitor usage on the domain
Now that Awesome Table is using a standard authorization flow to access spreadsheet data, you can find the activity linked to Awesome Table in the Google Workspace admin panel, under Reports > Token.
This report lets you see every time a user on your domain has accessed spreadsheet data through Awesome Table. You can also export the data in a spreadsheet (via CSV) to get a better report.