Quick guide
Import data from Google Search Console to Google Sheets by following these steps:
- Get Amigo Data from Google Workspace Marketplace
- Connect to Google Search Console
- Select Google Search Console from the sources
- Select your domain and the metrics to import
- Preview and click IMPORT.
Google Search Console is a web service which allows you, the webmaster, to check indexing status, search queries, crawling errors and various other performance metrics that allow you to monitor organic traffic and optimise the visibility of your website(s).
For example, it lets you see clicks, impressions, page position, and so on of individual pages; shows you the keywords that are bringing the most traffic to your site, country-wise traffic, and many more.
In this tutorial, we’re going to walk you through how to import data from Google Search Console to Google Sheets, fetch them automatically, refresh them periodically, and get them sent to your email or Slack account using our smart, user-friendly Google Sheet add-on Amigo Data that lets you do all these without coding or any knowledge of programming.
Table of Contents
Getting started
Before we proceed to learning how to import data from Google Search Console to Google Sheets, you need to install the Amigo Data add-on in your Google Sheets. You can simply grab it from the Google Workspace Marketplace or install it from Google Sheets itself.
Open Google Sheets, click Extensions>Add-ons>Get Add-ons. Search for Amigo Data and click Install.
Once the installation and the set-up are complete, you should see Amigo Data listed in your Extensions tab.
Connecting Google Search Console to Google Sheets
Amigo Data obviates the need to manually set up API key for your Google Search Console, generate access token or fetch API URLs yourself. All you need to do is connect Amigo Data to Google Search Console and import data from Google Search Console to Google Sheets with ease.
Expand the Extensions tab and hover your cursor over Amigo Data and click the Connect option.
Here you’ll see a bunch of sources to pull data from.
Click Google Search Console. Change the Connection Name or you can leave the default as it is (you can change the name later) and click AUTHORIZE.
You’ll be redirected to an authorization page. Choose the account that you want to connect to Amigo Data and select Allow on the consent page. This completes the connection of Google Search Console to Google Sheets and we can proceed with importing data to Google Sheets.
Importing data from Google Search Console to Google Sheets
If the connection process goes fine, you’ll be presented with the Google Search menu as shown below.
Here you should see your property, ie your website, in the Select Domain dropdown menu. If, for some reason, your domain is not displayed, re-try the above step and make sure that the email that you choose has access to Google Search Console.
You have a number of options and data points that can be imported from Google Search Console to Google Sheets. Specify the parameters according to your desired preference: whether you want the query or page data for the current day, the day before, or the current month.
As an example, here’s how we can import the performance metrics data for individual pages for the last two months from Google Search Console to Google Sheets:
- Select your domain under Select Domain
- Change Today to Last X. Increase the number to 2 and change Quarter to Month.
- Under Select Dimensions choose Page
- Add filter and specify row limit (both optional)
- Preview to check whether the data to be imported are what you specified
- Click IMPORT
The Google Search Console data will then be imported into a new Google Sheets document, with all the relevant information sorted neatly and organised under different headers.
Setting a refresh schedule and alerts
After successfully importing the data, you might like the data to be refreshed periodically automatically so that you don’t have to import the data each time you want to see the report. You can set the refresh schedule frequency to hourly, daily or weekly and specify the time and the day on which you want the data refreshed according to your need and convenience.
You’ll be able to see the reports that you have generated and edit and modify them if you so desire.
To get alerted and the report sent to your email or Slack automatically, click Get Alert and then Add data alert+. Customise the alert and click Set Alert.
You will be alerted periodically on the day and at the time you specified via email and/or Slack.
Conclusion
With Amigo Data, you no longer need to worry about the hassle of keeping track of your site’s performance. You can let Amigo take care of it: import data from Google Search Console to Google Sheets and send you alerts at a time of your choice. It saves you time, and it lets you stay up-to-date and ahead while allowing you to relax.
Try Amigo. Try it for free. No credit card required.
Visit our website to find out more: https://tryamigo.com and our blog for tutorials and articles on Google Sheets.
Some commonly asked questions
How do I export Google Search Console data to Google Sheets?
Google Search Console data can be exported to Google Sheets using a couple of methods. One is to use the natively available method in Google Search Console by saving it in CSV and then importing them to Google Sheets. Another method is to use add-ons made specially for the purpose, such as Amigo Data.
Here’s how you can export Google Search Console data to Google Sheets:
- Install and connect Amigo Data to Google Sheets
- Select your domain and the date range of the data to import
- Select the dimensions and metrics to import
- Click Preview and then Import
How do I automatically import data from Google Search Console to Google Sheets
To automatically import data from Google Search Console to Google Sheets, click View Reports. Then click the report you want to automate refresh. Set the timing and save it. The Google Search Console data will then be pulled automatically into Google Sheets.