AutomationMart
Home/Browse/Analyze Crunchbase startups by keyword with Bright Data, Gemini AI & Google Sheets
n8n

Analyze Crunchbase startups by keyword with Bright Data, Gemini AI & Google Sheets

n8nn8n12 modulesv1.0
Google SheetsGemini

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
Analyze Crunchbase startups by keyword with Bright Data, Gemini AI & Google Sheets workflow diagram

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.

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 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

AI Agent Web Search using SearchApi & LLM Who is this for? This workflow is ideal for anyone conducting online research, including students, researchers, content creators, and professionals looking for accurate, up-to-date, and verifiable information. It also serves as an excellent foundation for building more sophisticated AI-driven applications. What problem does this workflow solve? / Use case This workflow automates web searches by enabling an AI agent to efficiently retrieve and summarize e

Free

Create an Event Ticketing system with Google Sheets, Google Docs & Barcodes - Part 1

Every time a new row is added to your Google Sheets spreadsheet, Make will automatically create an event Ticket with a QR code and dynamic data. The template uses this example spreadsheet and this example ticket.

Free

Automated Invoice Processing with WiseOCR and Google Integration

This scenario automates invoice and receipt processing. It monitors a folder in Google Drive and downloads any new files. Using WiseOCR, it extracts data from the document, then adds this data as a new row in Google Sheets. For support, contact support@wiseocr.com

Free

AI-Powered Cold Calling Automation with Vapi.ai, GPT-4o & Google Sheets

AI-Powered Cold Calling Automation with Vapi.ai, GPT-4o & Google Sheets Overview Transform your lead list into an AI-powered calling machine. This workflow automates your entire cold calling process using Vapi's conversational AI to initiate calls, qualify leads, capture detailed insights, and manage intelligent follow-ups - achieving 10x more calls than manual efforts while maintaining personalized, professional conversations. Built for sales teams, recruiters, and customer success professional

Free

Send new data from Google Sheets to Facebook Conversions API

When a new row is created in Google Sheets spreadsheet, the data from the row are sent to Facebook Conversions API.

Free

Add new Gigrove orders to Google Sheets as new rows

Every time a new order is created in your Gigrove, Integormat will add a row with information on that order in your Google Sheets. To assure that the scenario works properly we have created a (sample table)[https://docs.google.com/spreadsheets/d/1LVus3joqlqvgFLY5npPIethcxjxaw0is-cOj6q2STeA/edit?usp=sharing] in Google Sheets so that you could use it when creating yours.

Free

🛠️ Auto n8n updater (Docker)

How it works This workflow automates the process of checking for and applying updates to a self-hosted n8n instance running on Docker. It runs on a schedule, checks for new versions, summarizes the release notes with AI, and asks for your approval via Telegram before updating. 1. Scheduled Check: The workflow runs hourly, triggered by a Schedule node. 2. Version Discovery: It first confirms it's running in a Docker environment. It uses SSH to connect to the host machine and inspects the runnin

Free

Summarize documents, images & spreadsheets with Gemma 3 on Ollama

Tutorial Video 🚀 Overview Transform your file management with this intelligent workflow that automatically processes and summarizes any file dropped into a monitored folder. Using local AI powered by Ollama, this workflow provides instant insights for images, documents, and data files. ✨ Key Features 🔄 Automatic Processing: Monitors a folder and processes files instantly upon detection 🎯 Multi-Format Support: Hand

Free

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.

Log in to review
Free
No ratings yet

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.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free