In this article:

How to Connect Google Analytics to Google Sheets

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.

Automate everything you track in spreadsheets with Lido
Learn more

Level up your Google Sheets skills with our free Google Sheets automation guide

Wasting too much time doing things manually in spreadsheets? Want to spend more time doing what you love? Our 100% free, 27-page Google Sheets automation guide is full of new tips and tricks that will save you time and money!