Back to Templates

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

Created by

Created by: Grace Gbadamosi || grace-bola

Grace Gbadamosi

Last update

Last update 3 days ago

Share


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

  1. Configure Environment Variables - Set up secure credential storage for all API keys: HUBSPOT_API_KEY, PIPEDRIVE_API_KEY, SALESFORCE_ACCESS_TOKEN, OPENAI_API_KEY, and SLACK_WEBHOOK_URL

  2. Create Google Sheets Structure - Create a master Google Sheet with two tabs: "Master_CRM_Data" for the unified contact database and "Quality_Reports" for tracking sync statistics and data quality metrics

  3. Set Up MCP Server - Install and configure "marlonluo2018/pandas-mcp-server"

  4. Update Configuration Center - Modify all placeholder values in the Configuration Center node with your actual Google Sheet IDs, quality thresholds, deduplication keys, and batch processing settings