Already have an account? Sign in

Intercom (v2)

Last updated: 9/15/2026

Intercom extraction is supported by Stitch
This integration is powered by Singer's Intercom tap and certified by Stitch. Check out and contribute to the repo on GitHub.

For support, contact Support.

Intercom integration summary

Stitch’s Intercom integration replicates data using the Intercom API (V2.5). Refer to the Schema section for a list of objects available for replication.

Intercom feature snapshot

A high-level look at Stitch's Intercom (v2) integration, including release status, useful links, and the features supported in Stitch.

STITCH
Release status	Released on December 13, 2022	Supported by	Stitch
Stitch plan	Standard	API availability	Available
Singer GitHub repository	singer-io/tap-intercom
REPLICATION SETTINGS
Anchor Scheduling	Supported	Advanced Scheduling	Supported
Table-level reset	Unsupported	Configurable Replication Methods	Unsupported
DATA SELECTION
Table selection	Supported	Column selection	Supported
Select all	Supported
TRANSPARENCY
Extraction Logs	Supported	Loading Reports	Supported

Connecting Intercom

Step 1: Add Intercom as a Stitch data source

Sign into your Stitch account.
On the Stitch Dashboard page, click the Add Integration button.
Click the Intercom icon.
Enter a name for the integration. This is the name that will display on the Stitch Dashboard for the integration; it’ll also be used to create the schema in your destination.

For example, the name “Stitch Intercom” would create a schema called stitch_intercom in the destination. Note: Schema names cannot be changed after you save the integration.

Step 2: Define the historical replication start date

The Sync Historical Data setting defines the starting date for your Intercom integration. This means that data equal to or newer than this date will be replicated to your data warehouse.

Change this setting if you want to replicate data beyond Intercom’s default setting of 1 year. For a detailed look at historical replication jobs, check out the Syncing Historical SaaS Data guide.

Step 3: Create a replication schedule

Replication schedules affect the time Extraction begins, not the time to data loaded. Refer to the Replication Scheduling documentation for more information.

In the Replication Frequency section, you’ll create the integration’s replication schedule. An integration’s replication schedule determines how often Stitch runs a replication job, and the time that job begins.

Intercom integrations support the following replication scheduling methods:

Replication Frequency
Anchor Scheduling
Advanced Scheduling using Cron (Advanced or Premium plans only)

To keep your row usage low, consider setting the integration to replicate less frequently. See the Understanding and Reducing Your Row Usage guide for tips on reducing your usage.

Step 4: Authorize Stitch to access Intercom

Lastly, you’ll be directed to Intercom’s website to complete the setup.

List of permissions requested by Stitch to access Intercom

If you aren’t already logged into Intercom, you’ll be prompted to do so.
Next, a screen requesting access to Intercom will display. Note: Stitch will only ever read your data.
Click Connect.
After the authorization process successfully completes, you’ll be redirected back to Stitch.
Click All Done.

Step 5: Set objects to replicate

Is an object missing or not replicating? Verify that the object meets the requirements for selection and replication.

The last step is to select the tables and columns you want to replicate. Learn about the available tables for this integration.

Note: If a replication job is currently in progress, new selections won’t be used until the next job starts.

For Intercom integrations, you can select:

Individual tables and columns
All tables and columns

Click the tabs to view instructions for each selection method.

In the integration’s Tables to Replicate tab, locate a table you want to replicate.
To track a table, click the checkbox next to the table’s name. A blue checkmark means the table is set to replicate.
To track a column, click the checkbox next to the column’s name. A blue checkmark means the column is set to replicate.
Repeat this process for all the tables and columns you want to replicate.
When finished, click the Finalize Your Selections button at the bottom of the screen to save your selections.

Important: Using the Select All feature will overwrite any previous selections. However, selections aren’t final until Finalize Your Selections is clicked. Clicking Cancel will restore your previous selections. Refer to the Select All guide for more info about this feature.

Click into the integration from the Stitch Dashboard page.
Click the Tables to Replicate tab.
In the list of tables, click the box next to the Table Names column.
In the menu that displays, click Track all Tables and Fields:

The Track all Tables and Fields menu in the Tables to Replicate tab
Click the Finalize Your Selections button at the bottom of the page to save your data selections.

Initial and historical replication jobs

After you finish setting up Intercom, its Sync Status may show as Pending on either the Stitch Dashboard or in the Integration Details page.

For a new integration, a Pending status indicates that Stitch is in the process of scheduling the initial replication job for the integration. This may take some time to complete.

Initial replication jobs with Anchor Scheduling

If using Anchor Scheduling, an initial replication job may not kick off immediately. This depends on the selected Replication Frequency and Anchor Time. Refer to the Anchor Scheduling documentation for more information.

Free historical data loads

The first seven days of replication, beginning when data is first replicated, are free. Rows replicated from the new integration during this time won’t count towards your quota. Stitch offers this as a way of testing new integrations, measuring usage, and ensuring historical data volumes don’t quickly consume your quota.

Replication will continue after the seven days are over. If you’re no longer interested in this source, be sure to pause or delete the integration to prevent unwanted usage.

Intercom table reference

Schemas and versioning

Schemas and naming conventions can change from version to version, so we recommend verifying your integration’s version before continuing.

The schema and info displayed below is for version 2 of this integration.

This is the latest version of the Intercom integration.

Table and column names in your destination

Depending on your destination, table and column names may not appear as they are outlined below.

For example: Object names are lowercased in Redshift (CusTomERs > customers), while case is maintained in PostgreSQL destinations (CusTomERs > CusTomERs). Refer to the Loading Guide for your destination for more info.

admins

The admins table lists info about the admins in your Intercom account. An admin is a user, or teammate, in your Intercom account.

Replication Method

Full Table

Primary Key

Useful links

Intercom documentation

admins schema on GitHub

Intercom API method

admin_ids

ARRAY

avatar

OBJECT

image_url

STRING

away_mode_enabled

BOOLEAN

away_mode_reassign

BOOLEAN

email

STRING

has_inbox_seat

BOOLEAN

STRING

job_title

STRING

name

STRING

team_ids

ARRAY

type

STRING

companies

The companies table contains info about companies that use your Intercom product.

Custom attributes

If applicable, Stitch will replicate custom fields related to companies in Intercom.

Limitations

Intercom’s API limits the number of simultaneous requests a single Intercom app, or connection, can make to the endpoint. Stitch uses this endpoint to replicate company data. Currently, only one request can occur at a time.

If multiple connections exist and they attempt to use this endpoint at the same time, only the connection who made the request first will succeed.

This means that if Stitch attempts to extract data when another connection is using the endpoint, Extraction will fail and an error will surface in the Extraction Logs.

To prevent or minimize this issue, we recommend limiting the number of connections a single workspace has or scheduling extraction jobs in Stitch around your other connections’ usage.

Replication Method	Key-based Incremental
Primary Key	id
Replication Key	updated_at
Useful links	Intercom documentation companies schema on GitHub Intercom API method

company_id

STRING

created_at

DATE-TIME

custom_attributes

OBJECT

STRING

industry

STRING

last_request_at

DATE-TIME

monthly_spend

NUMBER

name

STRING

plan

OBJECT

STRING

name

STRING

type

STRING

remote_created_at

DATE-TIME

segments

ARRAY

STRING

session_count

INTEGER

size

INTEGER

tags

ARRAY

STRING

type

STRING

updated_at

DATE-TIME

user_count

INTEGER

website

STRING

company_attributes

The company_attributes lists data attributes for a specified company in your Intercom account.

Replication Method

Full Table

Primary Key

_sdc_record_hash

Useful links

Intercom documentation

company_attributes schema on GitHub

Intercom API method

_sdc_record_hash

STRING

admin_id

STRING

api_writable

BOOLEAN

archived

BOOLEAN

created_at

DATE-TIME

custom

BOOLEAN

data_type

STRING

description

STRING

full_name

STRING

INTEGER

label

STRING

model

STRING

name

STRING

options

ARRAY

type

STRING

ui_writable

BOOLEAN

updated_at

DATE-TIME

company_segments

The company_segments table contains information about company segments in your Intercom account.

Replication Method	Key-based Incremental
Primary Key	id
Replication Key	updated_at
Useful links	Intercom documentation company_segments schema on GitHub Intercom API method

count

INTEGER

created_at

DATE-TIME

STRING

name

STRING

person_type

STRING

type

STRING

updated_at

DATE-TIME

contact_attributes

The contact_attributes table contains information about contact attributes in your Intercom account.

Replication Method

Full Table

Primary Key

_sdc_record_hash

Useful links

Intercom documentation

contact_attributes schema on GitHub

Intercom API method

_sdc_record_hash

STRING

admin_id

STRING

api_writable

BOOLEAN

archived

BOOLEAN

created_at

DATE-TIME

custom

BOOLEAN

data_type

STRING

description

STRING

full_name

STRING

INTEGER

label

STRING

model

STRING

name

STRING

options

ARRAY

type

STRING

ui_writable

BOOLEAN

updated_at

DATE-TIME

contacts

The contacts table contains info about users and leads in your Intercom account.

Custom attributes

If applicable, Stitch will replicate custom fields related to contacts in Intercom.

Replication Method	Key-based Incremental
Primary Key	id
Replication Key	updated_at
Useful links	Intercom documentation contacts schema on GitHub Intercom API method

android_app_name

STRING

android_app_version

STRING

android_device

STRING

android_last_seen_at

DATE-TIME

android_os_version

STRING

android_sdk_version

STRING

avatar

STRING

browser

STRING

browser_language

STRING

browser_version

STRING

companies

ARRAY

STRING

type

STRING

url

STRING

created_at

DATE-TIME

custom_attributes

OBJECT

email

STRING

external_id

STRING

has_hard_bounced

BOOLEAN

STRING

ios_app_name

STRING

ios_app_version

STRING

ios_device

STRING

ios_last_seen_at

DATE-TIME

ios_os_version

STRING

ios_sdk_version

STRING

language_override

STRING

last_contacted_at

DATE-TIME

last_email_clicked_at

DATE-TIME

last_email_opened_at

DATE-TIME

last_replied_at

DATE-TIME

last_seen_at

DATE-TIME

location

OBJECT

city

STRING

continent_code

STRING

country

STRING

country_code

STRING

region

STRING

type

STRING

marked_email_as_spam

BOOLEAN

name

STRING

notes

OBJECT

data

ARRAY

STRING

type

STRING

url

STRING

has_more

BOOLEAN

total_count

INTEGER

type

STRING

url

STRING

owner_id

INTEGER

phone

STRING

role

STRING

signed_up_at

DATE-TIME

social_profiles

OBJECT

tags

ARRAY

STRING

type

STRING

unsubscribed_from_emails

BOOLEAN

updated_at

DATE-TIME

workspace_id

STRING

conversation_parts

The conversation_parts table lists the individual parts of conversations in your Intercom account.

Note: When this table is replicated, all conversation parts associated with an updated conversation will be replicated.

Replication Method	Key-based Incremental
Primary Key	id
Replication Key	updated_at
Useful links	Intercom documentation conversation_parts schema on GitHub Intercom API method

assigned_to

STRING

attachments

ARRAY

content_type

STRING

filesize

INTEGER

height

INTEGER

name

STRING

type

STRING

url

STRING

width

INTEGER

author

OBJECT

email

STRING

name

STRING

type

STRING

body

STRING

conversation_created_at

DATE-TIME

conversation_id

STRING

conversation_total_parts

INTEGER

conversation_updated_at

DATE-TIME

created_at

DATE-TIME

external_id

STRING

notified_at

DATE-TIME

part_type

STRING

redacted

BOOLEAN

type

STRING

updated_at

DATE-TIME

conversations

The conversations table contains info about user conversations in your Intercom account.

Replication Method	Key-based Incremental
Primary Key	id
Replication Key	updated_at
Useful links	Intercom documentation conversations schema on GitHub Intercom API method

admin_assignee_id

INTEGER

contacts

ARRAY

STRING

type

STRING

conversation_message

OBJECT

attachments

ARRAY

content_type

STRING

filesize

INTEGER

height

INTEGER

name

STRING

type

STRING

url

STRING

width

INTEGER

author

OBJECT

email

STRING

name

STRING

type

STRING

body

STRING

delivered_as

STRING

subject

STRING

type

STRING

url

STRING

conversation_rating

OBJECT

contact

OBJECT

STRING

type

STRING

created_at

DATE-TIME

customer

OBJECT

STRING

type

STRING

rating

INTEGER

remark

STRING

teammate

OBJECT

INTEGER

type

STRING

created_at

DATE-TIME

custom_attributes

OBJECT

customer_first_reply

OBJECT

created_at

DATE-TIME

type

STRING

url

STRING

customers

ARRAY

STRING

type

STRING

first_contact_reply

OBJECT

created_at

DATE-TIME

type

STRING

url

STRING

open

BOOLEAN

priority

STRING

read

BOOLEAN

sent_at

DATE-TIME

sla_applied

OBJECT

sla_name

STRING

sla_status

STRING

snoozed_until

DATE-TIME

source

OBJECT

attachments

ARRAY

author

OBJECT

email

STRING

name

STRING

type

STRING

body

STRING

delivered_as

STRING

redacted

BOOLEAN

subject

STRING

type

STRING

url

STRING

state

STRING

statistics

OBJECT

count_assignments

INTEGER

count_conversation_parts

INTEGER

count_reopens

INTEGER

first_admin_reply_at

DATE-TIME

first_assignment_at

DATE-TIME

first_close_at

DATE-TIME

first_contact_reply_at

DATE-TIME

last_admin_reply_at

DATE-TIME

last_assignment_admin_reply_at

DATE-TIME

last_assignment_at

DATE-TIME

last_close_at

DATE-TIME

last_closed_by

OBJECT

email

STRING

name

STRING

type

STRING

last_closed_by_id

INTEGER

last_contact_reply_at

DATE-TIME

median_time_to_reply

INTEGER

time_to_admin_reply

INTEGER

time_to_assignment

INTEGER

time_to_first_close

INTEGER

time_to_last_close

INTEGER

type

STRING

tags

ARRAY

applied_at

DATE-TIME

applied_by

OBJECT

STRING

type

STRING

name

STRING

type

STRING

team_assignee_id

INTEGER

teammates

OBJECT

admins

ARRAY

STRING

type

STRING

type

STRING

title

STRING

type

STRING

updated_at

DATE-TIME

user

OBJECT

STRING

type

STRING

waiting_since

DATE-TIME

segments

The segments table contains information about segments within your Intercom account.

Replication Method	Key-based Incremental
Primary Key	id
Replication Key	updated_at
Useful links	Intercom documentation segments schema on GitHub Intercom API method

count

INTEGER

created_at

DATE-TIME

STRING

name

STRING

person_type

STRING

type

STRING

updated_at

DATE-TIME

teams

The teams table contains information about teams in your Intercom account.

Replication Method

Full Table

Primary Key

Useful links

Intercom documentation

teams schema on GitHub

Intercom API method

admin_ids

ARRAY

STRING

name

STRING

type

STRING

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!

Leave your feedback here