This n8n workflow finds and qualifies B2B leads automatically. Each day at 09:00, it uses Google Gemini to generate five targeted Google search queries aimed at B2B company pages. If Gemini's output can't be parsed as JSON, the workflow falls back to a predefined query list.
Each query is sent to the Searlo web search API, which returns up to 10 organic results. The workflow extracts the title, URL, snippet and position of each result and processes them in batches of two. Gemini then analyzes each batch and returns structured lead data.
The AI output is parsed into individual rows, given a discovery timestamp and appended to a chosen Google Sheets worksheet. It can be used for daily SaaS prospecting, keeping sales or marketing lead lists current without manual research, and testing different query strategies.
- Schedule
- Runs daily at 09:00 via a schedule trigger
- Query generation
- Five Google search queries per run, created by Google Gemini (PaLM)
- Search source
- Searlo API, endpoint https://api.searlo.tech/api/v1/search/web
- Results per query
- Up to 10 organic results
- Batch size
- 2 results at a time
- Extracted fields
- Title, URL, snippet, position
- Lead data
- Company name, root domain, description, industry, location, lead score (1–10), score rationale
- Output
- Rows appended to Google Sheets with a discovery timestamp
- Nodes
- Schedule Trigger, HTTP Request (Searlo), Google Sheets, Split in Batches, Code, Sticky Note
- Integrations
- Google Gemini (PaLM), Searlo, Google Sheets (OAuth2)
- Configurable
- Gemini model, Searlo API key, spreadsheet and sheet name, column mapping, schedule time, locale parameters (gl/hl), result limits