Google Contacts
Pipedrive Contacts6 fieldsHow to import Google Contacts data into Pipedrive
Google Contacts exports use verbose column names like 'E-mail 1 - Value' and 'Organization 1 - Name'. This template renames them, combines Given Name and Family Name into Pipedrive's single Name field, matches Organization to a Pipedrive org, and maps email, phone, title, and the per-contact Notes column. Google's second email, second phone, full address block, and Group Membership don't have a default Pipedrive home. The section below explains what to do with each one if you need it.
Field-by-field mapping
This is the complete column mapping from Google Contacts to Pipedrive. The left column is the header in your CSV export. The right column is the Pipedrive field it should map to.
| Google Contacts column | Pipedrive field | |
|---|---|---|
| Given Name + Family Name | Name*name Pipedrive uses a single Name field, so we combine the two Google columns into one. TransformGiven Name and Family Name combined with a space | |
| E-mail 1 - Value | Emailemail TransformLowercased and trimmed | |
| Phone 1 - Value | Phonephone TransformStandardized to international format (+1, +44, etc.) | |
| Organization 1 - Name | Organizationorg_name Matched to an existing Pipedrive organization, or a new one is created. | |
| Organization 1 - Title | Job Titlejob_title | |
| Notes | Notesnotes Google's per-contact notes land in Pipedrive's contact Notes field as a single text value. The free text is preserved verbatim. |
Required by Pipedrive.
Columns we don't use
Your Google Contacts export includes 10 columns this template doesn't map. Each one below explains why, plus the workaround if you want the data in Pipedrive.
- E-mail 2 - Value, Phone 2 - Value
Pipedrive contacts have a single primary email and phone field on the standard layout. The first email and phone map to them; the second pair doesn't have a default home.
If you need it. Add custom email and phone fields on the Pipedrive contact called Secondary Email and Mobile, then re-run this template to map them.
- Address 1 - Street, City, Region, Postal Code, Country
Pipedrive contacts don't store address fields by default. Addresses live on organizations.
If you need it. If you need the address on the contact, add custom address fields in Pipedrive and re-run this template. Otherwise let the organization address handle it.
- Website 1 - Value
Pipedrive doesn't have a Website field on contacts. Websites typically live on the organization record.
If you need it. Update the matching Pipedrive organization's website after import, or add a custom URL field on the Pipedrive contact called Website.
- Group Membership
Google contact labels and groups don't translate one-to-one with Pipedrive. Pipedrive uses Filters and Labels instead.
If you need it. After import, build Pipedrive filters matching your Google labels, or use Pipedrive label colors to mark each batch.
- Birthday
Birthday doesn't have a default Pipedrive contact field.
If you need it. Add a custom date field on the Pipedrive contact called Birthday, then re-run this template to map it.
Formatting and cleanup
Google Contacts exports rarely match the format Pipedrive expects. Fix these before you import.
- 1.Combines Given Name and Family Name into Pipedrive's single Name field
- 2.Lowercases and trims email addresses
- 3.Standardizes phone numbers to international format (+1, +44, etc.)
- 4.Renames verbose Google column headers to Pipedrive's lowercase field names
- 5.Matches Organization 1 - Name to an existing Pipedrive organization, or creates a new one
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 Pipedrive.
Google Contacts to Pipedrive 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.
Why do you combine Given Name and Family Name?
Pipedrive contacts use a single Name field. The template combines the two Google columns with a space so each contact record displays correctly.
What if a contact has multiple phone numbers or emails?
Google exports each phone and email in numbered columns. This template maps Phone 1 and E-mail 1. See 'Columns we don't use' below for the second pair.
How is Organization handled?
Organization names match against existing Pipedrive organizations. If no match exists, the template creates a new organization and links the contact to it.
Will this create duplicate contacts in Pipedrive?
Pipedrive's import dedupes on Name plus one of email, phone, or organization. A Google contact matches an existing Pipedrive contact when the name and either email, phone, or organization all align. Contacts whose name spelling differs ('Jon' vs 'Jonathan') create a new contact even when the email matches.
