Sync HubSpot, Pipedrive & Salesforce to Google Sheets with OpenAI deduplication

This workflow contains community nodes that are only compatible with the self-hosted version of n8n.

How it works

This workflow automatically synchronizes contact data from multiple CRM systems (HubSpot, Pipedrive, and Salesforce) into a unified Google Sheets database. The system runs on a daily schedule or can be triggered manually via webhook. It uses AI-powered data processing to intelligently deduplicate records, calculate data quality scores, and merge similar contacts. The workflow generates comprehensive quality reports and sends notifications via Slack, ensuring your master database stays clean and up-to-date.

Who is this for

This template is designed for revenue operations teams, data managers, and business analysts who need to consolidate customer data from multiple CRM platforms. It's particularly valuable for organizations using multiple sales tools simultaneously or during CRM migration projects. The workflow helps maintain data integrity while providing insights into data quality across different systems.

Requirements

- Google Sheets Account: For storing master database and quality reports - CRM Platform Access: API credentials for HubSpot, Pipedrive, and/or Salesforce - OpenAI API Key: For AI-powered data processing and deduplication - MCP Server: Github:marlonluo2018/pandas-mcp-server (optional - can be replaced with Code node) - Slack Webhook: For receiving sync completion and error notifications

How to set up