Data & Databases
Two-way synchronization between Pipedrive and MySQL database
14 nodes
131
88
Scheduled trigger
Workflow Description
An automation template that synchronizes data between Pipedrive and MySQL bidirectionally on a scheduled basis, ensuring customer records, opportunities, and deals remain consistent across both systems automatically without manual intervention.
How it works
- 1.Execute automation on a defined schedule
- 2.Retrieve recent data from both Pipedrive and MySQL
- 3.Compare datasets to identify changes and discrepancies
- 4.Update differing records in both directions based on last modification time
- 5.Log synchronization results and summary of changes
Use cases
- Sales teams using Pipedrive while maintaining customer data in MySQL
- Organizations requiring real-time deal and opportunity updates across systems
- Preventing data loss from simultaneous edits in both platforms
- Eliminating manual data entry errors between Pipedrive and MySQL
Requirements
- Active Pipedrive account with API access and data permissions
- Accessible MySQL database with defined tables for contacts and deals
- API keys from Pipedrive and MySQL credentials configured in n8n
- Scheduled trigger set for desired synchronization frequency
Service Value
Ready-made workflow template for automation delivery and service execution.
Apps Used
MySQL
Pipedrive
Details
Trigger
Scheduled trigger
Nodes
14
Apps
2
Views
131
Downloads
88
How to Use
- 1.Click "Download Template"
- 2.Open your n8n dashboard
- 3.Go to Workflows > Import from File
- 4.Select downloaded file and configure credentials
Nodes Used (14)
/
Compare Datasets
Set
Schedule Trigger
Schedule Trigger
MySQL
My Sql
Pipedrive
Pipedrive
Create Person
Pipedrive
Create Contact
My Sql
Date & Time
Date Time
Update Contact
My Sql
Set Input2
Set
Set Input1
Set
Update Person
Pipedrive
IF Data Changed
If
IF Updated On
If
Set
Set