Import Google Search Console data to Airtable [step by step guide]

Mariam Ispiryan • May 19, 2022 • 9 min read

Google Search Console is one of the most powerful SEO tools out there. The platform provides information on how Google Search Engines interact with your website. Let’s be honest, there’s a lot of data to scan through and collect, which can be time-consuming and daunting. That’s why you’ll need an automated solution like Airtable to store and manage your data all in one easy process without losing a single nerve cell while on it.

If you’re unfamiliar with Airtable, check out our article about Airtable. Now, let’s proceed to the step-by-step guide…

Softr is the easiest, fastest way to build a professional web app on Airtable

No designer or developer needed. Zero learning curve.

Import Google Search Console Data to Airtable with Data Fetcher

Data Fetcher is one of the best Airtable apps perfect for syncing Airtable with platforms like Google Search Console.

Here is all you need to do to pull in the Console data to Airtable.

Step 1: Install the Data Fetcher app from the Airtable app section and sign up.

Step 2: Data Fetcher’s home screen will appear where you should click “Create your first request” to proceed with the syncing process.

Create your first request on Data Fetcher

Step 3: From the opened request screen, select “Google Search Console” from the Marketing section

Select Google Search Console

Step 4: Click “New Google Search Console connection” to connect your Search Console account with Data Fetcher.

Create New Google Search Console connection

Step 5: You will be directed to a new tab where you should sign in to your account and enable the “View Search Console data for your verified sites” checkbox for Data Fetcher to be able to access your data.

Step 6: You will be back to Data Fetcher’s home screen where you should click “Save & Continue” to proceed with the connecting process.

Proceed with Save & Continue" button

A request window will open where you should fill in all the required information for successful importing.

Sync Airtable with Google Search Console

Step 1: Select a Site and Date range to pull in data for the given period of time.

We went for the data range of the last month to be imported from Softr’s website.

Select a date range

Step 2: Select a Split by for Data Fetcher to split data into different records.

We selected “Country” to get a different record for each country.

Select a split by

Step 3: Select an Output table and view to have your Console Data imported. 

Select an output table

Step 4: When you’re all set up, click “Save & Run” to move to the next stage.

Create your first request on Data Fetcher

A response field mapping window will pop up, where you can select how imported Console fields should be mapped to Airtable fields. The Console fields can be imported or filtered when entering the output view. The imported fields can be set to be mapped to an existing field or a new one.

When you’re happy with the data, you can click “Save & Run” to proceed.

Response mapping field

Import Google Search Console Data to Airtable Automatically

These were all the steps required for syncing Google Search Console with Airtable manually and for free. The only downfall of Data Fetcher is it only imports data manually.

If you want to import Console data to Airtable automatically, there is also a premium Data Fetcher scheduled requests feature that allows syncing Google Search Console and Airtable automatically for your selected interval.

Step 1: On Data Fetcher’s home screen, scroll to Schedule and click 'Upgrade'.

Schedule the import, click upgrade

Step 2: A new tab will open where you can select a plan, and add payment details to proceed.

Step 3: When you’re done with the payment, go back to Data Fetcher and click "I've done this".

"I've done this" button

Step 4: Click 'Add API key'. You can find your API key in your Airtable account.

Adding Airtable API key

Source: Data Fetcher

Step 5: Enter your Airtable API key and hit 'Save'.

Step 6: Toggle on Schedule this request.

Schedule the request

Source: Data Fetcher

Step 7: Select how often you want the request to run and click 'Save'. This way, the request will run automatically according to your set time.

Softr is the easiest, fastest way to build a professional web app on Airtable

No designer or developer needed. Zero learning curve.

Importing a Console Data using the CSV Import app

Slightly difficult compared to the first method, importing Console data to Airtable will be available by exporting and importing as a CSV file with the CSV import app.

You can export data from the Performance view and Indexing view from your Google Console account.

There are a few steps required to export Console data as a CSV:

Step 1: Log in to your Search Console account.

Step 2: Go to your Performance view.

Google Search Console's Performance section

Step 3: Select a date range you want to export data for.

Step 4: Click on the “Export” button at the top right corner.

Export button

Step 5: Select CSV format to export your data. 

Download CSV

For the next part, you will need to work with the CSV import app

Steps to import data with CSV import app

Step 1: Open the table where you want to import your records and follow the instructions:

Step 2: Install the CSV import app by clicking the "Apps" button at the top right corner of your view, and then click the "Install an app" button.

Step 4: Search for and install the CSV import app.

Step 4: Drag and drop the exported CSV file into the app.

Step 5: Configure settings and field mappings before importing the CSV file into your base.

The next steps are optional but highly advised if you want to import your data without complications.

Additional steps to import data with CSV Import

Step 1: If you have existing records, enable the “Merge with existing records”.

Merge with exsiting records

Step 2: Toggle on “Skip blank or invalid CSV values", if there are blank fields in the CSV.

Skip blang or invalid CSV values

Step 3: Toggle on “Create missing select options” to create a new option if there are single/multiple select fields in your table.

missing select option CSV import app

Source: Airtable

Step 4: Set field mappings if the records of your CSV and names of the fields don’t have matching names, making it impossible for Airtable to match them automatically.

To successfully set field mappings, select the field toggle, choose a column from the drop-down menu, and map the value.

map a value CSV import app

Source: Airtable

CSV import app is available for premium users and has a 25,000-row limit, which allows you to add and edit the imported records and merge data with existing records.

Importing Console Data as a CSV

If importing your records with CSV import apps seems way too complex and daunting to you, we have another solution. If you’re looking for a less customized option, importing your Console Data as a CVS file will also work when importing Console Data to Airtable.

Here is how you can import CSV data from a CSV file.

Step 1: Export Console Data as CVS file, the way we’ve covered above

Step 2: Open the table and view where you want to import your file.

Step 3: Click on “Add or Import” next to the list of tables.

Step 4: Click the “CSV file” button.

Step 5: Select the CSV file of exported Console Data. (Note, the file size limit on CSV uploads is 5MB)

The imported adjustment dialog will pop up, where you can preview your CSV file, imply changes and adjust field mappings.

After you’re done with adjusting and changing the file, click “Import” button and you have your Console Data successfully imported to your base.

Softr is the easiest, fastest way to build a professional web app on Airtable

No designer or developer needed. Zero learning curve.

Import Google Search Console Data to Airtable with AirFlow

If less customizable data importing is not an issue for you, we have another Airtable built-in app, Airflow, which is 2x times easier than Data Fetcher but is less customizable.

Airflow allows connecting, importing, scheduling, and syncing data from any source with an API key.

To sync Console Data with Airtable follow the steps accordingly

Step 1: Download Airflow from the Airtable app marketplace.

Step 2: On the Airflow’s home screen click “Connect” to proceed. 

Connect a google account

Step 3: Fill in your Airtable API key. You can find your API from your Account Overview.

Add Airtable API

Step 4: Choose a connection to sync Airtable with.

In the opened window, find and click on “Google Search Console”.

Select Google Search Console

Step 5: Connect your Google account with Airflow.

Make sure to enable “View Search Console data for your verified sites” for Airflow to access Console data.

View Search Console data for your verified sites

It's important to learn about Airflow's recipes before we move to the next stage of the connecting process.

We recommend enabling the “Save recipe” checkbox from the field selection window for Airflow to save the connection if you want to get Console data again.

Recipes will allow the connection to be saved for future use or automatic updates. You can even share saved recipes with your team members, create a refresh schedule for hourly/daily/weekly/monthly or even real-time updates, and much more. (more on Recipes later)

Now let’s go back to the main part of the syncing process. Make sure to follow the instructions carefully.

Steps to import data with Airflow

Step 1: Select a property (website) you want to import Console Data from.

Select a property

Step 2: Select fields you want Airflow to pull in.

Fields are equal to Console metrics. You can learn more about Console metrics here.

We went for Site URL, Page and Position.

Select fields

Step 3: Select a Date Range for Airflow to import data for the selected time range.

We selected Console data for the last month.

Select a date range

Step 4: Sort the Console data for the Airflow to add the data to the output view in your preferred way. 

Sort Console data

Step 5: Select how the new records will be added to the output view.

There are three options:

  • Appending will add data below existing rows
  • Merging will edit the existing rows and append new data below
  • Overwriting will clear all existing rows before adding data

We chose overwriting since we have existing rows we don’t need.

Select how the new records will be added to the output view.

After you’re happy with the settings, click “Check” to move to the next stage.

Check button

Step 6: Map the columns from your data source to the table's columns.

Mapping fields

Step 7: Click “Get Data”. 

Get data
Get data successfully

Now you have your report successfully generated!

Creating a Recipe and a Schedule

Going back to Airflow recipes, let’s see how you can create and schedule a recipe for more automated syncing.

If you didn’t enable the Save Recipe checkbox in field selection:

Step 1: Go back to field selection;

Step 2: Enable the checkbox;

Step 3: Enter a name;

Step 4: Proceed with the process presented above.

Save recipe
Console data x Airtable report

You can find all your recipes in the Recipes section.

To schedule a recipe

Step 1: Click on the “Schedule” button.

Step 2: Click “Add a new schedule”.

Add a new schedule

Step 3: On the opened dialog select a Date Range, and a Report, and click “Ok”.

Select a date range and a report

Now the report will run daily, importing Console data to Airtable.

You can always toggle off the Schedule button if you want to stop the running process.

turn the Schedule on
Imported Google Search Console data

Now the report will run daily, importing Console data to Airtable.

You can always toggle off the Schedule button if you want to stop the running process.

Final Thoughts

The most efficient approaches to sync Airtable and Google Search Console to import data are demonstrated in this guide. It may appear hard and time-consuming at first, but trust us when we say it won't take much work or time if you follow the procedures exactly. Best of luck!

About Softr

Softr is an easy-to-use no-code platform that turns Airtable bases into powerful web apps, member-only websites, and client portals. Softr offers a way for you to authenticate your end-users, control access to your content and data based on conditional rules like roles, logged-in status, subscription plans, etc. If you're using Airtable as a product catalog you can use a Softr template to build your e-commerce website. Or maybe you'd like to build a custom website for your travel journal, there's a template for that too!

Client Portal | Internal Tools | Web App Builder | Free Website Builder Made with Softr