Google Contacts
Freshsales Contacts12 fieldsHow to import Google Contacts data into Freshsales
Google Contacts exports use verbose column names like 'E-mail 1 - Value' and 'Organization 1 - Name'. This template renames them to Freshsales's snake_case fields and maps email, both phones, company, title, and the full address. Freshsales splits phone numbers into Work and Mobile, so Phone 1 goes to work_number and Phone 2 goes to mobile_number.
Field-by-field mapping
This is the complete column mapping from Google Contacts to Freshsales. The left column is the header in your CSV export. The right column is the Freshsales field it should map to.
| Google Contacts column | Freshsales field | |
|---|---|---|
| Given Name | First Namefirst_name | |
| Family Name | Last Name*last_name | |
| E-mail 1 - Value | Emailemail TransformLowercased and trimmed | |
| Phone 1 - Value | Work Numberwork_number TransformStandardized to international format (+1, +44, etc.) | |
| Phone 2 - Value | Mobile Numbermobile_number Google's second phone column is treated as mobile. If your second phone is consistently a different type, remap after upload. TransformStandardized to international format (+1, +44, etc.) | |
| Organization 1 - Name | Company Namecompany_name | |
| Organization 1 - Title | Job Titlejob_title | |
| Address 1 - Street | Addressaddress | |
| Address 1 - City | Citycity | |
| Address 1 - Region | Statestate | |
| Address 1 - Postal Code | Zip Codezipcode | |
| Address 1 - Country | Countrycountry |
Required by Freshsales.
Columns we don't use
Your Google Contacts export includes 5 columns this template doesn't map. Each one below explains why, plus the workaround if you want the data in Freshsales.
- E-mail 2 - Value
Freshsales contacts have a single primary email field. The first email maps to it; the second one doesn't have a default home.
If you need it. Add a custom email field on the Freshsales Contact called Secondary Email, then re-run this template to map it.
- Website 1 - Value
Freshsales doesn't have a Website field on contacts by default. Websites live on the Account record in Freshsales's data model.
If you need it. Update the matching Account record's website after import, or add a custom URL field on the Freshsales Contact called Website.
- Group Membership
Google contact labels and groups don't translate one-to-one with Freshsales. Freshsales uses custom fields and saved filters instead of labels.
If you need it. After import, build saved filters in Freshsales matching your Google labels, or add a custom multi-select field on the Contact for groups.
- Notes, Birthday
Freshsales stores notes as separate Note records attached to the contact, not as a field value. Birthday doesn't have a default Freshsales contact field.
If you need it. Add a custom multi-line text field on the Freshsales Contact called Imported Notes and a custom date field called Birthday, then re-run this template to map both.
Formatting and cleanup
Google Contacts exports rarely match the format Freshsales expects. Fix these before you import.
- 1.Lowercases and trims email addresses
- 2.Standardizes both phone numbers to international format (+1, +44, etc.)
- 3.Renames verbose Google column headers to Freshsales's snake_case field names
- 4.Maps Phone 1 to work_number and Phone 2 to mobile_number
- 5.Maps Google's Address 1 block to Freshsales's address, city, state, zipcode, country fields
Or skip the manual work
Operelio runs this cleanup and mapping for you. Upload your Google Contacts export and download a clean, import-ready file for Freshsales.
Google Contacts to Freshsales FAQ
How do I export contacts from Google?
Go to contacts.google.com, click 'Export' in the left sidebar, choose 'Google CSV' format, and download the file. Select Google CSV, not Outlook CSV.
What if a contact has multiple phone numbers or emails?
Google exports each phone and email in numbered columns. This template maps Phone 1 to work_number, Phone 2 to mobile_number, and E-mail 1 to email. See 'Columns we don't use' below for the second email.
Why does Family Name have a required asterisk?
Freshsales requires last_name on every contact. Most Google contacts have a Family Name, but personal contacts sometimes have only a Given Name. Add a placeholder like 'Unknown' in any blank Family Name cells before upload.
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.
Where do I import the CSV into Freshsales?
In Freshsales, go to Contacts, click Import, and upload the file Operelio produces. The import wizard matches the column headers to contact fields.
