Extract & summarize B2B leads from Crunchbase with Bright Data, GPT-4o & Google Sheets
n8n16 modulesv1.0Who 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 generation and market intelligence. This workflow is ideal for: 1. Sales Development Reps (SDRs) - Needing structured leads from Crunchbase 2. Marketing Analysts - Generating segmented outreach lists 3. Growth Teams - Identifying trending B2B
At a glance
Extract & summarize B2B leads from Crunchbase with Bright Data, GPT-4o & Google Sheets is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects HubSpot, Slack, Google Sheets, Salesforce. It's free to download. Follow the 5-step import below to go live in minutes.
- Platform
- n8n
- Connects
- HubSpot, Slack, Google Sheets, Salesforce, OpenAI
- Modules
- 16
- Price
- Free
- Version
- v1.0
About this workflow
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 generation and market intelligence. This workflow is ideal for: 1. Sales Development Reps (SDRs) - Needing structured leads from Crunchbase 2. Marketing Analysts - Generating segmented outreach lists 3. Growth Teams - Identifying trending B2B startups 4. RevOps Teams - Automating company research pipelines 5. Data Teams - Consolidating insights into Google Sheets for dashboards What problem is this workflow solving? Manual extraction of company data from Crunchbase is time-consuming, inconsistent, and often lacks the contextual summary required for sales enablement or growth targeting. This workflow automates the extraction, transformation, summarization, and delivery of Crunchbase company data into structured formats, making it instantly usable for B2B targeting and analysis. It solves: - The difficulty of scaling lead discovery from Crunchbase - The need to summarize raw textual content for quick insights - The lack of integration between web scraping, LLM processing, and storage What this workflow does - Markdown to Textual Data Extractor: Takes raw scraped markdown from Crunchbase and converts it into readable plain text using a basic LLM chain - Structured Data Extraction: Applies a parsing model (OpenAI) to extract structured fields such as company name, funding rounds, industry tags, location, and founding year - Summarization Chain: Generates an executive summary from the raw Crunchbase text using a summarization prompt template - Send to Google Sheets: Adds the structured data and summary into a Google Sheet for team access and further processing - Persist to Disk: Saves both raw and structured data files locally for archiving or further use - Webhook Notification: Sends a structured payload to a webhook endpoint (e.g., Slack, CRM, internal tools) with lead insights Pre-conditions 1. You need to have a Bright Data account and do the necessary setup as mentioned in the "Setup" section below. 2. You need to have an OpenAI Account. Setup - Sign up at Bright Data. - Navigate to Proxies & Scraping and create a new Web Unlocker zone by selecting Web Unlocker API under Scraping Solutions. - In n8n, configure the Header Auth account under Credentials (Generic Auth Type: Header Authentication). The Value field should be set with the Bearer XXXXXXXXXXXXXX. The XXXXXXXXXXXXXX should be replaced by the Web Unlocker Token. - In n8n, Configure the Google Sheet Credentials with your own account. Follow this documentation - Set Google Sheet Credential - In n8n, configure the OpenAi account credentials. - Ensure the URL and Bright Data zone name are correctly set in the Set URL, Filename and Bright Data Zone node. - Set the desired local path in the Write a file to disk node to save the responses. How to customize this workflow to your needs LLM Prompt Customization : - Modify the extraction prompt to include additional fields like revenue, social links, leadership team - Adjust summarization tone (e.g., executive summary, sales-focused snapshot or marketing digest) File Persistence - Store raw markdown, extracted JSON, and summary text separately for audit/debug Webhook Notification - Connect to CRM (e.g., HubSpot, Salesforce) via webhook to automatically create leads - Send Slack notifications to alert sales reps when a new high-potential company is discovered
How to import this n8n workflow
- 1
Download the workflow JSON file after purchase.
- 2
Open n8n → click the menu → Import from File.
- 3
Select the downloaded JSON and import.
- 4
Set up credentials for each node that requires them.
- 5
Click Execute Workflow to test, then activate.
Setup guide
Setup guide included
Purchase to unlock the full step-by-step guide
Related N8n workflows
Convert RSS news to AI avatar videos with Heygen & GPT-4o
Filter and update Google Sheets cells with messages from Anthropic Claude
Create new LionDesk contacts from Office 365 People contacts and add them to a campaign
Improve AI agent system prompts with GPT-4o feedback analysis and email delivery
Daily email digest with GPT-4 summaries to Google Docs
Manage emails via WhatsApp with Gmail, GPT and voice recognition
Resume screening & behavioral interviews with Gemini, Elevenlabs, & Notion ATS
Extract text from Google Drive files to Google Sheets using NVIDIA NIM
Reviews
No reviews yet
Be the first to buy and share your experience.
Leave a review
Sign in to share your experience with this workflow.
Create a free account to purchase workflows.
- JSON blueprint — instant download
- Setup guide PDF included
- 5 downloads · valid 30 days
- Works with n8n
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.
- Configure live on Google Meet / Zoom
- Free follow-up if workflow has defects
- Platform expert assigned to you