Google Sheets Google Analytics 4 (GA4) Report Dashboard Template

Google Analytics 4 Dashboard

This Google Analytics 4 Report Dashboard template helps you to visualize your GA4 data in Google Sheets in a couple of clicks. Dimensions and metrics visualized in this report are:

  • Date
  • Source
  • Medium
  • Country
  • Device Category
  • Sessions
  • Engaged Sessions
  • Engagement Rate
  • Conversions
  • Conversion Rate
  • # of Referral Sites

There is a list of close to 300 metrics and dimensions available once you start customizing the report. To find the full list head to Available metrics and dimensions.


How to Use This Template

Step 1:

Login or Register on

Create an account on
Step 2:

Choose Google Analytics 4 from the Data Sources panel and Sign in with your Google Ads account. Then click on Preview and Destination from the upper side of the screen.

Connect GA4 to Google Sheets


Step 3:

Click on Google Sheets from the Destination panel as shown below and copy your API KEY.

Google Sheets as a destination for Google Analytics 4


Step 4:

Add’s Extension to Google Sheets.

Google sheet extension for Google Analytics 4
Step 5:

Copy the template below by clicking on File -> Make a copy.
Template Link : Google Sheets Google Analytics 4 Report Dashboard.

GA4 Copy Template file


Step 6:

Under Extensions in the top ribbon of Google Sheets, select “Ad Data & Analytics by“, then “Login” and Paste your API KEY in the pop-up window:

GA4 Template Login Addon


Step 7:

Now select “Ad Data & Analytics by” -> Get Data into Sheet, then click on the Edit icon under the GetGA4Data query.

GA4 Template Get Data


Choose the accounts you want to include and the date range. Optionally, you can also set an automated refresh schedule from the menu.

Now click on Load Data and head over to the Dashboard tab to see your own data.


You might also be interested in…