This article will help you get your GA4 analytics data to Google Sheets using Two Minute Reports. You may wonder, “Why use Two Minute Reports, when you get it in native Google Analytics 4 connector?? “ The Answer is, Two Minute Reports can fetch around 50 pages at a single session and get all of its analytics under a single roof – Google Sheets! Also, you have the privilege of accessing various other data connectors like, Google search console, Facebook ads, google ads and much more, You can have all of these analytics beside your GA4 data. Click here, to get a detailed blog with images and video.
As you have got the point now, let’s dive into the 2 Methods available
Method 1: Using Two Minute Reports sidebar
1. Install Two Minute Reports extension from Google marketplace and launch Two Minute Reports sidebar.
2. Create a new Data Source by authorising your GA4 Account. Once created, start creating your new query config by adding the new data source, metrics, dimensions, filters, and much more.
3. Once your query config is created, click on Run query. Your GA4 data will now be present in the Google Sheet.
Method 2: Using Two Minute Reports pre-defined Templates
Delete
1. Install Two Minute Reports extension from Google marketplace and launch Two Minute Reports sidebar.
2. Click on the 3 dash menu icon and choose Templates. Search for your GA4 Template and click on use. Map your data source, web pages and click on save.
3. Open your Template copy, launch TMR sidebar and click on Run all queries. Your GA4 data will now be present in the Template.
Hope you got both the methods to get GA4 data to Google Sheets. Stay tuned to get more informative updates from me!
