With Sheetgo, you can integrate Intercom directly into Google Sheets to automatically import data such as conversations, contacts, messages, or articles. This integration helps sales, marketing, and customer success teams create dynamic dashboards and performance reports based on live Intercom data—without the need for manual exports or coding. It enables better customer insights and automated reporting.
Prerequisites
- A verified Intercom account with API access permissions.
- An Intercom Access Token (Bearer Token).
- Access to the Intercom REST API documentation: https://developers.intercom.com/docs/references/rest-api.
- A Sheetgo account linked to the same email address as your Intercom account.
Step 1: Identify the Required API Endpoint
Visit the Intercom REST API documentation (linked above) to identify the endpoint for the data you wish to retrieve. For example: https://api.intercom.io/articles to fetch all articles, or https://api.intercom.io/conversations to fetch conversations. Review available endpoints under the 'API Reference' section to determine which data (articles, users, contacts, conversations) you want to import into Google Sheets.
Step 2: Generate API Credentials
Log in to your Intercom account and navigate to the Developer Hub. From there, create a new app and generate an Access Token under the 'Authentication' section. Copy this token and store it safely, as it will be required for all API requests. This token authorizes your connection to Intercom when configuring Sheetgo.
Step 3: Open the Sheetgo API Connector
Log in to Sheetgo and open an existing workflow or create a new one. Click on Connect and choose API Request under Data Source. Then select HTTP Request as the method type. You’ll be prompted to enter the API URL and configure authentication and headers.
Step 4: Configure the API Request in Sheetgo
Open Sheetgo, create a new workflow, and choose HTTP Request as your data source. Enter the desired Intercom API endpoint (for example, to fetch conversations: https://api.intercom.io/conversations). Then, paste the following JSON header configuration in the Headers field:
{
"Authorization": "Bearer YOUR_INTERCOM_ACCESS_TOKEN",
"Intercom-Version": "2.11",
"Accept": "application/json",
"@pagination": {
"type": "cursor",
"cursor_param": "starting_after",
"next_cursor_key": "pages.next.starting_after"
}
}This header includes the authorization token and defines cursor-based pagination parameters, allowing Sheetgo to automatically retrieve multiple pages of data from Intercom’s API responses.
Step 5: Choose the Destination Spreadsheet
Next, select or create a Google Sheet where your Intercom data will be imported. Configure how each record field (e.g., conversation ID, user ID, subject, date created) will appear in the sheet. You can choose to append new data or overwrite existing data based on your reporting needs.
Step 6: Execute the Sheetgo Connection
Click Run to execute your connection. Sheetgo will send a GET request to Intercom and import your selected data into the Google Sheet. Once successful, schedule automated refreshes (hourly, daily, or weekly) to keep your Intercom data synced in real time and maintain accurate customer engagement insights across your teams.