Two Minute Reports Logo
Try for freeLogin
Connectors

GoHighLevel

Connect GoHighLevel to Google Sheets or Google Data Studio

The GoHighLevel connector gets your GoHighLevel CRM data into Google Sheets and Google Data Studio. Use it to track your pipeline, revenue, and funnel metrics in a spreadsheet or a Google Data Studio report.

What you can report on

  • Contacts: created over time, sources, tags, and custom fields
  • Opportunities and pipelines: stage, status, and monetary value
  • Appointments and calendar events
  • Conversations and message activity
  • Invoices, orders, transactions, and subscriptions
  • Form and survey submissions
  • Tasks: total, pending, and completed
  • Workflows and sub-account users

Prerequisites

  • A GoHighLevel account with at least one sub-account (location) you want to report on
  • Admin access to that sub-account

How to create a connection

Two Minute Reports offers two ways to connect GoHighLevel. Either one gives you a working connection, so pick whichever suits you:

  • Public app: authorize Two Minute Reports inside GoHighLevel and choose the sub-accounts to install it on. The installed sub-accounts are then listed for you to enable.
  • Private Integration Token: paste a token you generate yourself, along with the Location ID of a single sub-account.
A Public app connection can cover multiple sub-accounts at once. A Private Integration Token connection maps to one sub-account, so you need one connection for each sub-account.

Connect with the public app

  1. In the Hub, open Connections & accounts.
  2. Select Create connection.
  3. Select GoHighLevel in the connector list.
  4. Select Next.

  1. In Name the connection, enter a name.
  2. In Select connection type, select Public app.
  3. Select Connect with GoHighLevel.

  1. Sign in to GoHighLevel if it asks you to. Then select Install.
  2. In Select Sub-Account, select the sub-accounts you want to report on, or use Select all.
  3. Keep Enable Automatic Future Installation selected, so sub-accounts you create later are added for you. Then select Continue.

GoHighLevel returns you to Two Minute Reports, where the installed sub-accounts (locations) are listed for you to enable.

Connect with a Private Integration Token

Step 1: Get your Location ID (Sub-account ID)

  1. Sign in to GoHighLevel and switch to the sub-account you want to report on.
  2. In the left sidebar, go to Settings.
  3. Open Business Profile.
  4. Under General Information, copy the Location ID.

Step 2: Create a Private Integration Token

  1. In the same sub-account, go to Settings › Private Integrations.
  2. Select Create new integration.
  3. Enter a name (for example, Two Minute Reports) and an optional description.
  4. In the Scopes dropdown, select all available scopes.
  5. Select Create, then copy the generated token.

For more detail, see GoHighLevel's own guide: Private Integrations: everything you need to know.

Select every scope, otherwise the matching data won't be returned. The token is shown only once, so copy it before closing the dialog. To change scopes or replace a lost token, create a new Private Integration.

Step 3: Create the connection

  1. In the Hub, open Connections & accounts.
  2. Select Create connection.
  3. Select GoHighLevel in the connector list.
  4. Select Next.

  1. In Name the connection, enter a name.
  2. In Select connection type, select Private Integration Token.
  3. In Private Integration Token, paste the token from Step 2.
  4. In Location ID (sub-account ID), paste the Location ID from Step 1.
  5. Select Test and save.

Enable your accounts

After you create a connection, enable the sub-accounts you want to report on. Then select Done.

Only enabled accounts fetch data, and only enabled accounts count toward your plan. You can enable or disable accounts at any time on the Connections & accounts page.

How to get GoHighLevel data into Google Sheets or Google Data Studio

To get GoHighLevel data into Google Sheets:

  1. In the Two Minute Reports sidebar, open Data Queries.
  2. Select Add.
  3. Select the sub-accounts you want to report on. You can select more than one.
  4. Select your metrics and dimensions.
  5. Select the date range.
  6. Set sorting and filters if you need them.
  7. Select Run query. Two Minute Reports adds the data to your sheet.

Good to know

  • Data freshness: There's no provider reporting delay. Current-day records are included.
  • Snapshot data: Resources without dates (such as locations, pipelines, users, calendars, tasks, forms, surveys, workflows, and tags) can't be grouped by a date dimension. Remove the date field from those queries if you see an error.

Troubleshooting

  • A sub-account is missing after you install the public app: run the public app flow again and select the sub-account you need. Enable Automatic Future Installation covers sub-accounts you create later.
  • "Test and save" fails: check that the Location ID belongs to the same sub-account where the token was generated, and that the token was copied in full with no trailing spaces.
  • Some resources return no data: the token is most likely missing scopes. Create a new Private Integration with all scopes selected and update the connection.
  • Token no longer works: if the Private Integration was deleted or regenerated in GoHighLevel, edit the connection and paste the new token.

If you need help, contact [email protected].

Firebase Cloud Firestore

Connect Firebase Cloud Firestore to Google Sheets or Google Data Studio

Google Ads

Connect Google Ads to Google Sheets or Google Data Studio

Copyright © 2026