Connect Google Analytics to Google Sheets with

google analytics 1


google sheets

Finally, all your website and analytics data from Google Analytics available in Google Sheets

About Google Analytics

Google Analytics is the worlds most used Web Analytics platform and offers its users detailed insights into website traffic, conversions, sales and other customisable dimensions and metrics. It is available in 40 languages and has a market share of 82%.

About Google Sheets

Google Sheets is a web based spreadsheet tool. It allows end users to create spreadsheets, pivot tables, charts and run Google App Script code to automate various functions.

First Step:

You need to select Google Analytics as a Data Source and Grant Access to

Second Step:

As you can see, you have two options to add data from Google Analytics, one is Google Analytics UA, and the other is Google Analytics 4.

The differences between the two are explained here. But the main difference is that the hit types in Universal are captured as events in GA4.

Third Step:

Once you connect the data, i.e. sign in with Google, you will need to go to 2. Select  Destination to choose where do you want to send your data.

Fourth step:

Select Google sheets as a data destination.

Fifth Step:

You can choose between two options:

Option 1: Advanced and for large data volumes
  1. Click this link to install the Google Sheets add-on
  2. Enter your API key: defab2f1e4d0b69f2aa9fcca30c8abe0f996
  3. Start using the add-on in Google Sheets from the Add-ons menu in a Google Sheets document and select your fields
Option 2: Quickstart
Copy the snippet below into your Google Sheet. Only works for fast queries below 60 seconds, use the add-on in case of issues.The URL works as an API data feed and the fields can be adjusted with the parameters in the URL.You can add any field that is available in the data sources you have added.


Instruction: The list of selected fields must contain a date field.

You should also Read :

Connect any Data to Google Sheets with

Connect Google Analytics to Excel with

How to Connect Google Sheets data in BigQuery

Templates for Google Analytics and Google Sheets Connecting all marketing data

See the value and return on every marketing touchpoint

data warehouse

Providing 50+ marketing data streams, we make sure that all the data we integrate is fresh and accessible by marketeers, whenever they want.


Spend less time on manual data loading and spreadsheets. Focus on delighting your customers.

Start a free trial today.

Integrate all your data and measure what matters.