Our Pipedrive–Google Sheets sync is designed for B2B companies who need to keep their Pipedrive data in sync with Google Sheets. With data in Google Sheets teams can deploy BI & analytics tools, create workflows with Zapier/Make and more.
💡 Google Sheets is currently only available as a destination app. This means you can sync contacts from Pipedrive to Google Sheets, but not the other way around. Two-way sync is planned for the future.
What the integration does
Contact sync. Sync all contacts, or a subset, from Pipedrive to Google Sheets and keep them in sync.
Flexible field mapping. Sync default and custom fields.
Built-in deduplication. Match contacts by email address, so existing rows are linked instead of duplicated.
Sync status monitoring. See what ran and what failed, with error messages that show how to fix it.
Authenticate your apps
Head to App connector
Select Pipedrive and Google Sheets
Authenticate as per on-screen instructions if you haven't done so already
How to set up a contact sync from Pipedrive to Google Sheets
1. Choose your apps
Select Pipedrive and Google Sheets, and choose Contact sync as the connection type.
2. Set the sync direction and database
Choose the Google Sheets file and sheet you'd like to sync data to.
3. Define which contacts to sync
Define which contacts should be part of the sync.
Pipedrive contacts: You can choose to sync all contacts or use People filters. Learn how to set up Pipedrive People filters.
If this is your first sync we recommend syncing a limited number of (test) contacts to get a feel for the sync.
4. Set up field mapping
Choose the default fields and/or custom fields you'd like to sync.
Adding new fields. Create a new field in the corresponding app. Then head back to Outfunnel and click "refresh fields" to see the new field.
5. Activate the connection
🏁 Initial sync
After activating the connection Outfunnel will run an initial sync 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.
Initial sync action
Outfunnel first looks for an existing row based on the email address. If found, it's linked. If not, a new row is created. If multiple rows share the same email address, the oldest one is linked and no duplicates are created.
🔄 Continuous sync
After the initial sync completes Outfunnel starts running a continuous sync that checks for updates. As long as the contact matches the rule any changes to its profile in Pipedrive will be synced to Google Sheets. See here for sync interval.
✖️ Exiting the sync
When a contact stops matching the rules, updates stop and the row is removed from the sheet.
Need help?
If you run into any issues or have questions about the sync, reach out to us via the chat widget — we're happy to help!