This tutorial will explain how to import Google Analytics to your Google Sheets spreadsheet.
Our guide will show how you can add the Google Analytics Spreadsheet add-on to access, visualize, and share reports quickly.
Google Analytics is a web traffic analysis application that gives users real-time data on how users interact with their websites. The powerful tool can collect the number of visitors that browse your website, which devices they use, and their approximate geolocation.
While the Google Analytics website already has its own dashboards and built-in reports, you may want to create a report in Google Sheets so that your team or stakeholders can easily access the data.
Let’s take a look at a quick example where we can use the Google Analytics option in Google Sheets.
Suppose you have a website that sells a certain product. You want to determine which countries visit your website the most. You’ve already set-up Google Analytics on your website and already have historical data for the past 6 months.
You decide it’s best to share this information through a Google Sheet report, especially since everyone in the team is familiar with the platform. You would also like to schedule the report to update once a week. How can we do this in Google Sheets automatically?
If you want to import Google Analytics data to Google Sheets, we must first install the Google Analytics add-on in our worksheet. Afterwards, we can configure reports using Google Analytics API.
An advantage of using Google Sheets for our Google Analytics data is that users now have an easy way to manipulate, visualize, and share analytics reports without having to code anything.
In general, we can generate new reports quickly with the Google Analytics add-on. We can also schedule reports to run and update automatically. Using Google Sheets’ privacy features, we can also control who can see our website traffic data and reports.
Now that we know why we need to install the Google Analytics add-on, let’s take a look at a sample spreadsheet that uses Google Analytics data.
A Real Example of Using the Google Analytics Add-On in Google Sheets
Let’s take a look at a real example of how you can use the Google Analytics add-on on a spreadsheet.
If the Google Analytics add-on has been installed properly, you can find the option to create new reports in the Google Analytics option found under the Extensions menu.
Creating new reports involves setting up a Report Configuration tab. In this tab, the user will specify the time frame, granularity, and dimension to include in the report. Once the configurations have been set, the user can click on the Run reports option to populate new tabs in your worksheet.
In the example below, we’ve added a report that shows the top countries that visit our given website.
Using the Google Analytics API, we can create data with multiple views easily. This is an improvement over the default Google Analytics web interface, allowing users to see only one view at a time.
You can make your own copy of the spreadsheet above using the link attached below.
If you’re ready to try importing the Google Analytics function in Google Sheets, follow our guide in the next section.
How to Import Google Analytics to Google Sheets
This section will guide you through every step you need to import Google Analytics to Google Sheets. You’ll learn how to install the add-on through the Google Workspace Marketplace and later find the option to create new reports.
Follow these steps to start using the Google Analytics function in Google Sheets:
- First, navigate to the Extensions menu. Under the Add-ons option, click on Get add-ons.
- The Google Workspace Marketplace pop-up will appear. Add the search term ‘Google Analytics’ to the search bar and click on the first result.
- In the Google Analytics add-on page, click on the Install button in the top-right-hand corner.
- Google Sheets will ask your permission first before installing the Google Analytics add-on. Click on Continue to proceed.
- After giving Google Analytics permission, wait a few seconds for the add-on to install. Once the add-on is installed completely, click on Done to return to your spreadsheet.
- Afterwards, you can find the Google Analytics add-on under the Extensions menu.
Frequently Asked Questions (FAQ)
- Do I need to install Google Analytics for each sheet I’m working with?
Yes. Since importing this add-on works on a worksheet-level basis, you will need to import the add-on to each spreadsheet that requires data from your Google Analytics projects.
- Can I set different schedules for each of my reports?
Each report in the same spreadsheet must follow the same scheduling. If you need to schedule reports at different intervals, you may need to use more than one spreadsheet.
This step-by-step guide should be all you need to import Google Analytics to your Google Sheets spreadsheet. Our guide shows how easy it is to install the add-on through the Google Workspace Marketplace.
Once you import data from your Google Analytics projects, you now have the advantage of being able to explore your dataset in a familiar and flexible workspace. With so many other Google Sheets functions available, you can surely find one that suits your use case.
Are you interested in learning more about what Google Sheets can do? Subscribe to our newsletter to find out about the latest Google Sheets guides and tutorials from us.