There will be instances when you won't be able to access your Awesome Table view or can't log in using your Google account. We'll explain the various reasons why these things happen and provide the appropriate solution.
1 - Use the prescribed Google Sheets sharing settings
The display of an Awesome Table view depends on the read access permission to the spreadsheet used as source.
To change the sharing settings of your spreadsheet, simply click the "SHARE" button in your spreadsheet:
Option 1: Simple share
You have several options to share your spreadsheet.
- Add people by their names or their email addresses
- Choose the sharing mode (edit, comment, view)
- Get a shareable link
Option 2: Advanced share
Or you can choose another way to share with the advanced settings.
This allows you to access the information to find out who has access to the view and change the sharing access.
You have several possibilities to share your spreadsheet (1) and select a sharing mode (2).
|On - Public on the web||
This option will make your view publicly accessible to everyone.
This is not recommended because there's a chance that your Google Sheets datasource will be indexed by Google Search.
|On - Anyone with the link||
This is the ideal and recommended option since it makes your view accessible only those who have access to your link can see your view.
This also won't require your viewers (intended audience) to sign in to Google to access your view.
|On - G Suite Domain||
This option will require authentication. We advise informing your IT personnel to install the Awesome Table app via the G Suite Marketplace. So it won't constantly ask everyone within your domain to log in using their G Suite credentials.
This is not recommended because there's a chance that your Google Sheets datasource will be indexed by Google Search of the Google Drive.
|On - Anyone at G Suite Domain||
This option will require authentication. We advise informing your IT personnel to install the Awesome Table app via the G Suite Marketplace.
So it won't constantly ask everyone within your domain to log in using their G Suite credentials. This is the recommended method.
No access to the view
To remedy this, the listed people should have at least a Can view access rights to see your view.
You can consult this article to have more informations.
2 - Verify that you're using the correct Google account
You need to make sure that you're logged in using the correct Google account for your Awesome Table.
If you have more than 1 account open, it's likely that your Awesome Table profile is referencing the wrong account. To remedy this, check the logged in Google account is the correct profile you're using for Awesome Table.
3 - Reset Awesome Table settings
If changing your Google Sheets sharing settings and making sure that you're using the correct Google account did not resolve accessing your Awesome Table view, our last resort is to reset or revoke Awesome Table's permissions to your Google account.
Then, click Manage third-party access.
Select Awesome Table then press the REMOVE ACCESS button.
4 - Enable Third-party cookies for Awesome Table
If you block the third-party cookies, it is not possible to log in with your Google account. In some cases, you may have an error message like this one:
It's necessary to enable third-party cookies for Awesome Table work. There are two ways to do this:
- You can reactivate the third cookies in your Google Chrome settings for all the websites you visit.
2. Or just enable third-party cookies with the url of the page for the website https://awesome-table.com/.