Intercom
Freshsales Contacts8 fieldsHow to import Intercom data into Freshsales
Intercom uses a single 'Name' field instead of separate first and last names. This template splits it into first_name and last_name, then maps email, phone, company, title, and city to Freshsales's snake_case fields. Freshsales requires last_name on every contact. A single-word name goes to First Name and leaves Last Name empty, so those rows will need a last name added before import.
Field-by-field mapping
This is the complete column mapping from Intercom to Freshsales. The left column is the header in your CSV export. The right column is the Freshsales field it should map to.
Before you start
This template's destination has a required field that needs attention before upload. You can still use this template. The steps below tell you what to add and where.
- Last Namelast_name
Freshsales requires Last Name on every contact. Intercom contact exports often ship a single Name column the template splits on the last space, so a single-word name leaves Last Name blank.
What to do. Scan your CSV for single-word entries in the Name column before uploading and add a last name where possible, or remove those rows.
| Intercom column | Freshsales field | |
|---|---|---|
| Name | First Namefirst_name Intercom's contacts export ships the full name in a single Name column. The first space-separated word is taken as the first name. TransformSplit on first space | |
| Name | Last Name*last_name Freshsales requires Last Name. The rest of the Name after the first space is taken. A single-word name leaves Last Name empty, so the row will fail to import. Scan your CSV for single-word names before running and add a last name where possible. TransformSplit on first space | |
| Emailemail TransformLowercased and trimmed | ||
| Phone | Work Numberwork_number Freshsales splits phone into Work and Mobile. Intercom only exports one phone column, so we map it to Work by default. TransformStandardized to international format (+1, +44, etc.) | |
| Company name | Company Namecompany_name | |
| Job title | Job Titlejob_title | |
| City | Citycity | |
| Country | Countrycountry |
Required by Freshsales.
Columns we don't use
Your Intercom export includes 2 columns this template doesn't map. Each one below explains why, plus the workaround if you want the data in Freshsales.
- Created at
Freshsales sets the contact's Created Time on import. The Intercom signup timestamp doesn't carry over.
If you need it. Add a custom date field on the Freshsales Contact called Intercom Created, then re-run this template to map Created at.
- Last seen
Freshsales doesn't have a 'last seen' field for product activity by default.
If you need it. Add a custom date field on the Freshsales Contact called Last Active, then re-run this template to map Last seen.
Formatting and cleanup
Intercom exports rarely match the format Freshsales expects. Fix these before you import.
- 1.Splits Intercom's single Name field into first_name and last_name (e.g. 'Jane Smith' becomes 'Jane' + 'Smith')
- 2.Lowercases and trims email addresses
- 3.Standardizes phone numbers to international format (+1, +44, etc.)
- 4.Renames Intercom columns to Freshsales's snake_case API names
- 5.Maps Phone to Freshsales's work_number field by default
Or skip the manual work
Operelio runs this cleanup and mapping for you. Upload your Intercom export and download a clean, import-ready file for Freshsales.
Intercom to Freshsales FAQ
How do I export contacts from Intercom?
In Intercom, open Contacts, filter to the segment you want, click the export icon at the top-right, and choose CSV.
How does the Name column split?
Intercom's contacts export ships the full name in one Name column. The template splits it into First Name and Last Name on the first space. A single-word name goes to First Name and leaves Last Name empty. Freshsales requires Last Name, so rows with single-word names will fail to import. Scan your CSV for single-word names before running and add a last name where possible.
Why does Phone go to work_number?
Freshsales splits phone numbers into Work and Mobile. Intercom only exports one phone column, so we default to work_number. Remap to mobile_number after upload if your Intercom phone column is consistently mobile numbers.
Will this create duplicate contacts in Freshsales?
Freshsales uses email as the unique identifier on contacts. Contacts with matching emails update the existing record. New emails create new contacts.
What about Intercom conversations and tags?
This template handles contact attributes only. Conversation history, tags, and custom attributes don't carry over to Freshsales by default. They require separate exports and custom field mapping.
