There will be instances when you won't be able to access your Awesome Table app 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 app 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 app and change the sharing access.
You have several possibilities to share your spreadsheet (1) and select a sharing mode (2).
| Sharing Mode | Description |
|---|---|
| On - Public on the web |
This option will make your app 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 app accessible only those who have access to your link can see your app. This also won't require your viewers (intended audience) to sign in to Google to access your app. |
| 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 app
To remedy this, the listed people should have at least a Can view access rights to see your app.
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. 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/.
4. 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 app, 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.
Comments
3 comments
Good
Hi,
I am facing an issue in creating a new 'summary'.
What had happened?
I had successfully created an advanced summary and everything was fine until I accidentally permanently deleted the source spreadsheet which was first created in the google form.
After deleting the sheet, I tried to open the advanced summary view URL but then it did not open and gave 3 options: Check if source sheet is deleted, the correct google account and app settings.
I realized that the first option is related to my current situation and did the following.
What I did...but in vain
For the same form, in the responses tab, I clicked on the more option and selected "Select response destination" and created a new excel sheet.
Now I tried to create a new summary and in the option it says "Open / Edit Summary".
I do not want this ...I want it to be "Create new summary".
Can someone please tell me how to solve this issue?
I cannot afford to collect the responses again as the respondents are no longer willing to fill the form.
(EDIT)
Nevermind...I got the solution.
I just went to the awesometable homepage and deleted the faulty spreadsheet(created earlier) app and retried in the forms again and it worked!
Hola, seguí todo y cada uno de los pasos y no consigo que se vea, los he revisado una y otra vez y nada.
Pregunto si la versión gratuita tiene limitación de visualizaciones quizás.
Gracias y espero vuestra respuesta
Please sign in to leave a comment.