n8n B2B Lead Gen Workflow: Searlo + Gemini + Google Sheets

Generate daily B2B lead search queries, qualify leads with Gemini, and append them to Google Sheets

This n8n B2B Lead Gen Workflow uses Google Gemini to create targeted search queries, pulls Searlo SERP results for each query, then has Gemini qualify and score the best prospects—automatically adding enriched leads to Google Sheets every day at 09:00.

What this workflow does

• Runs daily via a schedule trigger at 09:00.
• Uses Google Gemini (PaLM) to generate five targeted Google search queries designed to find B2B company pages.
• Parses the Gemini output as JSON; if parsing fails, it falls back to a predefined query list.
• Sends each query to the Searlo API endpoint https://api.searlo.tech/api/v1/search/web to retrieve up to 10 organic results per query.
• Extracts title, URL, snippet, and position from each organic result and processes results in batches of two.
• Prompts Gemini to analyze each batch and returns structured lead data: company name, root domain, description, industry, location, lead score (1–10), and score rationale.
• Parses the AI output into individual rows, adds a discovery timestamp, and appends the leads into a chosen Google Sheets worksheet.

Use cases

• Daily prospecting for a SaaS product by collecting and scoring B2B companies from SERP-style search results.
• Keeping sales or marketing lead lists updated in Google Sheets without manual research.
• Testing and iterating query strategies using Gemini-generated search prompts and structured lead scoring.

Technical details

• Nodes / components: Schedule Trigger, HTTP Request (Searlo), Google Sheets, Split in Batches, Code (parsing/row handling), plus support nodes like Sticky Note.
• Integrations: Google Gemini (PaLM) for query generation and lead qualification; Searlo for web SERP retrieval; Google Sheets OAuth2 for appending results.
• Configurable inputs: Gemini model, Searlo API key, spreadsheet + sheet name, column mapping, schedule time, locale parameters (gl/hl), and result limits.