Search API Connector Documentation

Print

Import Drift Data to Google Sheets

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

Contents

Before You Begin

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

Part 1: Get Your Access Token

  1. Log into your Drift account and navigate to https://dev.drift.com/
  2. Click the Create New App link
    drift-createnewapp
  3. Under Display Information, optionally give your app a name, description, and icon.
    drift-display
  4. Navigate to the OAuth & Scopes page, scroll to the bottom, and select the scopes (permissions) you'd like to have access to.
    drift-scopes
  5. Navigate to the Installing to Drift page and click Install App to Drift.
    drift-install
  6. You'll now be presented with a non-expiring OAuth Access token. Copy this and keep it handy as we'll use it shortly.
    drift-token

Part 2: Get Drift Data in Sheets

You can create a request using any of the endpoints and parameters described in Drift's documentation. For this example we'll get a list of your Drift users.

  • Application: Custom
  • Method: GET
  • Request URL: https://driftapi.com/users/list
  • Headers
    • Authorization: Bearer your_token

Part 3: API Documentation

Official documentation: https://devdocs.drift.com/docs

Leave a Comment

Jump To