Import Intercom Data to Google Sheets

Import Intercom Data to Google Sheets

Last Updated On October 09, 2019

Intercom is an online customer communication platform. In this guide, we’ll walk through how to pull data from the Intercom API directly into Google Sheets, using the free API Connector add-on. We’ll first get an API key from Intercom, and then set up a request to pull in user data to your spreadsheet.

PART 1: GET YOUR INTERCOM API KEY

  1. While logged into your Intercom account, navigate to the Developer Hub and click New App.
    intercom-img1
  2. A modal will appear, prompting you for details about your app. You can name it anything, but for this example we’ll name it ‘Google Sheets’. Leave the ‘internal integration’ radio button selected, and click Create App.
    intercom-img2
  3. You’ll now see a page containing your Access Token. Copy this to your clipboard as you’ll need it in a moment. That’s it, you now have access to the Intercom API!
    intercom-img3

PART 2: CREATE YOUR API REQUEST URL

We’ll follow the Intercom documentation to access a list of users.

  • API root: https://api.intercom.io
  • Endpoint: /users

Putting it together, we get the full API Request URL:
https://api.intercom.io/users

PART 3: ENTER YOUR VALUES INTO API CONNECTOR

We can now enter our values into API Connector and import Intercom API data into Google Sheets.

  1. Open up Google Sheets and click Add-ons > API Connector > Create New API Request.
  2. In the Create Request interface, enter the Request URL we just created
    intercom-img4

  3. Under Headers enter enter a key-value pair like this:
    Authorization Bearer {API Key}
    Accept application/json

    Replace {Api Key} with the value provided above in part 1, step 3.
    intercom-img5

  4. Create a new tab. You can call it whatever you like, but here we’ll call it ‘Intercom_Users’. While still in that tab, click ‘Set’ to use that tab as your data destination.
  5. Name your request. Again we’ll call it ‘Intercom_Users’
  6. Click Run and a moment later you’ll see a list of your users in your Google Sheet:
    intercom-img6

PART 4: NOTES AND EXPANSIONS

  1. Experiment with endpoints and query strings as described in the documentation to see other types of Intercom data. For example, you can see a list of companies by entering https://api.intercom.io/companies, and a list of teams by entering https://api.intercom.io/teams.
  2. Some Intercom endpoints will return a limited set of data per page. To retrieve additional data, you’ll need to follow the pagination links in the response, as described here.

Comments:0

Leave a Reply

Your email address will not be published.