Our simple 10-minute no-code setup Pipedrive-Google Sheets sync is designed for B2B companies that want to keep their data in sync between different apps.
How it works
Bi-directional contact sync. Make all contacts or a subset(s) available on either platform along with your custom contact, company and deal fields and keep them in sync going forward.
Comprehensive field Mapping. Sync any default or custom field two-way or in a single direction so you always have the right information available in any app. If any data conflicts arise, you can easily select the conflict winner.
Deduplication built-in. Outfunnel creates links based on the email address and we'll automatically cross-reference contacts to prevent duplicate contact entries. If a contact already exists we'll simply link it. If it doesn't we'll create a new contact.
Near instant data sync. Outfunnel syncs most data instantly and some within 2 hours.
Monitor sync status. Clear overview of the sync health which includes actionable error messages so you can fix them as they happen.
Historical sync. Sync all of your customer data, no matter when it was created. Outfunnel syncs not only new contacts but also existing ones.
Transparent pricing. Each contact that's part of the sync only counts once, regardless of how many updates get synced or to how many apps.
Reliable and secure data. Outfunnel uses advanced authentication methods, such as OAuth, and deploys encryption measures to make sure the data is secure in transit.
Connect Pipedrive and HubSpot today
Get started in 10 minutes. 14-day free trial. No credit card required.
Set up contact sync
1. Choose your apps
To get started head to Outfunnel > App connector and select your apps.
2. Select the connection type
Click on Connect and choose Contact sync as the connection type
3. Authenticate your apps
Most apps can be authenticated with a secure, one-click, no-code OAuth authentication.
4. Set the sync direction
Choose to sync data two-way or in a single direction
5. Define contact sync rules
Define the contacts that sync:
Pipedrive contacts: As you are syncing contacts, not Deals, then only Pipedrive People filters are visible for syncing. Learn how to set up Pipedrive People filters.
HubSpot contacts: Choose whether to sync all HubSpot contacts or only contacts you’ve defined with HubSpot static/active lists. Learn how to set up HubSpot Lists.
If this is your first sync we recommend syncing a limited number of (test) contacts to get a feel for the sync.
🏁 Initial sync
Contacts are linked based on the email address. If an existing contact is not found a new contact is created. If multiple contacts are found with the same email address then the link is made with the oldest contact and no duplicates will be created.
Initial sync actions in Pipedrive and HubSpot.
Contacts are created in the database.
🔄 Continuous sync
Contact changes. As long as the contact matches the rule any changes to its profile in the source app will be synced to the destination app.
When contact stops matching rules. When a contact stops matching the rules all updates will stop but they will not be deleted from the destination app.
💡 Other things to keep in mind
Contacts do not get removed/unsubscribed from either app if you remove the contact sync rule or change the target segment.
Multiple email addresses on a contact. Outfunnel creates a link with the first email address on a contact profile. Other addresses on the profile will be ignored.
Merging contacts. Outfunnel supports merging contacts.
6. Set up field mapping
First, choose the default fields and/or custom fields you’d like to sync.
💡 Data conflicts
Data conflicts usually happen during the initial sync when a mapped field value is different on both apps. For example, when the name is different for the same contact then Outfunnel will use the selected app as the conflict winner. Most companies use their CRM as a system of record. Reach out to support if you are having doubts or want to talk through your use case.
7. Activate the connection
🏁 Initial sync
After activating the connection Outfunnel will run an initial sync to merge your databases and you should see contacts appearing in the sync status page. The initial sync usually takes a few minutes but can take up to a few hours depending on the number of contacts to sync.
The status page also shows errored contacts and provides actionable feedback on how to fix this.
🔄 Continuous sync
After the initial sync completes Outfunnel starts running a continuous sync that checks for updates based on this logic.
