Intercom
+
Google Sheets
+
Microsoft Excel

Intercom in your spreadsheet

Import live, refreshable data from your Intercom account in Microsoft Excel and Google Sheets.

Import Intercom data in your spreadsheet

This collection of Intercom spreadsheet functions enables you to collect or analyze data from your Intercom account directly from your spreadsheet. For example, pull in on-demand, refreshable extract lists from Intercom. Or, enrich existing data in your spreadsheet with lookups from Intercom.

Learn more about Intercom spreadsheet functions and syntax here.

Getting Started

Flex.io makes it easy to create, use and share custom spreadsheet functions that import data from services you know and love. Click on the button below to use the Intercom function collection with Microsoft Excel or Google Sheets. Please note that you'll need an Intercom account to use this integration.

Need Help?

Have questions? Need help with installation? Need other Intercom functions for Microsoft Excel or Google Sheets? Chat with us; we're happy to help!

Functions and Syntax

This integration for Microsoft Excel or Google Sheets includes the following functions:

Intercom Enrich Users

Returns profile information of an intercom user based on email address

Syntax

=FLEX("YOUR_TEAM_NAME/intercom-enrich-users", email, [properties])

Parameters

Property Type Description Required
email string User email address used in Intercom true
properties array The properties to return (defaults to 'name'). See "Notes" for a listing of the available properties. false

Sample Usage

=FLEX("YOUR_TEAM_NAME/intercom-enrich-users", "bbaggins@shire.com")
=FLEX("YOUR_TEAM_NAME/intercom-enrich-users", "bbaggins@shire.com", "user_id, name, phone")
=FLEX("YOUR_TEAM_NAME/intercom-enrich-users", $A2, B$1:D$1)

Notes

The following properties are allowed:

  • user_id: the user id for the user
  • email: the email for the user
  • phone: the phone number for the user
  • name: the full name for the user
  • pseudonym: the pseudonym used if the user was previously list as an Intercom lead
  • referrer: the url of the page the user was last on
  • created_at: the time the user was added to Intercom
  • signed_up_at: the time the user signed up
  • updated_at: the time the user was last updated
  • last_request_at: the time the user was last recorded as making a request
  • session_count: the number of sessions the user is recorded as having made
  • location_postal: the postal code for the user location
  • location_city: the city for the user location
  • location_region: the region for the user location
  • location_country: the country for the user location
  • location_country_code: the country code for the user location
  • location_continent_code: the continent code for the user location
  • location_timezone: the timezone for the user location

Intercom List Events

Returns events for a given user email

Syntax

=FLEX("YOUR_TEAM_NAME/intercom-list-events", email, [properties])

Parameters

Property Type Description Required
email string User email address used in Intercom true
properties array The properties to return (defaults to all properties). See "Notes" for a listing of the available properties. false

Sample Usage

=FLEX("YOUR_TEAM_NAME/intercom-list-events", "bbaggins@shire.com")
=FLEX("YOUR_TEAM_NAME/intercom-list-events", "bbaggins@shire.com", "event_name, created_at")
=FLEX("YOUR_TEAM_NAME/intercom-list-events", $A2, B$1:C$1)

Notes

The following properties are allowed:

  • user_id: the user id of the user associated with the event
  • email: the email of the user associated with the event
  • event_name: the name of the event that occurred
  • created_at: the time the event occurred

Intercom List Signups

Returns a list of the most recently created user profiles

Syntax

=FLEX("YOUR_TEAM_NAME/intercom-list-signups", days, [properties])

Parameters

Property Type Description Required
days number Number of days to search for most recently created profiles true
properties array The properties to return (defaults to all properties). See "Notes" for a listing of the available properties. false

Sample Usage

=FLEX("YOUR_TEAM_NAME/intercom-list-signups", 10)
=FLEX("YOUR_TEAM_NAME/intercom-list-signups", 20, "user_id, email, name")
=FLEX("YOUR_TEAM_NAME/intercom-list-signups", 20, B$1:D$1)

Notes

The following properties are allowed:

  • user_id: the user id for the user
  • email: the email for the user
  • phone: the phone number for the user
  • name: the full name for the user
  • pseudonym: the pseudonym used if the user was previously list as an Intercom lead
  • referrer: the url of the page the user was last on
  • created_at: the time the user was added to Intercom
  • signed_up_at: the time the user signed up
  • updated_at: the time the user was last updated
  • last_request_at: the time the user was last recorded as making a request
  • session_count: the number of sessions the user is recorded as having made
  • location_postal: the postal code for the user location
  • location_city: the city for the user location
  • location_region: the region for the user location
  • location_country: the country for the user location
  • location_country_code: the country code for the user location
  • location_continent_code: the continent code for the user location
  • location_timezone: the timezone for the user location

Use Intercom in your spreadsheet now!