Open navigation

Google connection guide

Use this guide to connect any Google data source to Supermetrics.


Note that while these data sources share the same connection steps, each has unique permissions that you need to implement before you're able to connect. Make sure you've assigned these permissions before going ahead.


If you need to connect these data sources to one of our data warehouse or cloud storage destinations, explore our data warehouse and cloud storage setup guides.


Before you begin

Select a Google data source from the list below to learn about its permissions and other connection requirements.


Google Ads
Google AdSense
Google Ad Manager
Google Analytics & Google Analytics 4
  • You'll need a Google Analytics account with at least Read & Analyze access to a Property and Views underneath. Learn more about user permissions and how to add users.
Google BigQuery


Google BigQuery field list types

  • Simplified field list: Shows each unique field name just once, if it's present in multiple tables.
  • Full-field list: Shows all columns from your tables in BigQuery.
  • Simplified list: With join fields only — shows only the fields that are available for multiple data sources. 
Google Campaign Manager 360
Google Display & Video 360
Google My Business
Google Search Ads 360
Google Search Console



Instructions

Google Sheets Looker StudioExcel

Make sure you've installed the Supermetrics add-on before you connect.

  1. Open a new Google Sheets file.
  2. Navigate to ExtensionsSupermetricsLaunch sidebar to open Supermetrics.
  3. Click Create new query.
  4. Under Data source, select your Google data source.
  5. Click Start.
  6. Sign in with the Google Account you use with this data source. This doesn't have to be the same as the Google Account you use with Supermetrics.
  7. Click Allow.

Learn about advanced settings, best practices, and troubleshooting tips for Supermetrics for Google Sheets.


More resources

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.