How to Connect Intercom to Excel (4 Methods Compared)

The Problem With Getting Workbook Data In and Out of Intercom

You have an Excel workbook full of data — contact lists with plan tiers, support issue logs, company records after a pricing migration, call notes from the customer success team. You need it in Intercom. Or you need something out of Intercom and into the workbook. Either way, the gap between the two is wider than it appears.

Intercom is good at managing customer conversations, contacts, and lifecycle messaging. But moving data between it and a workbook is more work than it should be. The usual flow is: export to CSV from Intercom, open it in Excel, remap the headers, delete the columns you do not need, and start over when Intercom updates the export format.

Below are the four common ways teams handle this. Only the last one scales.

Method 1: CSV Export

The default for Excel users. Open Intercom, run your filter, download the CSV, open it in Excel, reformat the date columns (which always come out wrong), delete the columns you did not ask for, and save the file where your team can find it. Or run it the other direction — take rows from your workbook, clean them into a format Intercom's CSV import accepts, and upload.

A one-time pull of a few dozen records is annoying but manageable. What wears people down is the cadence: every week someone has to remember to re-export, re-clean, and re-paste. The tenth time you are reformatting the same date column, you start to understand why people build automations.

Method 2: Power Automate

Power Automate has Intercom connector options. You can wire up a scheduled flow that reads new rows in an Excel worksheet, calls the Intercom API, and writes results back.

A quick check before you invest time here — do you know what a connector action is? A trigger condition? Dynamic content mapping? If those terms are unfamiliar, this path has a steep ramp. You are better off skipping to Method 3 or 4.

For those who have built Power Automate flows before: the setup is workable. You authenticate to Intercom, pick your trigger, map fields from the Excel table to Intercom's required fields, and test with a live row. The wrinkle is getting every mapping right — Intercom's field names do not always match what you'd expect, and a single type mismatch will kill the run silently.

The structural problem is the same as any row-by-row automation.

Each row is a separate action call. If you are syncing 500 company records, that is 500 separate Intercom API calls. If row 312 fails because the company ID does not exist yet, you get a partial run with no clear audit trail of which rows succeeded.

You probably just need the companies synced. You probably have no interest in building and debugging a 500-step flow — and you should not have to. So you hand it to whoever manages your automation infrastructure, and now you are waiting while the data sits out of sync.

Adding filter logic, deduplication, or conditional field inclusion turns a simple flow into something that requires ongoing maintenance every time your workbook schema changes.

Method 3: The Previous Generation — Connector Add-Ons

Until recently, the best option for repeatable workbook-to-Intercom workflows was a category of Excel add-ons that let you configure column mappings and save them as templates. You selected your range, matched columns to Intercom fields, saved a config, and ran it.

That was a genuine improvement over manual CSV imports. Configs were reusable, output was consistent, and the team did not have to redo mappings from scratch each time.

But every decision was still on you: which columns, which fields, how to handle blanks, what schedule to run. The tool moved the data; the logic stayed with the operator. And when the workbook structure changed — a renamed column, a new attribute — the config broke and someone had to go back in and repair it.

This is the previous generation. It worked, but it asked a lot of the operator.

The Easy Way: Using SheetXAI in Excel

There is a different way entirely. SheetXAI is an AI agent that lives inside your Excel workbook. It reads the workbook, understands what you are looking at, and through its built-in Intercom integration it can push to or pull from Intercom for you. No template configuration, no automation glue, no reformatting data by hand. You just ask.

Example 1: Bulk-create Intercom contacts from a new-user workbook

Create an Intercom contact for every row in this workbook — email in column A, name in column B, company in column C, plan in column D — skip any row where column A is blank and write the new contact ID back to column E.

Every row becomes a contact. Blanks are skipped. Contact IDs land in column E.

Example 2: Export all open Intercom conversations assigned to a team into this workbook

Search Intercom for all open conversations assigned to team "Support" and write them to this workbook starting at row 2 — include conversation ID, contact email, subject, created date, and tags.

The pattern: instead of downloading a CSV and cleaning it first, you ask for the exact columns you need and where they should go. SheetXAI handles pagination and field selection inline.

Try It

Get the 7-day free trial of SheetXAI and open any Excel workbook with Intercom contact data or a list of issues to create — then ask it to push or pull. The Intercom integration is included in every SheetXAI plan.