AI-powered lead enrichment with Bright Data MCP and Google Sheets
Needs changesNeeds changes. This template uses 1 thing(s) that n8n 3.0 removes: AI Agent v1 (old agent modes). 1 breaking item(s) found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 39 nodes and runs when an HTTP POST request hits its webhook URL (plus 3 other triggers). Along the way it connects Google Sheets, OpenAI Chat Model, MCP Client and OpenAI and 1 more.
How it runs
Trigger: When an HTTP POST request hits its webhook URL (plus 3 other triggers).
- Split Out: splits a list into separate items
- HubSpot: get
- Google Sheets: uses Google Sheets
- Filter: keeps only the items that match a condition
- Google Sheets: append
- Process each leads one by one (Loop Over Items (Split in Batches)): loops over the items in batches
- Remove unneccessary fields for the prompt (Edit Fields (Set)): sets or maps fields
- Scraper AI Agent (AI Agent): runs an AI agent, with model: OpenAI Chat Model; 1 tool (Bright Data MCP Client); output parser: Auto-fixing Output Parser
- Switch: routes items into 3 branches
- Merge: merges the data from its input branches
…plus 17 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- AI Agent v1 (old agent modes) in Scraper AI Agent (v1.9): replace with Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.
| Removed in 3.0 | Replace with |
|---|---|
| AI Agent v1 (old agent modes) Scraper AI Agent (v1.9) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (21)
- Google Sheets Trigger
n8n-nodes-base.googleSheetsTrigger - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Auto-fixing Output Parser
@n8n/n8n-nodes-langchain.outputParserAutofixing - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Filter
n8n-nodes-base.filter - Edit Fields (Set)
n8n-nodes-base.set - MCP Client Tool
@n8n/n8n-nodes-langchain.mcpClientTool - If
n8n-nodes-base.if - Switch
n8n-nodes-base.switch - Merge
n8n-nodes-base.merge - No Operation, do nothing
n8n-nodes-base.noOp - Wait
n8n-nodes-base.wait - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI
@n8n/n8n-nodes-langchain.openAi - Google Sheets
n8n-nodes-base.googleSheets - Split Out
n8n-nodes-base.splitOut - HubSpot
n8n-nodes-base.hubspot - Manual Trigger
n8n-nodes-base.manualTrigger - HubSpot Trigger
n8n-nodes-base.hubspotTrigger - Webhook
n8n-nodes-base.webhook
From the author
📌 HubSpot Lead Enrichment with Bright Data MCP This template enables natural-language-driven automation using Bright Data's MCP tools, triggered directly by new leads in HubSpot. It dynamically extracts and executes the right tool based on lead…