Sync HubSpot, Pipedrive & Salesforce to Google Sheets with OpenAI deduplication
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 13 nodes and runs on a schedule (cron 0 2 * * *) (plus 2 other triggers). Along the way it connects Google Sheets, MCP Client and OpenAI Chat Model.
How it runs
Trigger: On a schedule (cron 0 2 * * *) (plus 2 other triggers).
- Trigger Router (Merge): merges the data from its input branches
- Error Processor (Code): runs custom JavaScript code
- Configuration Center (Edit Fields (Set)): sets 13 fields: runId, stagingSheetId, masterSheetId…
- Parallel CRM Fetcher (Code): runs custom JavaScript code
- CRM Data Processing Agent (AI Agent): runs an AI agent, with model: OpenAI Chat Model; 1 tool (pandas-mcp-server)
- Master Database Writer (Google Sheets): append or update
- Quality Report Generator (Code): runs custom JavaScript code
- Report Writer (Google Sheets): append
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (10)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Webhook
n8n-nodes-base.webhook - Merge
n8n-nodes-base.merge - Edit Fields (Set)
n8n-nodes-base.set - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets - Error Trigger
n8n-nodes-base.errorTrigger - AI Agent
@n8n/n8n-nodes-langchain.agent - MCP Client Tool
@n8n/n8n-nodes-langchain.mcpClientTool - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi
From the author
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…