n8n Workflow: Two-Way Sync Pipedrive and MySQL

This n8n workflow provides a robust framework for synchronizing data between Pipedrive and a MySQL database. It uses a scheduled trigger to periodically compare datasets and identify changes, allowing for a two-way synchronization approach.

What it does

This workflow is designed to facilitate data consistency between Pipedrive and MySQL by:

1. Periodically Triggering: The workflow is initiated on a schedule, ensuring regular synchronization checks.
2. Comparing Datasets: It compares data from two sources (implied to be Pipedrive and MySQL, though specific read operations are not detailed in the provided JSON).
3. Conditional Logic: It uses an "If" node to apply conditional logic, likely to determine if data needs to be updated in Pipedrive or MySQL based on the comparison.
4. Data Transformation: Utilizes "Edit Fields (Set)" and "Date & Time" nodes, suggesting data manipulation and formatting before updates.
5. Pipedrive Interaction: Includes a Pipedrive node, indicating operations such as creating, updating, or retrieving data in Pipedrive.
6. MySQL Interaction: Includes a MySQL node, indicating operations such as inserting, updating, or querying data in the MySQL database.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running n8n instance.
• Pipedrive Account: With API access and necessary credentials configured in n8n.
• MySQL Database: Access to a MySQL database with appropriate credentials configured in n8n.

Setup/Usage

1. Import the workflow: Import the provided JSON into your n8n instance.
2. Configure Credentials:
   • Set up your Pipedrive API credentials in n8n.
   • Set up your MySQL database credentials in n8n.
3. Customize Nodes:
   • Schedule Trigger: Adjust the schedule frequency to your needs (e.g., every 15 minutes, hourly).
   • Pipedrive Node: Configure the specific Pipedrive operations (e.g., "Get All Deals", "Update Person", "Create Organization") and map the fields according to your Pipedrive setup.
   • MySQL Node: Configure the specific MySQL operations (e.g., "Select", "Insert", "Update") and define your table and column mappings.
   • Compare Datasets: Configure the key fields for comparison between Pipedrive and MySQL data to identify new or updated records.
   • If Node: Define the conditions for routing data based on the comparison results (e.g., if a record exists in Pipedrive but not MySQL, create it in MySQL).
   • Edit Fields (Set) and Date & Time: Adjust any data transformations or date formatting as required for consistency between the two systems.
4. Activate the workflow: Once configured, activate the workflow to start the scheduled synchronization.