To import data from Google Drive into Google Sheets, follow the steps below to log in to Google Drive with the Awesome Table add-on.

Procedure

1. In the Awesome Table add-on, select the Google Drive connector.
   
2. On the Connect to Google Drive screen, click Sign in to Google Drive.
   
3. Select your Google account.
   
4. Click Allow to grant Awesome Table the permissions it requires to import data from Google Drive.
   
   If your authorization is successful, Awesome Table shows the following screen.

Result

You are now logged in with the Google Drive Connector.

The Select data drop-down shows the data you can import from your Google Drive into Google Sheets.