Analyze Crunchbase startups by keyword with Bright Data, Gemini AI & Google Sheets
This n8n workflow automates the discovery, enrichment, and comparative analysis of startups from the Crunchbase dataset via Bright Data, enhanced with AI, and exports structured results to Google Sheets. 🚀 What It Does - Receives a keyword from the user that describes the area of interest — such as an industry, sector, technology, or trend (e.g., "AI in healthcare", "carbon capture", "edtech"). - This keyword is used to filter relevant startups from the Crunchbase dataset via Bright Data. - Fet
At a glance
Analyze Crunchbase startups by keyword with Bright Data, Gemini AI & Google Sheets is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Google Sheets, Gemini. It's free to download. Follow the 5-step import below to go live in minutes.
- Platform
- n8n
- Connects
- Google Sheets, Gemini
- Modules
- 12
- Price
- Free
- Version
- v1.0

About this workflow
This n8n workflow automates the discovery, enrichment, and comparative analysis of startups from the Crunchbase dataset via Bright Data, enhanced with AI, and exports structured results to Google Sheets. 🚀 What It Does - Receives a keyword from the user that describes the area of interest — such as an industry, sector, technology, or trend (e.g., "AI in healthcare", "carbon capture", "edtech"). - This keyword is used to filter relevant startups from the Crunchbase dataset via Bright Data. - Fetches data from Bright Data's Crunchbase snapshot API. - Extracts and cleans key fields from the JSON response. - Sorts startups by most recent founding date. - Selects the top 10 most recent companies. - Sends these 10 companies to Google Gemini AI for comparative analysis. - Embeds the AI-generated summary into the final export. - Appends results to a Google Sheet for tracking and reporting. 🛠️ Step-by-Step Setup 1. Get user keyword input from a form. 2. Use 3 Bright Data requests: Start snapshot. Poll snapshot status until ready. Fetch snapshot data in JSON format. 3. Use a Python Code node to: 4. Parse and sort companies by foundeddate. 5. Clean and standardize data fields. 6. Pass the top 10 companies into Gemini AI for comparative insight. 7. Merge the AI output back with company data. 8. Send everything to Google Sheets. 🧠 How It Works - Snapshot Control: Polls every few seconds until the Bright Data snapshot is complete. - Code Cleanup: Ensures consistent structure and formatting across all records. - Comparative AI Analysis: Gemini compares all 10 companies at once and returns a unified analysis. - Merging Output: AI analysis is merged into the first company’s record (to avoid duplication), while all 10 are exported. 📤 Google Sheet Output Each row includes: - name, founded, about, numemployees, type, ipostatus, fulldescription, socialmedialinks, address, website, fundingtotal, numinvestors, leadinvestors, founders, productsandservices, monthlyvisits, crunchbaselink, aianalysis. - AI comparative analysis summary (only once per batch – attached to the first company). - All fields from above customizible through the python code (you can add additional ones from Bright Data output). 🔐 Required Credentials - Bright Data – Replace YOURAPIKEY in 3 HTTP Request nodes. - Google Gemini API – For AI analysis. - Google Sheets OAuth2 – For spreadsheet export. ⚠️ Notes - AI output is shared once per batch of 10 companies, attached to the first company entry. You can configure the limit of batch size in the first "Code" node.
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
AI agent web search using SearchAPI & LLM
Create an Event Ticketing system with Google Sheets, Google Docs & Barcodes - Part 1
Automated Invoice Processing with WiseOCR and Google Integration
AI-Powered Cold Calling Automation with Vapi.ai, GPT-4o & Google Sheets
Send new data from Google Sheets to Facebook Conversions API
Add new Gigrove orders to Google Sheets as new rows
🛠️ Auto n8n updater (Docker)
Summarize documents, images & spreadsheets with Gemma 3 on Ollama
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