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