Two way sync Pipedrive and MySQL

by n8n Team ✓ · 17,108 views · created 2022-11-03 · CRM

What this workflow does

This workflow has 14 nodes and runs on a schedule (every day). Along the way it connects MySQL and Pipedrive.

How it runs

Trigger: On a schedule (every day).

1. MySQL: run a query
2. Compare Datasets: uses Compare Datasets
3. Create Person (Pipedrive): work with person
4. If: checks a condition and branches into true / false
5. Create Contact (MySQL): uses MySQL
6. Date & Time: formats or calculates dates
7. If: checks a condition and branches into true / false
8. Set Input (Edit Fields (Set)): sets or maps fields
9. Set Input (Edit Fields (Set)): sets or maps fields
10. Update Person (Pipedrive): update (person)

…plus 3 more steps. See the full node list below.

Services it uses

MySQLPipedrive

Before you upgrade to n8n 3.0

Nodes used (7)

• Compare Datasetsn8n-nodes-base.compareDatasets
• Schedule Triggern8n-nodes-base.scheduleTrigger
• MySQLn8n-nodes-base.mySql
• Pipedriven8n-nodes-base.pipedrive
• Date & Timen8n-nodes-base.dateTime
• Edit Fields (Set)n8n-nodes-base.set
• Ifn8n-nodes-base.if

From the author

This workflow automates a two way sync of customer data between Pipedrive and MySQL. It will create new records in one source if it only exists in the other. Where matching records have different data for name, phone number or email address, it will sync the…

View the original on n8n.io → Check your own copy