Open navigation

Google connection guide

This guide contains all permissions and requirements for connecting your any Google data to Supermetrics.


You can connect to data sources from the Data sources page on the Supermetrics Hub. On the Hub, you can also share an authentication link to connect to a data source you don't have direct access to.


After you connect to the data source on the Hub, you can use the data source connection in all available destinations.


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.


The following Google data source connectors have their own connection guides:


Required permissions

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


Google Ads

You need a Google Ads or manager account with Read Only access. Learn how to grant access to a Google Ads account or manage your accounts


If you have connected to Google Ads correctly, but your ad account doesn't appear, try granting the manager account access again.  

Google Ads Account Explorer

You need a Google Ads account with Standard access. Learn how to grant access to a Google Ads account or manage your accounts.


Monthly invoicing must be enabled for the whole Google Ads account at the Manager Account (MCC) level.

Google AdSense

You need a Google AdSense account with at least the Admin user role. Learn how to manage user access to your account.

Google Ad Manager

You'll need a Google Ad Manager account with at least the Trafficker role. API access must be explicitly enabled by the Administrator. 


Learn about role permissions and how to manage user roles, and how to enable API access

Google Analytics 4

You need a Google Account with at least Viewer access at the Property and View levels. Learn more about access management in Google Analytics 4.

Google BigQuery

You need BigQuery Data Viewer and BigQuery User role levels for the Dataset, and the BigQuery User role for the Project.


Note that the Google BigQuery data source connector is available only in Google Sheets and Looker Studio.


Google has limited the availability of its access credentials to 16 hours. Adding Supermetrics as a trusted app in the Google admin console can enable scheduled query refreshes and help you avoid daily reauthentication. Learn how to add Supermetrics as a trusted app.


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

You need a Google Account with an appropriate user role for the reporting content they need to see (this varies based on what the admin set for the role). Read more about user access in Google’s documentation.


You might need API access for the account enabled by a Google representative or the Campaign Manager 360 support team. Learn more about API prerequisites.

Google Display & Video 360

You need a Google Display & Video 360 account with at least a Standard or Admin user role. Learn how to manage user access.

Google My Business

You need a Google Account with at least an Owner or Manager user role. Learn how to add and remove owners and managers.


Please note that you can fetch only limited locations. Learn about usage limits on Google My Business API.

Google Search Ads 360

You need a Google Search Ads 360 account with at least an Agency Manager or Advertiser Manager role. Learn how to add or remove users.

Google Search Console

You need a Google Search Console account with Verified Owner or Delegated Owner access. Verify your site ownership first.


Note that in Looker Studio, you must select a query type to use with Google Search Console. Take a look at our Google Search Console report building guide to learn more about the available query types.


Connection instructions

When connecting to any of the Google data sources, you need to log in to Google and select the accounts to pull data from when prompted. 

  1. Select a Google data source on the Supermetrics Hub or in the data destination.
  2. If prompted, choose to make this connection shared or private.
  3. Click Sign in with Google.
  4. 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.
  5. Click Allow.
  6. In your data destination, select the accounts to pull data from.


See detailed instructions on how to connect to a data source from the Supermetrics Hub.


You can also connect to the Google data sources from these destinations:


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.