{"product_id":"n8n-b2b-lead-gen-workflow-searlo-gemini-google-sheets","title":"n8n B2B Lead Gen Workflow: Searlo + Gemini + Google Sheets","description":"\u003ch3\u003eGenerate daily B2B lead search queries, qualify leads with Gemini, and append them to Google Sheets\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003en8n B2B Lead Gen Workflow\u003c\/strong\u003e uses \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e to create targeted search queries, pulls \u003cstrong\u003eSearlo SERP\u003c\/strong\u003e results for each query, then has Gemini qualify and score the best prospects—automatically adding enriched leads to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e every day at \u003cstrong\u003e09:00\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns daily\u003c\/strong\u003e via a schedule trigger at \u003cstrong\u003e09:00\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eUses \u003cstrong\u003eGoogle Gemini (PaLM)\u003c\/strong\u003e to generate \u003cstrong\u003efive targeted Google search queries\u003c\/strong\u003e designed to find \u003cstrong\u003eB2B company pages\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eParses the Gemini output as JSON; if parsing fails, it falls back to a \u003cstrong\u003epredefined query list\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eSends each query to the \u003cstrong\u003eSearlo API\u003c\/strong\u003e endpoint \u003cstrong\u003ehttps:\/\/api.searlo.tech\/api\/v1\/search\/web\u003c\/strong\u003e to retrieve up to \u003cstrong\u003e10 organic results per query\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eExtracts \u003cstrong\u003etitle, URL, snippet, and position\u003c\/strong\u003e from each organic result and processes results in \u003cstrong\u003ebatches of two\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003ePrompts Gemini to analyze each batch and returns structured lead data: \u003cstrong\u003ecompany name, root domain, description, industry, location, lead score (1–10), and score rationale\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eParses the AI output into individual rows, adds a \u003cstrong\u003ediscovery timestamp\u003c\/strong\u003e, and \u003cstrong\u003eappends\u003c\/strong\u003e the leads into a chosen \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e worksheet.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eDaily prospecting for a SaaS product by collecting and scoring B2B companies from SERP-style search results.\u003c\/li\u003e\n  \u003cli\u003eKeeping sales or marketing lead lists updated in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e without manual research.\u003c\/li\u003e\n  \u003cli\u003eTesting and iterating query strategies using Gemini-generated search prompts and structured lead scoring.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes \/ components:\u003c\/strong\u003e Schedule Trigger, HTTP Request (Searlo), Google Sheets, Split in Batches, Code (parsing\/row handling), plus support nodes like Sticky Note.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e \u003cstrong\u003eGoogle Gemini (PaLM)\u003c\/strong\u003e for query generation and lead qualification; \u003cstrong\u003eSearlo\u003c\/strong\u003e for web SERP retrieval; \u003cstrong\u003eGoogle Sheets OAuth2\u003c\/strong\u003e for appending results.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eConfigurable inputs:\u003c\/strong\u003e Gemini model, Searlo API key, spreadsheet + sheet name, column mapping, schedule time, locale parameters (gl\/hl), and result limits.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45850551910579,"sku":"N8N-18300","price":27.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/GopJH36uqfyIa5u61XujI_yYYAe4S6.png?v=1786871038","url":"https:\/\/buyflowscripts.com\/products\/n8n-b2b-lead-gen-workflow-searlo-gemini-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}