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

Procedure

1. In the Awesome Table add-on, select the Google Search Console connector.
   
   
   
2. On the Connect to Google Search Console screen, click Sign in with Google.
   
   
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 Search Console Connector.

The Data drop-down shows the data you can import from the Google Search Console into Google Sheets.