Import data from Google Search Console to Google Sheets

Reading Time: 6 minutes

Quick Guide

How to import data from Google Search Console to Google Sheets:

  1. Sign in to Amigo
  2. Connect to Google Search Console
  3. Select Google Search Console from the sources
  4. Select your domain and the metrics to import
  5. Preview and click IMPORT.

Video: How to export Google Search Console data to Google Sheets

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. You can import these website data into Google Sheets and gain insights with granular analysis.

In this tutorial, we’re going to learn 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 Amigo web app that lets you do all these without coding or any knowledge of programming.

How to import Google Search Console data to Google Sheets

A step-by-step guide on how to import data from Google Search Console to Google Sheets with Amigo.

This article has two section: Connecting Google Search Console to Google Sheets and exporting website traffic data to Google Sheets.

How to connect Google Search Console to Google Sheets

Step 1: Log on to Amigo

Sign in to Amigo with a valid email address. Yes, that’s right – you can access Amigo without going through the signing-up process.

Import data from Google Search console to Google Sheets

After logging in, you will be able to connect to various data sources and import their data into Google Sheets.

Step 2: Click “Add new connections”

Click on Create new connections to connect Google Search Console to Google Sheets

Connect Google Search Console to Google Sheets to export your website traffic data to Google Sheets

Step 3: Select Google Search Console to connect

From the list of data sources, select Google Search Console to link Google Search Console to Google Sheets and export your website traffic data into Google Sheets.

Step 4: Name the connection

Name the connection and click the Connect button to connect Google Search Console to Google Sheets.

Step 5: Sign in to Google to complete the connection

You will be redirected to the Google sign-in page. Sign in with the Google account to export the Google Search Console data to Google Sheets.

Upon signing in to Google, you will be required to grant the necessary permissions to Amigo in order to establish a connection. Click the Allow button to to complete the Google Sheets and Google Searh Console integration.

The Google Search Console connection to Google Sheets

Hurray!!! You have successfully established a Google Search Console connection with Google Sheets.

Import data from Google Search Console to Google Sheets

Amigo lets you curate the key metrics of your choice for analytical purposes. This way you can choose the metrics.  

Follow these steps below to import data from Google Search Console to Google Sheets.

Step 1: Click on the Connection

Click on the Google Search Console connection which you have just established and select the Imports option.

Step 2: Select the website domain and specify the date range

Select the Domain for which you want to import Google Search Console data to Google Sheets. Also, select the Date Range values for which you want to import data from Google Search Console to Google Sheets.

Step 3: Set a refresh date to auto-update the data

In order to automatically update your Google Search Console data imported to Google Sheets, you can also set a refresh schedule. This way the imported data will get updated based on the set frequency. In the following snippet, the imported data is set to be updated every 2 hours.

Step 4: Specify the type of traffic data to import

Select the Type of your choice. For example, we have chosen Web option.

Step 5: Select the dimensions

Add Dimensions on the basis of which you want to analyze the imported data. For example, we have chosen the Date and Page options to analyze Google Search Console data.

Step 6: Preview and import

Click Preview to view the Google Search Console data to import to Google Sheets.


You can import Google Search Console data to Google Sheets by simply clicking on Import to Google Sheets button.

In order to import the data to Google Sheets, you need to connect Amigo to Google Drive. Add a connection and click the Export button.

The following image is the snippet of imported data from Google Search Console to Google Sheets.

Snippet of the Google Search Console data imported to Google Sheets

After exporting the Google Search Console data to Google Sheets, Amigo will automatically update the imported data on the daily basis or at a frequency of your choice.

You can also set an alert to let Amigo send the analytics report to you and your team via email and/or Slack. The feature will soon be available on the web app, but as of now you can implement it by installing Amigo Add-on from the Google Workspace Marketplace here.

Open the spreadsheet and use Amigo Add-on to set alerts. Click here to learn more.

This way you can monitor and optimize your web campaign. Using Amigo, you can gain Google Search Console data insights to make data-driven decisions and ensure the multifold growth of your website. With Amigo as your reporting buddy, you can never miss your deadline or lose track of data.

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 website 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

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:

  1. Install and connect Amigo Data to Google Sheets
  2. Select your domain and the date range of the data to import
  3. Select the dimensions and metrics to import
  4. Click Preview and then Import

To automatically import data from Google Search Console to Google Sheets, click View Reports. Then click the report you want to automatically refresh. Set the timing and save it. The Google Search Console data will then be pulled automatically into Google Sheets.

Most data integration tools require that you have the Google Search Console API client ID and some knowledge of API and how it works. With Amigo, though, you need none of those. All you need is a Google account with access to Google Search Console. Connect Google Search Console to Google Sheets with that account and easily export your website traffic data to Google Sheets. And then sync Google Sheets with Google Search Console.

Some related articles you you may be interested in:

Export Facebook Ads Data To Google Sheets

Export Google Ads Data To Google Sheets

Export Google Analytics Data to Google Sheets

X
Need Google Sheets dashboards? Get expert analysts on-demand.