How to get Google Analytics data into Google Sheets

Web analytics is important to grow your business website, it will provide you with visitor data so that you can have an understanding of how visitors use your website. Google Analytics allows you to track and understand your customer’s behavior, user experience, online content, device functionality, and more. If you own and manage a number of websites tracking the analytics of those can easily out of hand. Two Minute Reports makes it easier to bring the analytics of all the websites you own within Google Sheets without writing a single line of code. In this tutorial, we will show you how to pull Google Analytics data into Google Sheets using Two Minute Reports.

Step 1 : Connect Google Analytics to Google Sheets

You can add your Google Analytics data source by going to the Data Sources section. Click on Add and select Google Analytics data source from the Web Analytics section. You will be prompted to sign in with a Google account, do sign in with the Google account linked with Google Analytics.

If you get an error message do check if you have signed in with the correct gmail account that is linked with Google Analytics . After adding Google Analytics Data Source you can add as many queries as you need, to get data using the same.

Step 2 : Getting Google Analytics data in Google Sheets

Once you have added a Data Source you can access it from any spreadsheet within your Google Account, you just need to open Two Minute Reports and create a new query.

To pull analytics data you can add a query by going into the Data Queries section. Upon clicking Add in the Data Queries section you will be prompted to name your query and select a Data Source. Name your query and select the Google Analytics Data Source from Step 1 and select the Sheet where you want to save the analytics data.

Once the required Data Source is selected you will get dropdowns with Properties/Websites/Views, Metrics, and Dimensions. Select the required fields and press Run query . Data will be pulled from Google Analytics and populated in the Sheet that you selected as shown below.

Pull data into Google Sheets

Once a query is added, you can make it refresh the latest data automatically by going to the Schedule Refresh section and adding a schedule.


Was this helpful?