Automates bidirectional sync of customer contacts between Pipedrive CRM and MySQL DB. Creates missing records and updates name, phone, email with most recent data.
This workflow enables seamless two-way synchronization of contact data between Pipedrive and a MySQL database. Triggered on a schedule, it fetches contacts from both sources—querying MySQL for id, name, email, phone, and updated_on, and retrieving all persons from Pipedrive. Using the Compare Datasets node, it matches records by email, identifying those unique to each system or with discrepancies in key fields.
For records existing only in one system, it creates them in the other: e.g., the 'Cr