Import Google Search Console Data to Sheets

In this guide, we’ll walk through how to pull Google Search Console data data directly into Google Sheets, using the API Connector add-on for Sheets.

Contents

• Before You Begin
• Part 1: Connect to the Google Search Console API
• Part 2: Create a Google Search Console API Request
• Part 3: Pull Google Search Console API Data into Sheets
• Part 4: Other Google Search Console Data

Before You Begin

Click here to install the API Connector add-on from the Google Marketplace.

Part 1: Connect to the Google Search Console API

If you haven’t connected API Connector to Google Search Console before, you’ll first need to initiate the connection as follows:

1. Open up Google Sheets and click Add-ons > API Connector > Manage Connections.
2. In the list of available connections, find “Google Search Console” and click Connect.
   
   
3. You will be directed to google.com and asked to allow API Connector to view your Google Analytics data.
   
4. You’ll then be returned to your Google Sheet, and can verify that your Google Search Console connection is active in the Connections screen.
   

Part 2: Create a Google Search Console API Request

For our first request, we’ll pull in summary search performance statistics for your website. Search analytics data from the Google Search Console API is accessed by sending POST requests to this API Request URL:

https://searchconsole.googleapis.com/webmasters/v3/sites/https%3A%2F%2Fmixedanalytics.com/searchAnalytics/query

Where it says https%3A%2F%2Fmixedanalytics.com, substitute in your own URL. Make sure to encode it or the API won’t recognize it.

Breakdown dimensions and dates are specified in the POST body, like this:

{
  "dimensions": [
    "QUERY"
  ],
  "startDate": "2021-06-01",
  "endDate": "2021-06-15"
}

The “QUERY” dimension will return a list of search queries.

Part 3: Pull Google Search Console API Data into Sheets

We can now grab that data into Sheets.

1. In API Connector, click Create, choose POST from the dropdown menu, and paste in the Request URL we created above.
   
   
2. Choose ‘Google Search Console’ from the authentication dropdown.
3. Under headers, enter Key = content-type, Value = application/json.
   
   
4. In the POST Body section, paste in the POST body we created above.
   
5. Create a new tab and click ‘Set current’ to use that tab as your data destination.
6. Name your request and click Run. A moment later you’ll see search analytics stats for each of your keywords populate your sheet.
   

Part 4: Other Google Search Console API Data

View the full list of available search analytics parameters here. One easy way to get started is to use their API Explorer tool, which provides an interface to build your request:

Once you’ve created your request, you can copy and paste it into API Connector to get the response data in Sheets.