In this guide, we'll import data from Google Search Console into Airtable. We'll first set up our Airtable base and connect to Google Search Console using the Data Fetcher app. We'll then import impressions, clicks & positions for the last 7 days. Finally, we'll schedule this to happen automatically every week, so we can track these metrics over time.
Install Data Fetcher
Set Up Base
We're going to import clicks, impressions, CTR and positions data from Google Search Console. Each record will represent one page/ query (keyword) combination. Each week we'll import data for the previous week into a table called 'Weekly metrics', appending it to what's already in the table. This will allow us to see the performance of pages/queries over time.
Create a table called 'Pages'. This table will keep track of all our site's pages, organized by URL and linked to from our other tables. There's no need to manually add your pages, as Data Fetcher will do this automatically.
In the 'Pages' table, change the primary field name to 'URL' and the type to 'URL' as well.
Create a table called 'Days'.
In the 'Days' table create a field called 'End date' with type 'Formula'. When we make API requests to Google Search Console, we'll reference this field as the end date. Enter the following formula:
Import Google Search Console Data to Airtable
Based on the Google Search Console API documentation, we will use the
searchAnalytics endpoint to fetch analytics data for our site.
query in the
dimensions field means we'll create one Airtable record per page/ query combination. You can see a list of possible dimensions and make adjustments to the request in the API documentation.
"endDate": "***Days*End date*rec4Gsjj3NXCyJTmT***",
"startDate": "***Days*Start date*rec4Gsjj3NXCyJTmT***",
Connect To Google Search Console
Scroll down to 'OAuth Connection'.
Click the 'Add' button on the right-hand side.
Select 'Google Search Console' on the modal.
In Data Fetcher, click 'Run'. You'll see a loading message while the request runs, then the response field mapping modal will open.
Map the following response fields:
'rows.keys.1'. This field contains page URLs. So change the 'Data type' to 'Link'. Select the table field 'Page'.
'rows.keys.2'. This field contains queries/ keywords. Enter 'Query' in the input next to 'Or, create field:'.
'rows.clicks'. Enter 'Clicks' in the input next to 'Or, create field:'.
'rows.impressions'. Enter 'Impressions' in the input next to 'Or, create field:'.
'rows.ctr'. Change the 'Data type' to 'Percentage' and enter 'CTR' in the input next to 'Or, create field:'.
'rows.position'. Enter 'Position' in the input next to 'Or, create field:'.
'responseAggregationType'. Click the toggle so this field is not kept.
Click 'Confirm'. The necessary fields will be created, then the request will run again and update our base.
Schedule Request to Run Weekly
Let's schedule this request to run every week, so we can track these Google Search Console metrics over time.
In Data Fetcher, scroll to 'Schedule'.
You will need a paid Data Fetcher account to use this feature, so click the link to upgrade your account if you haven't already. After upgrading, click the 'I've done this' button.
Add your Airtable API key if you haven't already.
Turn on 'Schedule this API request'.
Select 'Every week' in the dropdown.
Choose which day you want it to run on. You should only pick one day otherwise there will be overlaps in the weekly data.