MySQL and Pipedrive - How to Create Two Way Data Sync

Learn how to quickly create a two-way sync between MySQL and Pipedrive using n8n in this 17-minute video tutorial. Discover how to set up a workflow that creates new records in one source if they only exist in the other and syncs the most recently updated version when matching records have different data. Explore the process of comparing datasets, creating contacts in both MySQL and Pipedrive, handling data item changes, and implementing conditional logic with IF nodes. Master the use of expressions, date and time operations, and data merging techniques. Follow along as the tutorial guides you through updating data in both MySQL and Pipedrive, and finally activating the workflow. While this example uses MySQL and Pipedrive, apply these concepts to create two-way syncs between various CRMs and databases.

- Intro
- Setup
- Walkthrough of workflow
- Compare dataset node
- Create contacts in MySQL database
- Create contacts in Pipedrive
- Data item change
- IF ode
- Expressions
- Date & Time node
- If updated on Node
- Set node to merge data
- Update MySQL node
- Update data in Pipedrive
- Activate the workflow