Intercom to Google Sheets integration
Live Export keeps a copy of your Intercom conversations, contacts, companies, and Help Center articles in Google Sheets, one tab per table. It runs on a schedule and never writes to Intercom.
What you can do with Intercom and Google Sheets
Count each week's conversations by tag
Copy Conversations into a tab, with each one's state, tags, and the time it was opened. A summary tab of COUNTIFS formulas tallies every tag by week, so Monday's review shows which topics are growing while there's still time to write the article or fix the bug.
Rank accounts by spend and seats
Copy Companies, with each one's plan, user count, and monthly spend, plus the custom attributes your product sends to Intercom. Sort by spend, add a column naming each account's owner, and the success team reviews its book of business from one tab. Intercom lists only companies with at least one user or lead, so those are the ones the tab holds.
Follow up with leads who went quiet
Copy Contacts, with each person's role, when they were created and last seen, and the custom attributes you track. Filter the tab to leads who haven't been seen in two weeks, and sales works the list from the sheet, keeping notes in a column of its own.
Find articles due for a review
Copy Articles and Collections, then sort the articles by when they were last updated. Whoever owns the Help Center assigns the oldest published ones for review in a column beside the copy, and a draft that goes live shows as published after the next run.
Everything it copies
Each card is a Intercom table Live Export keeps a copy of in Google Sheets.
-
Conversations
Into Google Sheets
-
Contacts
Into Google Sheets
-
Companies
Into Google Sheets
-
Articles
Into Google Sheets
-
Collections
Into Google Sheets
How to export Intercom to Google Sheets
Step 1: Create an Intercom access token
In Intercom's Developer Hub, open or create an app for your workspace, and copy its access token from Configure > Authentication. If you'll copy Contacts or Companies, give the app the "Read and list users and companies" permission. The token reaches only the conversations its teammate can see.
Step 2: Connect Intercom
In Whalesync, start a new Live Export. On the Connect step, choose Intercom as the source and paste the access token.
Step 3: Connect Google Sheets
Choose Google Sheets as the destination and sign in with Google. Pick New spreadsheet, or paste the URL of one you already use. Whalesync adds a new tab for each Intercom table and never writes into the tabs already there.
Step 4: Choose the tables and turn it on
On Choose data, pick the tables, such as Conversations and Contacts, and the fields to copy. Contact and company custom attributes are listed as fields of their own. On Activate, set a schedule, up to the fastest your plan allows, or leave it off and run the export by hand, then click Run first export.
Step 5: Let the first copy finish
The first run copies every conversation in the workspace, fetching each one in turn, so a large inbox can take a few hours. Later runs read everything again and write only what changed. Leave column A, the ID column, as it is, and build your counts and charts on tabs of your own that read from the copy.
3 ways to connect Intercom and Google Sheets
-
Intercom's data exports
Best when you need full transcripts or Intercom's reporting datasets, and can work from files or a storage bucket.
-
Zapier
Best when you want a row for each new event, such as a new conversation or a new rating.
- Triggers include New Conversation, New Closed Conversation, and Updated Contact
- No trigger fires when a conversation is assigned or otherwise updated
- Each event adds a row, so keeping a row current takes a lookup step and an update step
-
Whalesync
Best when you want conversations, contacts, and companies current in one spreadsheet, without building a Zap per event.
- Five Intercom tables, each in a tab of its own
- Custom attributes on contacts and companies become columns
- Never writes to Intercom, and a column you add stays put
Intercom's data exports and Zapier checked against their own pages in November 2026.
Frequently asked questions
How do I export Intercom conversations to Google Sheets?
Set up a Live Export with Intercom as the source and Google Sheets as the destination, and pick Conversations. Each conversation becomes a row with its state, priority, tags, created and updated times, when it started waiting for a reply, and its first message's subject, body, and author.
Does it copy conversation transcripts?
No. Replies and notes aren't copied, and neither are ratings, response-time statistics, or conversation custom attributes. For whole transcripts, Intercom's own export to S3 or Google Cloud Storage is the route.
How often does the sheet update?
On the schedule you set: daily, hourly, or every 10 minutes, depending on your plan, and Run now works any time. Each run reads your Intercom data again and writes only what changed, so a deleted conversation or contact leaves the copy too.
Can I change Intercom data from the sheet?
No. Nothing in the sheet goes back to Intercom. A value typed over a copied cell is replaced on the next run, and columns you add beside the copy, such as notes or an owner, are left alone.
What do I need on the Intercom side?
An access token from an app in Intercom's Developer Hub. To copy Contacts and Companies, the app needs the "Read and list users and companies" permission. The token reaches only the conversations its teammate can see.
Does the sheet show who a conversation is assigned to?
As an ID, not a name. The teammate and team a conversation is assigned to arrive as Intercom IDs, and teammates and teams aren't copied, so a small lookup tab of your own can turn the IDs into names.
Other apps to connect
-
Jira
Project Management
Google Sheets
SpreadsheetView item -
Klaviyo
Email
Google Sheets
SpreadsheetView item -
Notion
Spreadsheet
Google Sheets
SpreadsheetView item -
Pipedrive
CRM
Google Sheets
SpreadsheetView item -
QuickBooks
Finance
Google Sheets
SpreadsheetView item -
Salesforce
CRM
Google Sheets
SpreadsheetView item
Connect your tools in minutes
