---
title: "How to create a Supermetrics query in Google Sheets"
slug: "how-to-create-a-supermetrics-query-in-google-sheets"
description: "Learn to create queries and pull data into Google Sheets with Supermetrics. Follow our step-by-step guide for effective data management!"
updated: 2025-09-26T08:37:52Z
published: 2025-09-26T08:37:52Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.supermetrics.com/llms.txt
> Use this file to discover all available pages before exploring further.

# How to create a Supermetrics query in Google Sheets

This guide will walk you through how to create a query and start pulling your data directly into Google Sheets with Supermetrics.Make sure you’ve [installed the Supermetrics add-on](/v1/docs/how-to-install-supermetrics-in-google-sheets) and [logged into at least one data source](/v1/docs/how-to-connect-to-a-supermetrics-data-source-in-google-sheets) before you begin.

## Instructions

For a video tutorial, scroll down the page.

1. Open a Google Sheets file.
2. Navigate to **Extensions** → **Supermetrics** → **Launch** to open the Supermetrics sidebar.
3. Click **Create new query**.
4. Under **Data source**, choose which data source your query should pull data from.
5. Select which [data source account](/v1/docs/about-data-source-accounts) you want to use for this data source, and which query type to use, if prompted.
6. If the data source has query types, select one to use under **Report configuration**. Available query types for each data source are listed in the [connection guides](/v1/docs/connect).
7. In the sidebar, choose your query’s **Date range**, **Metrics**, and **Dimensions**.With the **Custom date range** option, you can use exact dates but also sliding dates. For example, you can set the start date to be **-5 days** and the end day to **yesterday**. This information can be typed into the date boxes.
8. Make further adjustments in **Options**, and [add a filter](/v1/docs/how-to-use-filters-in-google-sheets-queries) if you need one.
9. In **Data visuals**, select a visualization for your data. Note that visualizations are available only when you're creating the query for the first time. When you're editing an existing query, you can't change the visualization.
10. Click **Get data**. Your data will fill starting from the cell you’ve selected in your Sheet.

If you need to modify your query, click on any cell containing its data to open the Supermetrics sidebar and highlight the query or find the query in the sidebar. When you've found the right query, click the pencil icon to edit.

The following video shows you how to start using Supermetrics in Google Sheets and set up your first queries.

[Embedded content](https://www.youtube.com/embed/S5cjk4GOlUY?&wmode=opaque)

## Next steps

- [Use Supermetrics report templates](/v1/docs/how-to-use-supermetrics-report-templates-in-google-sheets)
- [Set up automatic data refreshes and email reports](/v1/docs/how-to-create-and-manage-scheduled-refreshes-in-google-sheets)
- [Enable advanced settings](/v1/docs/about-supermetrics-advanced-settings-for-google-sheets)