Install Awesome Table Connectors
Install the Awesome Table add-on from the Google Workspace Marketplace in Google Sheets and easily export data from Google Drive, Google Photos, Stripe, HubSpot, Salesforce, Zendesk, and others.
Open a spreadsheet or create a new one.
Select Extensions > Add-ons > Get add-ons.
A pop-up window opens.
Type Awesome Table in the search bar and click on the search button. Select the Awesome Table add-on.
Click Install.
Click Continue in the confirmation box.
A Sign in with Google window opens.
Select for which Google account you want to install Awesome Table.
Click Allow to grant Awesome Table the required permissions.
A pop-up window indicates that Awesome Table has been installed. Awesome Table launches in the Google spreadsheet from which you installed the add-on.