Two way sync Pipedrive and MySQL — n8n Workflow

Medium complexity⏰ Scheduled14 nodes🤝 Sales👁 10,719 viewsby n8n Team

Overview

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 most recently updated version.

Nodes used

PipedriveMySQL

Workflow Preview

C
Compare Datasets
⚡
S
Schedule Trigger
MySQL
Pipedrive
Create Person
Create Contact
D
Date & Time
Update Contact
S
Set Input2
S
Set Input1
Update Person
I
IF Data Changed
I
IF Updated On
S
Set
14 nodes13 edges

How it Works

  1. 1

    Trigger

    The workflow starts with a scheduled trigger, running on a defined schedule.

  2. 2

    Process

    Data flows through 14 nodes, connecting comparedatasets, datetime, if.

  3. 3

    Output

    The workflow completes its automation and delivers the result to the configured destination.

Node Details (14)

PI

Pipedrive

pipedrive

#1
MY

MySQL

mySql

#2

How to Import This Workflow

  1. 1Click Download JSON button on the right to save the workflow file.
  2. 2Open your n8n instance. Go to Workflows → New → Import from file.
  3. 3Select the downloaded two-way-sync-pipedrive-and-mysql file and click Import.
  4. 4Set up credentials for each service node (API keys, OAuth, etc.).
  5. 5Click Test Workflow to verify everything works, then activate it.

Or paste directly in n8n → Import from JSON:

{ "name": "Two way sync Pipedrive and MySQL", "nodes": [...], ...}

Integrations

comparedatasetsdatetimeifmysqlpipedrivescheduletriggerset

Get This Workflow

Download and import in one click

Download JSONView on n8n.io
Nodes14
Complexitymedium
Triggerscheduled
Views10,719
CategorySales

Created by

n8n Team

n8n Team

@n8n-team

Tags

comparedatasetsdatetimeifmysqlpipedrivescheduletriggerset
⚡

New to n8n?

n8n is a free, open-source workflow automation tool. Self-host it or use the cloud version.

Get n8n Free →