Research and score crowdfunding leads with Google Sheets, DeepSeek, Lemlist, and more

by Incrementors ✓ · 3 views · created 2026-08-27 · Lead Generation, AI Summarization

What 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).

1. Get products to research (Google Sheets): uses Google Sheets
2. Get leads to score (Google Sheets): uses Google Sheets
3. Loop over products (Loop Over Items (Split in Batches)): loops over the items in batches
4. Skip leads without details (Filter): keeps only the items that match a condition
5. Group research results (Aggregate): combines items into one
6. Scrape the product page (HTTP Request): calls api.firecrawl.dev (POST)
7. Loop over leads (Loop Over Items (Split in Batches)): loops over the items in batches
8. Log the research run (Google Sheets): append
9. Clean the page markdown (Code): runs custom JavaScript code
10. Group scoring results (Aggregate): combines items into one

…plus 15 more steps. See the full node list below.

Services it uses

Google SheetsHTTP RequestPerplexityDeepSeek Chat ModelLemlistOpenAI Chat Model

HTTP calls to: api.firecrawl.dev, api.hunter.io, s.jina.ai, api.corenexis.com

Before you upgrade to n8n 3.0

Nodes used (19)

• Loop Over Items (Split in Batches)n8n-nodes-base.splitInBatches
• Google Sheetsn8n-nodes-base.googleSheets
• Schedule Triggern8n-nodes-base.scheduleTrigger
• Aggregaten8n-nodes-base.aggregate
• Http Request Tooln8n-nodes-base.httpRequestTool
• AI Agent@n8n/n8n-nodes-langchain.agent
• Perplexity Tooln8n-nodes-base.perplexityTool
• Structured Output Parser@n8n/n8n-nodes-langchain.outputParserStructured
• Ifn8n-nodes-base.if
• HTTP Requestn8n-nodes-base.httpRequest
• Mergen8n-nodes-base.merge
• DeepSeek Chat Model@n8n/n8n-nodes-langchain.lmChatDeepSeek
• Information Extractor@n8n/n8n-nodes-langchain.informationExtractor
• Lemlistn8n-nodes-base.lemlist
• Waitn8n-nodes-base.wait
• OpenAI Chat Model@n8n/n8n-nodes-langchain.lmChatOpenAi
• Coden8n-nodes-base.code
• Basic LLM Chain@n8n/n8n-nodes-langchain.chainLlm
• Filtern8n-nodes-base.filter

From the author

Quick overview This workflow runs two daily schedules to research crowdfunding campaign leads from Google Sheets using Firecrawl, DeepSeek/OpenAI, Jina AI, Perplexity, Hunter, and Lemlist, then verifies emails and scores each enriched lead with a 0–100 rating…

View the original on n8n.io → Check your own copy