Quick overview
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. How it works Runs every day at 09:00 using a schedule trigger. Uses Google Gemini to generate five targeted Google search queries for finding B2B company pages and then parses the returned JSON (with a fallback query list if parsing fails). Sends each query to the Searlo SERP API to retrieve up to 10 organic web results per query. Extracts the title, URL, snippet, and position from each organic result and processes the results in batches of two. Uses Google Gemini to analyze each batch and return structured lead data including company name, root domain, description, industry, location, lead score (1–10), and a score rationale. Parses the AI output into individual lead rows, adds a discovery timestamp, and appends each lead to Google Sheets. Setup Add a Google Gemini (PaLM) API credential and select the Gemini model used for both query generation and lead qualification. Add your Searlo API key credential for the HTTP request to https://api.searlo.tech/api/v1/search/web. Connect a Google Sheets OAuth2 account and set the target spreadsheet, sheet name, and column mapping for the appended lead fields. Adjust the schedule time, search locale parameters (gl/hl), and result limits if needed for your region and lead volume. An n8n automation workflow template by Muhammed Umar.
Muhammed Umar
web
free
Others in the same category, ranked by how often they are opened.
