Research and score crowdfunding leads in Google Sheets with DeepSeek AI
Ready for 3.0What this workflow does
This AI workflow has 39 nodes and runs on a schedule (every day at 01:00) (plus 1 other trigger). Along the way it connects Google Sheets, HTTP Request, Perplexity and DeepSeek Chat Model and 2 more. It also calls api.firecrawl.dev, api.hunter.io and s.jina.ai over HTTP.
How it runs
Trigger: On a schedule (every day at 01:00) (plus 1 other trigger).
- Get products to research (Google Sheets): uses Google Sheets
- Get leads to score (Google Sheets): uses Google Sheets
- Loop over products (Loop Over Items (Split in Batches)): loops over the items in batches
- Skip leads without details (Filter): keeps only the items that match a condition
- Group research results (Aggregate): combines items into one
- Scrape the product page (HTTP Request): calls api.firecrawl.dev (POST)
- Loop over leads (Loop Over Items (Split in Batches)): loops over the items in batches
- Log the research run (Google Sheets): append
- Clean the page markdown (Code): runs custom JavaScript code
- Group scoring results (Aggregate): combines items into one
…plus 15 more steps. See the full node list below.
Services it uses
HTTP calls to: api.firecrawl.dev, api.hunter.io, s.jina.ai, api.corenexis.com
Uses Firecrawl. New users get 10% off with our link.
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (19)
- Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Google Sheets
n8n-nodes-base.googleSheets - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Aggregate
n8n-nodes-base.aggregate - Http Request Tool
n8n-nodes-base.httpRequestTool - AI Agent
@n8n/n8n-nodes-langchain.agent - Perplexity Tool
n8n-nodes-base.perplexityTool - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - If
n8n-nodes-base.if - HTTP Request
n8n-nodes-base.httpRequest - Merge
n8n-nodes-base.merge - DeepSeek Chat Model
@n8n/n8n-nodes-langchain.lmChatDeepSeek - Information Extractor
@n8n/n8n-nodes-langchain.informationExtractor - Lemlist
n8n-nodes-base.lemlist - Wait
n8n-nodes-base.wait - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Code
n8n-nodes-base.code - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Filter
n8n-nodes-base.filter
From the author
Quick overview This workflow runs two daily schedules to research crowdfunding campaigns from Google Sheets using Firecrawl, DeepSeek/OpenAI, Jina AI, Perplexity, Hunter, Lemlist, and an email verification API, then writes enriched contact details and a 0–100…