Frequently Asked Questions
Does Awesome Table Connectors have a free trial?
How can I subscribe to a plan?
To subscribe to a plan, follow these steps:
Open the billing page.
In the Connectors section, click Upgrade.
Select options for the following, then click Continue:
- Whether you want a monthly or yearly payment
- The currency
- The plan you want to purchase
Check the information provided in the Summary screen, then click Proceed to checkout.
Automatic renewal is set up on your account. The subscription is renewed either monthly or yearly.
Enter your payment information, then click Subscribe.
A message opens to confirm that your subscription is activated.
On the billing page, you can see the summary of the plan you purchased and the main features it includes.
How can I cancel my subscription?
To cancel your subscription, follow these steps:
Open the billing page.
In the Connectors section, click Manage.
Click Cancel Connectors plan.
A message informs you that your account will downgrade to a Free trial at your next billing date.
Click Yes, continue.
The Summary page is displayed.
Confirm the downgrade to a Free trial.
Your plan is scheduled for downgrade to a Free trial. You can restore your paid plan at any time before the scheduled downgrade date.
I've installed the add-on. How do I launch it?
You can launch Awesome Table Connectors easily by following these steps:
- Open a spreadsheet or create a new one.
- Select Extensions > Awesome Table > Launch.
The Welcome to Awesome Table sidebar opens. - Click Sign in with Google.
- Select the Google account you want to use with Awesome Table.
- Click Continue to grant Awesome Table the required permissions.
The page closes automatically after a few seconds.
The Awesome Table add-on is now available in Google Sheets.
What permissions are required by the Awesome Table add-on?
Authorization Scopes | Explanation of Awesome Table scope usage |
See, edit, create, and delete only the specific Google Drive files you use with this app | Required by Awesome Table Connectors to allow you to pick a file with the Google picker in Google Drive and Sheets connector. |
View and manage spreadsheets that this application has been installed in | Allows Awesome Table Connectors to clear the sheet before running a request. |
See all your Google Sheets spreadsheets | Allows Awesome Table Connectors to read information from other spreadsheets (spreadsheet name / sheet name) in the add-on when listing requests from other sheets. |
See, edit, create, and delete all your Google Sheets spreadsheets | Required by Awesome Table Apps to allow the Google Visualization API to fetch the spreadsheet data with the viewer access right, and display the Awesome Table app. It also allows Awesome Table Connectors to write source data on the configured spreadsheet during a request. |
Connect to an external service | Required to allow Awesome Table Connectors add-on to send/retrieve information from its backend. Even if this authorization is described as an 'external service', it still stays within Google environment. |
Display and run third-party web content in prompts and sidebars inside Google applications | Required to display Awesome Table Connectors sidebars inside Google applications. |
For more details, see Google permissions for Awesome Table.
What data is stored by Awesome Table?
Type of data | We store | We don't store |
---|---|---|
Personal information |
|
|
Google Sheets data |
|
|
Microsoft data |
|
|
Connector data |
|
|
For more details, see Data stored by Awesome Table.
Why do I need to sign in with Google multiple times?
Can I use GPT with Awesome Table Connectors?
For example, you can use Awesome Table Connectors and GPT for Sheets to help you with simple or complex tasks, like removing emojis from YouTube comments:
- Use Awesome Table Connectors to export YouTube comments from any channel.
- Install and enable GPT for Sheets.
- On your output sheet, insert a new column next to the textOriginal column. This is where we will insert the GPT formula.
- On the top cell of the column you've inserted, in this case, cell M1, enter "Remove emojis and retain original text." This will be our prompt.
- Enter
=GPT(M$1,L2)
in the cell below, in this case, cell M2, then press Enter. - The text from cell L2 is displayed, now without emojis.
- Drag the blue box at the bottom of cell M2 and drag it down to cell M109 to apply the prompt to cells L3 to L109 (the last row in the spreadsheet).
You have now removed emojis from a list of YouTube comments!
The connector I need to use isn't available. What can I do?
We are always listening to your feedback and continually adding new connectors. You can either:
- If you have the technical know-how, use the robust REST API connector if there's an available API for your needs.
- Use the Awesome Table Connector Request Form to request for new connectors!