Open navigation

Google data sources: Query setup guide

Once you’ve authenticated your connection to your Google data source, you’re ready to create your first query.

This guide will walk you through how to create your first Google data source query in Google Sheets, Data Studio, or Excel.

Google data source metrics and dimensions

We're happy to offer a wide range of fields for our Google data source connectors. Review the full list in our technical documentation, including Google Ads, Google Analytics, and Google My Business.


Google Sheets Data Studio Excel
  1. Authenticate your Google data source in Google Sheets.
  2. In the Supermetrics sidebar, select a date range for your query. If you need to query a lot of historical data, consider using the “Combine new results with old” feature.
  3. Select your query’s metrics and dimensions. If you’d like some inspiration or a starting point, take a look at our Google Sheets templates.
  4. Click Get Data to Table to create your query and pull your data.

When you’re ready, further refine and enhance your Google Sheets queries with advanced settings.

You can also optimize your queries to keep them running as quickly and smoothly as possible, and set up scheduled refreshes so your queries update automatically. These refreshes also deliver reports directly to your inbox on a schedule that works for you.


Did you find it helpful? Yes No

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