Search API Connector Documentation

Print

Import Google Analytics Management Data to Google Sheets

premium

In this guide, we’ll walk through how to pull data from the Google Analytics Management API directly into Google Sheets, using the API Connector add-on for Sheets. The Google Analytics Management API enables programmatic access to Google Analytics configuration data, such as lists of all the accounts, properties, and views that you have access to.

Contents

Before You Begin

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

Part 1: Connect to the Google Analytics Management API

The easiest way to get started with the Google Analytics Management API is through API Connector’s built-in integration.

  1. Select Google Analytics (UA) from the drop-down list of applications
    ga-application
  2. Under Authorization, click Connect to Google Analytics (UA)
    ga-authorization
  3. You will be asked to allow API Connector to view your Google Analytics data. Click Allow.
    google-analytics-img2
  4. You’ll then be returned to your Google Sheet, and can verify that your Google Analytics connection is active.

Part 2: Pull Data from the Google Management API into Sheets

Now that we’re connected, let’s pull some data into Sheets.

  1. Under Endpoint, choose the /management/accountSummaries endpoint to list your available GA accounts, properties, and views
    gamanagement-endpoints
  2. There are no required request parameters. You can optionally set the max-results parameter to limit the number of records to retrieve.
  3. Select a destination sheet, name your request, and click Run.
    gamanagement-response

Part 3: Create a Custom Request

Alternatively, you can run your own custom requests instead of using API Connector’s pre-built integration, using any of the API URLs shown in the API documentation. To create a custom request, add your complete URL into the Request URL field, and choose Google Analytics from the OAuth menu.
gamanagement-custom

To easily convert from a preset request to a custom API URL, tick the Add request URL box before running your preset request (under Output options). This will print out your complete API URL, which you can then copy/paste into the request URL field.

Part 4: API Documentation

Official API documentation: https://developers.google.com/analytics/devguides/config/mgmt/v3/mgmtReference

Previous Import Google Analytics (UA) Data to Google Sheets
Next Import Google Calendar Data to Google Sheets

Leave a Comment

Table of Contents