Pipedrive & MySQL Contact Sync Automation

# Two-way contact sync between Pipedrive and MySQL on schedule with update time comparison

This automation workflow solves data inconsistency between Pipedrive CRM and a custom MySQL database by enabling bidirectional contact synchronization based on email and update timestamps. It ensures both systems stay in sync without duplication or data loss — ideal for teams managing client data across multiple platforms.

## Who it´s for
- Companies using Pipedrive alongside a self-hosted MySQL database for contact management.
- CRM administrators responsible for maintaining cross-system data consistency.
- SaaS products with Pipedrive integration and internal database storage.

## What the automation does
- Periodically checks for contact changes in Pipedrive and MySQL via cron schedule.
- Compares records by email and evaluates last updated timestamps.
- Detects new or modified contacts in either system.
- Creates or updates corresponding entries in the opposite system.
- Resolves conflicts by selecting the most recent version and syncing it both ways.

## What´s included
- Ready-to-use workflow for n8n + MySQL + Pipedrive sync engine.
- Trigger and handler logic based on cron_schedule.
- Integrations exclusively with Pipedrive and MySQL.
- Basic text instructions for deployment and adaptation.

## Requirements for setup
- Access to an n8n instance with MySQL connectivity.
- Pipedrive account API key.
- MySQL credentials (host, port, username, password, database name).

## Benefits and outcomes
- Eliminates manual contact transfer between systems.
- Prevents data staleness in either platform.
- Avoids duplicates through precise email-based matching.
- Automatically resolves edit conflicts using timestamp logic.
- Maintains a single source of truth without centralized ETL.
- Saves team time and reduces human error risk.

## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via chat