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
• Part 1: Get your Access Token
• Part 2: Pull Drift Data into Sheets
• Part 3: API Documentation

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
   
3. Under Display Information, optionally give your app a name, description, and icon.
   
   
4. Navigate to the OAuth & Scopes page, scroll to the bottom, and select the scopes (permissions) you'd like to have access to.
   
5. Navigate to the Installing to Drift page and click Install App to Drift.
   
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.
   
   

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