With Awesome Table, you can import data from the Google Search Console.

Prerequisites

First, you must log in to the Google Search Console.

Import List site maps data

Procedure

1. From the Data drop-down menu, select List site maps.
   
   
   
2. Open the Site field and select the site from where you want to import data.
   
   
3. Click Run query.
   
   

Result

The Site Map has been successfully imported into Google Sheets.

Import Query search analytics data

Procedure

1. From the Data drop-down menu, select Query search analytics.
   
   
   
2. Open the Site field and select the site from where you want to import data.
   
   
3. Select the Date range.
   
   
4. (Optional) Add Filters.
   1. Select one or more filters in the Choose Filter dropdown.
      
      New field(s) appear(s) depending on what you selected.
      
   2. Complete the fields.
      
5. (Optional) Add Parameters.
   1. Select a parameter in the Choose parameter dropdown.
      
      New field(s) appear(s) depending on what you selected.
      
   2. Complete the fields.
      
      
6. Click Run Query.
   
   

Result

The Search analytics data has been imported successfully into Google Sheets.