Extract & summarize B2B leads from Crunchbase with Bright Data, GPT-4o & Google Sheets
Needs changesWhat this workflow does
This AI workflow has 16 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets and OpenAI Chat Model. It also calls api.brightdata.com and webhook.site over HTTP.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Set URL and Bright Data Zone (Edit Fields (Set)): sets 2 fields: url, zone
- Perform Bright Data Web Request (HTTP Request): calls api.brightdata.com (POST)
- Markdown to Textual Data Extractor (Basic LLM Chain): sends a prompt to an LLM, with model: OpenAI Chat Model
- Summarize the content (Summarization Chain): summarizes text with AI, with model: OpenAI Chat Model
- Structured Data Extractor (Basic LLM Chain): sends a prompt to an LLM, with model: OpenAI Chat Model; output parser: Structured Output Parser
- Create a binary data for Summarization (Function): runs custom JavaScript (legacy Function node)
- Google Sheets: append or update
- Create a binary data for Structured Data Extract (Function): runs custom JavaScript (legacy Function node)
- Initiate a Webhook Notification for the extracted data (HTTP Request): calls webhook.site
- Write the summarized content to disk (Read/Write Files from Disk): writes a file to disk
…plus 1 more step. See the full node list below.
Services it uses
HTTP calls to: api.brightdata.com, webhook.site
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- Function (legacy) in Create a binary data for Summarization, Create a binary data for Structured Data Extract: replace with Code node, mode 'Run Once for All Items'.
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| Function (legacy) Create a binary data for Summarization, Create a binary data for Structured Data Extract | Code node, mode 'Run Once for All Items' |
Nodes used (10)
- Manual Trigger
n8n-nodes-base.manualTrigger - Edit Fields (Set)
n8n-nodes-base.set - HTTP Request
n8n-nodes-base.httpRequest - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Google Sheets
n8n-nodes-base.googleSheets - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Function
n8n-nodes-base.function - Read/Write Files from Disk
n8n-nodes-base.readWriteFile - Summarization Chain
@n8n/n8n-nodes-langchain.chainSummarization - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi
From the author
Who this is for The Crunchbase B2B Lead Discovery Pipeline is designed for sales teams, B2B marketers, business analysts, and data operations teams who need a reliable way to extract, structure, and summarize company information from Crunchbase to fuel lead…