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

Intercom is a popular customer service and messaging app that enables you to manage communication with leads from your website as well as users of your web service. This Intercom spreadsheet integration for Google Sheets and Microsoft Excel enables you to import data from your Intercom account, like contacts, recent signups and user events. This add-on will enable you to integrate on-demand, refreshable customer management data without leaving your spreadsheet.

For example, with this Excel and Google Sheets add-on you can:

  • Enrich a list of emails with Intercom profile information, like phone, location, signup date, and referrer.
  • Import user event data, based on an email address, including event name and timestamp.
  • Extract a list of recent signups in Intercom based on number of days, and return information like user id, email, phone number, name and referrer.

Click here to learn more about the specific syntax for each of the Intercom spreadsheet functions.

Demonstration

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 (default)
  • 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!