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

# Google Sheets Quickstart

> Get up and running with Detrics for Google Sheets in minutes

<Info>**Last updated:** August 2, 2025</Info>

It's great to have you here! Follow the steps provided below to get started with Detrics for Google Sheets in just a few minutes.

## Get Started

<Steps>
  <Step title="Get Started Free Forever">
    Create your **[free Detrics
    account](https://detrics.io/get-started?utm_source=detrics-support\&utm_medium=google-sheets-quickstart)**,
    no credit card required. You'll receive a personalized onboarding sheet with
    generous free usage limits perfect for individuals and small teams.

    <Frame>
      <img src="https://mintcdn.com/detrics-4688583d/zhuWz3v2lbFVKC5_/images/get-started-sheets/get-started.png?fit=max&auto=format&n=zhuWz3v2lbFVKC5_&q=85&s=d87fdcc68e63c755bddaa4163cd50086" alt="Get Started with Detrics" width="1072" height="861" data-path="images/get-started-sheets/get-started.png" />
    </Frame>

    After clicking "Connect to Google Sheets", you'll be prompted to sign in
    with your Google account:

    <Frame>
      <img src="https://mintcdn.com/detrics-4688583d/zhuWz3v2lbFVKC5_/images/get-started-sheets/get-started-google-auth.png?fit=max&auto=format&n=zhuWz3v2lbFVKC5_&q=85&s=40b6b42464b292b66d625e9fbd9857ca" alt="Google Authentication" width="1080" height="867" data-path="images/get-started-sheets/get-started-google-auth.png" />
    </Frame>
  </Step>

  <Step title="Install Detrics Add-on">
    Follow the steps from the onboarding file created for you in the previous step
    to install the Detrics Add-on for Google Sheets.

    <Frame>
      <img src="https://mintcdn.com/detrics-4688583d/zhuWz3v2lbFVKC5_/images/get-started-sheets/onboarding-sheet.png?fit=max&auto=format&n=zhuWz3v2lbFVKC5_&q=85&s=b6750c9cce76fdd0a2efa60bd64df1af" alt="Detrics Onboarding Sheet" width="1088" height="870" data-path="images/get-started-sheets/onboarding-sheet.png" />
    </Frame>
  </Step>

  <Step title="Complete Installation">
    Click the "Install" button in the pop-up that appears showing the app in
    Google Workspace Marketplace. You'll then need to go through the Google
    authorization flow to authorize Detrics to connect to your Google account.

    <Frame>
      <img src="https://mintcdn.com/detrics-4688583d/zhuWz3v2lbFVKC5_/images/get-started-sheets/install-addon-popup.png?fit=max&auto=format&n=zhuWz3v2lbFVKC5_&q=85&s=641e7cc5f9d7abd655eb8062402965b5" alt="Install Add-on Popup" width="1378" height="866" data-path="images/get-started-sheets/install-addon-popup.png" />
    </Frame>
  </Step>

  <Step title="Open Detrics Sidebar">
    Create a new tab in the onboarding sheet that was created for you and open the
    Detrics sidebar by going to **Extensions → Detrics → Launch Detrics**.

    <Frame>
      <img src="https://mintcdn.com/detrics-4688583d/zhuWz3v2lbFVKC5_/images/get-started-sheets/launch-sidebar.png?fit=max&auto=format&n=zhuWz3v2lbFVKC5_&q=85&s=cd8aa5c091584832db9e61a9a67ccbbc" alt="Open Detrics Sidebar" width="1165" height="867" data-path="images/get-started-sheets/launch-sidebar.png" />
    </Frame>
  </Step>

  <Step title="Connect Data Source">
    Select the data source you want to connect to Detrics and retrieve data from.
    You can choose from various platforms like Facebook Ads, Google Ads, Google
    Analytics 4, and more.

    <Frame>
      <img src="https://mintcdn.com/detrics-4688583d/zhuWz3v2lbFVKC5_/images/get-started-sheets/select-data-source.png?fit=max&auto=format&n=zhuWz3v2lbFVKC5_&q=85&s=4700b05cf6d1fe784556f69cf8ae84b1" alt="Select Data Source" width="1135" height="865" data-path="images/get-started-sheets/select-data-source.png" />
    </Frame>
  </Step>

  <Step title="Grant Access">
    Grant access to Detrics in order for Detrics to be able to retrieve data from
    your selected data source. Click the connect button to authorize Detrics to
    access your account data.

    <Frame>
      <img src="https://mintcdn.com/detrics-4688583d/zhuWz3v2lbFVKC5_/images/get-started-sheets/grant-access-data-source.png?fit=max&auto=format&n=zhuWz3v2lbFVKC5_&q=85&s=e7a34dc4ce2fb43145bc5332b2fff983" alt="Grant Access to Data Source" width="851" height="682" data-path="images/get-started-sheets/grant-access-data-source.png" />
    </Frame>
  </Step>

  <Step title="Select Account and Run Your First Query">
    Select the account you want to pull data from. You can search by name or ID
    for a quick search to find your specific account. Then select one of the
    suggested Queries to streamline the Query creation process. Data will appear
    on the sheet in no time.

    <Frame>
      <img src="https://mintcdn.com/detrics-4688583d/zhuWz3v2lbFVKC5_/images/get-started-sheets/select-account-onboarding.png?fit=max&auto=format&n=zhuWz3v2lbFVKC5_&q=85&s=c377ebd09884050946fdee827230e269" alt="Select Account Onboarding" width="1092" height="822" data-path="images/get-started-sheets/select-account-onboarding.png" />
    </Frame>
  </Step>
</Steps>

## Create Your First Query

<Steps>
  <Step title="Open Detrics sidebar">
    Open a new Google Sheets document ([click here to create
    one](https://sheets.new)), then go to **Extensions → Detrics → Launch
    Detrics**.

    <Frame>
      <img src="https://mintcdn.com/detrics-4688583d/zhuWz3v2lbFVKC5_/images/get-started-sheets/launch-sidebar.png?fit=max&auto=format&n=zhuWz3v2lbFVKC5_&q=85&s=cd8aa5c091584832db9e61a9a67ccbbc" alt="Open Detrics Sidebar" width="1165" height="867" data-path="images/get-started-sheets/launch-sidebar.png" />
    </Frame>
  </Step>

  <Step title="Connect a data source">
    <div id="connect-data-source" />

    Click "Connect Account" and select your first data source (e.g., Facebook
    (Meta) Ads, Google Ads).

    <Frame>
      <img src="https://mintcdn.com/detrics-4688583d/zhuWz3v2lbFVKC5_/images/connection-issues-facebook/step-4.2.png?fit=max&auto=format&n=zhuWz3v2lbFVKC5_&q=85&s=96c86a8d1d63fe040391471e101d17ef" alt="Connect Data Source" width="369" height="591" data-path="images/connection-issues-facebook/step-4.2.png" />
    </Frame>
  </Step>

  <Step title="Select Data Source">
    Choose the specific data source you want to connect from the available
    options.

    <Frame>
      <img src="https://mintcdn.com/detrics-4688583d/zhuWz3v2lbFVKC5_/images/connection-issues-facebook/step-5.png?fit=max&auto=format&n=zhuWz3v2lbFVKC5_&q=85&s=a4eeabaceb070dcada4ff33b89ae4cfa" alt="Select Data Source" width="339" height="800" data-path="images/connection-issues-facebook/step-5.png" />
    </Frame>
  </Step>

  <Step title="Start from Template">
    Select "Start from Template" and choose your desired data source. If your
    desired data source can't be found, you'll need to connect it by clicking
    "Connect Data Source".

    <Frame>
      <img src="https://mintcdn.com/detrics-4688583d/zhuWz3v2lbFVKC5_/images/get-started-sheets/start-from-template.png?fit=max&auto=format&n=zhuWz3v2lbFVKC5_&q=85&s=0672797081076d49ced83372bb47b7d9" alt="Start from Template" width="842" height="772" data-path="images/get-started-sheets/start-from-template.png" />
    </Frame>
  </Step>

  <Step title="Choose Desired Template">
    Choose between all the template options. Take a look at the name and
    description to understand what the template will download or what information
    the output will be.

    <Frame>
      <img src="https://mintcdn.com/detrics-4688583d/zhuWz3v2lbFVKC5_/images/get-started-sheets/choose-template.png?fit=max&auto=format&n=zhuWz3v2lbFVKC5_&q=85&s=18627fa45cdbd77fea536cc9d882f346" alt="Choose Template" width="920" height="768" data-path="images/get-started-sheets/choose-template.png" />
    </Frame>
  </Step>

  <Step title="Select Account and Execute Template">
    Input the account you want to use for the desired template. You can search by
    name or ID to find your account quickly. Click "Execute Template" and the data
    will be visible in the spreadsheet.

    <Frame>
      <img src="https://mintcdn.com/detrics-4688583d/zhuWz3v2lbFVKC5_/images/get-started-sheets/choose-account.png?fit=max&auto=format&n=zhuWz3v2lbFVKC5_&q=85&s=37b5d06862f21a8f7bb90ce1c0c84de7" alt="Choose Account" width="876" height="742" data-path="images/get-started-sheets/choose-account.png" />
    </Frame>
  </Step>

  <Step title="Schedule Updates">
    Activate the toggle to set up automatic refresh at 9 AM in your local timezone
    to keep your data up-to-date.

    <Frame>
      <img src="https://mintcdn.com/detrics-4688583d/zhuWz3v2lbFVKC5_/images/get-started-sheets/activate-toggle-automatic-refresh.png?fit=max&auto=format&n=zhuWz3v2lbFVKC5_&q=85&s=cc4cbb9fd8ea7964026059ff30ab4afc" alt="Activate Toggle Automatic Refresh" width="833" height="757" data-path="images/get-started-sheets/activate-toggle-automatic-refresh.png" />
    </Frame>
  </Step>

  <Step title="Next Steps">
    Now that you've created your first query, explore these powerful features to
    maximize your productivity:

    * **Customize query templates** - Learn how to modify templates to match your exact reporting needs. [Read the guide →](/data-destination/google-sheets/how-to-use-query-templates#customizing-templates)
    * **Copy queries across files instantly** - Save time by importing and exporting queries between spreadsheets with just a few clicks. [Learn how →](/data-destination/google-sheets/how-to-import-export-queries)
  </Step>
</Steps>

## Create Your First Google Sheets Report with Detrics

Now that you've got the basics down, let's dive into the good stuff!

Learn [how to create Google Sheets reports with Detrics](/data-destination/google-sheets/how-to-create-a-report) and discover time-saving tips, best practices, and hidden features that will help you build reports 10x faster. Master the techniques that make reporting actually enjoyable.

Happy reporting! 📊

## Troubleshooting

If things don't go as expected, visit the [Google Sheets Troubleshooting section](/data-destination/google-sheets/troubleshooting) for solutions to common issues and step-by-step guides.

<Tip>
  **Need help?** If errors persist after following these steps, please reach out
  to [support@detrics.io](mailto:support@detrics.io)
</Tip>