Generate and qualify daily B2B leads with Searlo, Gemini, and Google Sheets
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 12 nodes and runs on a schedule (every day at 09:00). Along the way it connects Google Gemini Chat Model and Google Sheets. It also calls api.searlo.tech over HTTP.
How it runs
Trigger: On a schedule (every day at 09:00).
- Generate Search Queries (Basic LLM Chain): sends a prompt to an LLM, with model: Gemini (Query Gen)
- Parse Queries (Code): runs custom JavaScript code
- Search Searlo SERP (HTTP Request): calls api.searlo.tech
- Extract Organic Results (Code): runs custom JavaScript code
- Process in Batches (Loop Over Items (Split in Batches)): loops over the items in batches
- Prepare Batch (Code): runs custom JavaScript code
- Qualify All Leads (Basic LLM Chain): sends a prompt to an LLM, with model: Gemini (Qualifier)
- Parse Lead Array (Code): runs custom JavaScript code
- Append Lead to Sheet (Google Sheets): append
Services it uses
HTTP calls to: api.searlo.tech
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 (7)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Code
n8n-nodes-base.code - HTTP Request
n8n-nodes-base.httpRequest - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Google Sheets
n8n-nodes-base.googleSheets
From the author
Quick overview This workflow runs daily to generate B2B lead search queries with Google Gemini, fetches Google-style SERP results via the Searlo API, uses Gemini to qualify and score each result, and appends the enriched leads to a Google Sheets spreadsheet.…