April 3, 2021

How to Connect Google Analytics to Google Sheets

Google Sheet spreadsheet
SECTIONS

1. Add Google Analytics Add-On

2. Create a new Google Analytics report in Google Sheets

3. Automate your report by specifying a schedule

Google Analytics is a powerful tool that you can use to track your website metrics over time. Fortunately, it’s easy to regularly export data from Google Analytics to Google Sheets. In this tutorial, we will learn how to do so.

Add Google Analytics Add-On

The first thing you need to do is to add the Google Analytics add-on. Here are the steps:

Step 1: Install the Google Analytics Add-On. First, click Add-ons on the main menu. Then, click Get add-ons. 

Add-ons, Get add-ons.
Add-ons, Get add-ons.


Step 2: Search for Google Analytics in the search bar. The Google Analytics Add-on will appear first. Click on the green icon in the lower-right of the result. 

Google Analytics add-on in Google Marketplace
Google Analytics add-on in Google Marketplace

Step 3: The description page of Google Analytics Add-On will appear. Click Install

Google Analytics add-on. Install button.
Google Analytics add-on. Install button.


Step 4: A small prompt will appear, asking if you want to continue. Click Continue

Google Analytics needs your permission before it can be installed.
Google Analytics needs your permission before it can be installed.


Step 5: A window will pop up asking you to choose the account where you want the add-on used. Click the account. A list of permissions required will appear next. Click Allow.

A list of permissions you need to give to Google Analytics so it can work seamlessly.
A list of permissions you need to give to Google Analytics so it can work seamlessly.
A list of permissions you need to give to Google Analytics so it can work seamlessly.


Step 6: On the Google Sheets, a prompt will appear once Google Analytics is installed. Click Done.

Create a new Google Analytics report in Google Sheets

After adding the Google Analytics add-on, you need to set up a report to specify the data that you want to get from Google Analytics. Here are the steps:

Step 7: Click Add-ons in the main menu, then click Google Analytics. A drop-down menu will appear. Click Create new report.

Add-ons, Google Analytics, Create new report.
Add-ons, Google Analytics, Create new report.


Step 8. A sidebar for creating a new report will appear on the right side of the screen. Specify the name of the report, the Google Analytics account to access, and the metrics to access.

Google Analytics sidebar. Create a new report.
Google Analytics sidebar. Create a new report.


Google Analytics sidebar. Create a new report. Choose configuration options.
Google Analytics sidebar. Create a new report. Choose configuration options.


Once you have specified the configuration, click Create report. A separate sheet containing the configuration will be added to your Google Sheets.

Sheet containing the configuration options of the report. Some information erased for security.
Sheet containing the configuration options of the report. Some information erased for security.


Automate your report by specifying a schedule

After setting up your report, you still need to gather the data to generate it. You can opt to immediately generate the report. To do so, click Add-ons on the main menu, click Google Analytics, then click Run reports. It will generate the report at this point. 

Add-ons, Google Analytics, Run reports.
Add-ons, Google Analytics, Run reports.


A pop-up window will appear once the report is successfully completed.

Report status pop-up window. Report completed successfully.
Report status pop-up window. Report completed successfully.


A new sheet is created where you can read the report.

Sheet containing the report. Summary shown.
Sheet containing the report. Summary shown.


You can also schedule the report generation. Here are the steps:

Step 9: Click Add-ons on the main menu, click Google Analytics, then click Schedule reports.

Add-ons, Google Analytics, Schedule reports.
Add-ons, Google Analytics, Schedule reports.


Step 10: A popup window will appear where you can set the time to run the report. Check first the Enable reports to run automatically box. Then specify the time to run the report. Click Save.

Schedule reports pop-up window. Enable reports to run automatically checked. Scheduled everyday between 4 Am to 5 AM.
Schedule reports pop-up window. Enable reports to run automatically checked. Scheduled everyday between 4 Am to 5 AM.


The report will run automatically, even without your intervention.

Suscribe to get more data and analytics tips!

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.