Search API Connector Documentation

Print

Import GoHighLevel Data to Google Sheets

In this guide, we’ll walk through how to pull data from the GoHighLevel API directly into Google Sheets, using the API Connector add-on.

We’ll first get an API key from GoHighLevel, and then set up a request to pull in metrics to your spreadsheet.

Contents

Before You Begin

Click here to install the API Connector add-on from the Google Marketplace.

Part 1: Get Your GoHighLevel API Token

  1. Log in to GoHighLevel and click Settings from the menu.
    gohighlevel-key
  2. Scroll down the page and you’ll see that an API token has been automatically created for you. Click to copy it to your clipboard. Congrats, you can now access the GoHighLevel API!

Part 2: Create Your API Request URL

For our first request, we’ll fetch your campaigns.

  • Base domain: https://rest.gohighlevel.com
  • Endpoint: /v1/campaigns/
  • Query parameters: ?status=published

Putting it all together, we get the full API Request URL:

https://rest.gohighlevel.com/v1/campaigns/?status=published

Part 3: Pull GoHighLevel API Data into Sheets

Now let’s get that data into Sheets.

  1. Open up Google Sheets and click Extensions > API Connector > Open.
  2. In the Create tab, enter the Request URL we just created
    gohighlevel-url
  3. We don’t need OAuth authentication, so leave that as None.
  4. Under Headers, enter Authorization as your Key, and Bearer YOUR_TOKEN as your Value, like this. Just substitute in the token you got from your company settings page.
    gohighlevel-headers
  5. Create a new tab, give it a name, and click Set current to use that tab as your data destination.
  6. Name your request and click Run. A moment later you’ll see your published campaigns populate your Google Sheet.

Part 4: More Example API URLs

You can check the documentation for the full list of available API requests, but if you just want to jump in, you can play around with the URLs you enter in the API URL path field. Try the following (one at a time):

https://rest.gohighlevel.com/v1/calendars/teams
https://rest.gohighlevel.com/v1/contacts
https://rest.gohighlevel.com/v1/locations
https://rest.gohighlevel.com/v1/pipelines

Part 5: Handle Pagination

  • Note GoHighLevel’s limits on the number of records returned on a response. By default, only 20 records will be returned unless you use the ‘startAfter’ and ‘startAfterId’ parameters as described in their documentation.
    gohighlevel-pagination-docs

  • With API Connector you can either run these request URLs manually or loop through them automatically with cursor pagination handling (paid feature), like this:
    • API URL: enter your request URL, including limit=100
    • Pagination type: next page URL
    • Next page path: meta.nextPageUrl
    • Run until: choose when to stop fetching data
      gohighlevel-pagination-nextpageurl

Part 6: API Documentation

Official API documentation: https://developers.gohighlevel.com/#intro

Previous Import GitHub Data to Google Sheets
Next Import Google Ads Data to Google Sheets

Leave a Comment

Table of Contents