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. 

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. 

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

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

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.

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.

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.

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

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. 

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

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

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.

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.

The report will run automatically, even without your intervention.