How to use Supermetrics for Google Sheets Add-on

Google Data Studio (Looker Studio)

What is Supermetrics for Google Sheets Add-on?

The Supermetrics for Google Sheets add-on is a Google Sheets extension that allows you to pull data from over 100 data sources (like Google Analytics, Google Ads, Facebook Ads, Google Search Console, Linkedin ads, Twitter ads, YouTube, BigQuery etc.) into Google Sheets.

Why use Supermetrics for Google Sheets Add-on?

If you want to pull Google Analytics data into Google Sheets, then you can do that by installing and using the Google Analytics Spreadsheet add-on (developed by Google) or by using the Supermetrics for Google Sheets add-on.

I use and recommend the Supermetrics for Google Sheets add-on rather than the Google Analytics Spreadsheet add-on.

The Google Analytics Spreadsheet add-on is not as easy to use as the Supermetrics for Google Sheets add-on.

If you want to pull data from multiple data sources into Google Sheets, then I would recommend using the paid version of Supermetrics for Google Sheets add-on.

The free version lets you download data only from Google Analytics.

Get weekly practical tips on GA4 and/or BigQuery to accurately track and read your analytics data.

 

My step-by-step blueprint for using Looker Studio (formerly Google Data Studio)

Get the FREE ebook on Looker Studio (75 Pages)

Download the FREE ebook

How to install Supermetrics for Google Sheets Add-on?

Follow the steps below:

Step-1: Navigate to your Google Drive Account: https://drive.google.com/drive/my-drive

Step-2: Click on the ‘+ New’ button on the top left-hand side of your screen:

new

Step-3: Click on ‘Google Sheets’ from the drop-down menu:

new google sheets

Step-4: Click on the ‘Extensions’ menu:

google sheets

Step-5: Click on ‘Get add-ons’ from the drop-down menu:

get add ons

You should now see a dialog box like the one below:

google workspace marketplace
looker studio e book

My step-by-step blueprint for using Looker Studio (formerly Google Data Studio)

Get the FREE ebook on Looker Studio (75 Pages)

Yes I want the FREE ebook

Step-6: Type ‘Supermetrics for google sheets’ in the search box and then press the enter key:

Your dialog box should now look like the one below:

supermetrics for google sheets

Step-7: Click on the box as shown below:

supermetrics for google sheets select

Step-8: Click on the ‘Install’ button:

install button

Step-9: Click on the ‘continue’ button:

continue

Step-10: Agree to the terms of services and privacy policy and then click on the ‘Finish‘ button:

finish

Step-11: Click on the ‘Continue‘ button:

continue2

Step-12: Click on your Google account:

google account

You should now see a dialog box like the one below:

allow access

Step-13: Scroll down and then click on the ‘Allow’ button:

make sure you trust

Step-14: Click on the ‘Done’ button:

done

Step-15: Close the dialog box by clicking on the cross button:

close

Step-16: Click on the ‘Extensions’ menu. You should now see ‘Supermetrics’ as one of the menu items:

supermetrics installed

Congratulations!

Supermetrics for Google Sheets add-on has been successfully installed.

Step-17: Click on the ‘Launch‘ button to launch supermetrics:

launch supermetrics

You should now see a screen like the one below:

launchbar

Step-18: Search for ‘Google Analytics 4‘ and then click on it:

ga4 1

Step-19: Sign in with Google to connect your GA4 property with Supermetrics.

Step-20: Create and run queries. Check out this article for more details: How to extract data from Google Analytics into Google Sheets.

  1. How to use Looker Studio with Google Sheets
  2. How to extract data from Excel or CSV file into Google Sheets
  3. How to extract data from Google Ads to Google Sheets
  4. Connect and transfer data from Google Sheets to BigQuery
  5. Sending data from Google Search Console to Google Sheets
  6. Supermetrics Queries for Google Sheets – Tutorial
  7. Google Sheets & Looker Studio Timezone Conversion
  8. How to extract data from Google Analytics into Google Sheets
  9. Looker Studio Date Format for Google Sheets – Tutorial
  10. Learn to export Facebook ads data to Google Sheets
  11. Understanding Aggregation in Google Sheets

#1 Google Analytics 4 Intro

  1. What is GA4 (Google Analytics 4) – The Apps + Web Property?
  2. Key Benefits of Using Google Analytics 4 (GA4)
  3. GA4 Migration Guide – Learn to upgrade to GA4 from GA3 via checklist
  4. Google Analytics 4 (GA4) vs Universal Analytics – What is the Difference?
  5. GA4 vs GA4 360 – Pricing, Limits, Billing and More
  6. Google Analytics 4 Training & Tutorial with FREE GA4 ebook
  7. Google Analytics 4 (GA4) Channels, Source and Medium explained.

#2 Google Analytics 4 Property

  1. Google Analytics Account Hierarchy (Structure Explained)
  2. Understanding Google Analytics Measurement ID (GA4)
  3. Google Signals GA4 – See Demographics (Gender, Age) in Google Analytics 4
  4. Using the GA4 (Google Analytics 4) Test Property
  5. Google Analytics 4 Sub Properties Tutorial
  6. Roll up Property in Google Analytics 4 (GA4) – Tutorial

#3 Google Analytics 4 Integrations

  1. How to connect GA4 (Google Analytics 4) with Google Data Studio
  2. How to link GA4 (Google Analytics 4) with Google Ads
  3. How to link Google Search Console to Google Analytics 4 (GA4)
  4. How to Install Google Analytics 4 on Shopify
  5. GA4 Firebase Integration – Correctly Add App Data Streams to GA4 Property

#4 Google Analytics 4 Events

  1. GA4 (Google Analytics 4) Event Tracking Setup Tutorial
  2. Understanding Event Parameters in Google Analytics 4 (GA4)
  3. Recommended Events in Google Analytics 4 (GA4)
  4. Enhanced Measurement Events in Google Analytics 4 (GA4)
  5. Automatically Collected Events in Google Analytics 4 (GA4)
  6. How to Set Up GA4 Custom Events via Google Tag Manager
  7. Events Report in Google Analytics 4 (GA4)
  8. How to Rename Events in Google Analytics 4 (GA4)
  9. How to Use Google Analytics 4 Event Builder
  10. GA4 Form Interactions Tracking – Enhanced Measurement 

#5 Google Analytics 4 Conversions

  1. Google Analytics 4 Conversion Tracking Guide – GA4 Goals
  2. How to Import Conversions from GA4 Property to Your Google Ads account
  3. GA4 Conversion Rate – How to find it and use it

#6 Google Analytics 4 Dimensions

  1. GA4 (Google Analytics 4) Dimensions Tutorial
  2. GA4 (Google Analytics 4) Custom Dimensions Tutorial
  3. GA4 User Properties (User Scoped Custom Dimensions) – Tutorial
  4. Event Scoped Custom Dimensions in GA4 – Tutorial
  5. How to remove (other) in GA4 reports and avoid Cardinality.
  6. How to remove not set in GA4 (Google Analytics 4)

#7 Google Analytics 4 Metrics

  1. GA4 (Google Analytics 4) Metrics Tutorial with Free Google Analytics 4 Ebook
  2. GA4 (Google Analytics 4) Custom Metrics Tutorial
  3. What are Predictive Metrics in Google Analytics 4 (GA4)

#8 Google Analytics 4 Ecommerce

  1. GA4 (Google Analytics 4) Ecommerce Tracking via GTM – Tutorial

#9 Google Analytics 4 Specialized Tracking

  1. GA4 (Google Analytics 4) Enhanced Measurement Tracking Tutorial
  2. Cross Domain Tracking in GA4 (Google Analytics 4) Setup Guide
  3. GA4 Site Search – Tracking Site Search in Google Analytics 4
  4. GA4 (Google Analytics 4) Scroll Tracking Tutorial
  5. Self-referral Google Analytics 4 – Referral exclusion GA4
  6. GA4 (Google Analytics 4) Data Import Tutorial
  7. Google Analytics 4 Content Grouping – Create Content Groups in GA4
  8. How to Track Single Page Apps in Google Analytics 4 (GA4)
  9. utm_source, utm_medium, utm_campaign Parameters – GA4 (Google Analytics 4) 
  10. GA4 Form Tracking via Google Tag Manager
  11. How to Track Phone Calls in Google Analytics 4 – Call Tracking Tutorial.
  12. How to use Microsoft Clarity with GA4 (Google Analytics 4)

#10 Google Analytics 4 filters

  1. GA4 filters – Understanding Data Filters in Google Analytics 4
  2. How to Create and Test Filters in Google Analytics 4 (GA4)?
  3. Exclude Internal Traffic in GA4 (Google Analytics 4) via IP Filter

#11 Google Analytics 4 Explorations

  1. Free Form Report in GA4 (Google Analytics 4) – Exploration Report
  2. How to Use the User Lifetime Report in Google Analytics 4 (GA4)
  3. How to Use Path Exploration Report in GA4 (Google Analytics 4) – Path Analysis
  4. How to Use Segment Overlap Report in Google Analytics 4 (GA4)
  5. How to Use the Funnel Exploration Report in GA4 (Google Analytics 4) – Funnel Analysis
  6. Cohort Exploration Report in Google Analytics 4 (GA4)
  7. How to Create Landing Pages Report in GA4 (Google Analytics 4)
  8. How to Create Google Ads report in GA4 (Google Analytics 4)
  9. How to Segment GA4 Data by Data Stream
  10. Organic Search Traffic Analysis in GA4 – Complete Guide
  11. Google Analytics 4 (GA4) Outbound Links Tracking 
  12. How to Track Email Campaigns and Traffic in GA4 
  13. How to view full page URLs in GA4?

#12 Google Analytics 4 Advanced

  1. Understanding Google Analytics 4 Sessions
  2. GA4 (Google Analytics 4) Measurement Protocol Tutorial
  3. How to Build Comparisons (Advanced Segments) in Google Analytics 4 (GA4)
  4. Understanding Automated Insights in Google Analytics 4 (GA4)
  5. Understanding Channel Groupings in Google Analytics 4 (GA4)
  6. Understanding Data Sampling in Google Analytics 4 (GA4)
  7. Google Analytics 4 Regex (Regular Expressions) Tutorial
  8. Google analytics 4 GDPR compliance checklist
  9. How to Exclude URL Query Parameters in Google Analytics 4
  10. What is unassigned traffic in GA4 and how to fix it.
  11. Google Analytics 4 not working? Here is how to fix it.

#13 Google Analytics 4 Reports

  1. How to Create Custom Insights in Google Analytics 4 (GA4)
  2. How to Use Debug View Report in Google Analytics 4 (GA4)
  3. How to see Organic Search Keywords in GA4 (Google Analytics 4)

#14 Google Analytics 4 Attribution

  1. Guide to Attribution Models in GA4 (Google Analytics 4)
  2. How to Change Attribution Models in GA4 (Google Analytics 4)?
  3. GA4 (Google Analytics 4) Conversion Paths Report in Attribution
  4. GA4 (Google Analytics 4) Model Comparison Report in Attribution
  5. Advertising Snapshot in GA4 (Google Analytics 4) Attribution
  6. GA4 Attribution Modelling Tutorial

#15 Google Analytics 4 Audiences

  1. GA4 Audiences – Creating Custom Audience in Google Analytics 4
  2. How to Create a Remarketing Audience in Google Analytics 4 (GA4)
  3. Understanding Audience Triggers in Google Analytics 4 (GA4)
  4. Google Analytics 4 (GA4) Predictive Audiences – Tutorial

#16 Google Analytics 4 BigQuery

  1. Google Analytics 4 BigQuery Tutorial
  2. GA4 BigQuery – Connect Google Analytics 4 with BigQuery
  3. BigQuery GA4 Schema – Send Custom GA4 Data to BigQuery
  4. How to Backfill GA4 Data in BigQuery
  5. How to Connect and Export Data from GA4 to BigQuery
  6. Query GA4 data in BigQuery without understanding SQL.

My best selling books on Digital Analytics and Conversion Optimization

Maths and Stats for Web Analytics and Conversion Optimization Master the Essentials of Email Marketing Analytics Attribution Modelling in Google Analytics and Beyond Attribution Modelling in Google Ads and Facebook

Maths and Stats for Web Analytics and Conversion Optimization
This expert guide will teach you how to leverage the knowledge of maths and statistics in order to accurately interpret data and take actions, which can quickly improve the bottom-line of your online business.

Master the Essentials of Email Marketing Analytics
This book focuses solely on the ‘analytics’ that power your email marketing optimization program and will help you dramatically reduce your cost per acquisition and increase marketing ROI by tracking the performance of the various KPIs and metrics used for email marketing.

Attribution Modelling in Google Analytics and BeyondSECOND EDITION OUT NOW!
Attribution modelling is the process of determining the most effective marketing channels for investment. This book has been written to help you implement attribution modelling. It will teach you how to leverage the knowledge of attribution modelling in order to allocate marketing budget and understand buying behaviour.

Attribution Modelling in Google Ads and Facebook
This book has been written to help you implement attribution modelling in Google Ads (Google AdWords) and Facebook. It will teach you, how to leverage the knowledge of attribution modelling in order to understand the customer purchasing journey and determine the most effective marketing channels for investment.

About the Author

Himanshu Sharma

  • Founder, OptimizeSmart.com
  • Over 15 years of experience in digital analytics and marketing
  • Author of four best-selling books on digital analytics and conversion optimization
  • Nominated for Digital Analytics Association Awards for Excellence
  • Runs one of the most popular blogs in the world on digital analytics
  • Consultant to countless small and big businesses over the decade