{"product_id":"n8n-b2b-lead-gen-workflow-coresignal-apify-google-sheets","title":"n8n B2B Lead Gen Workflow: CoreSignal + Apify + Google Sheets","description":"\u003ch3\u003eGenerate verified B2B decision-maker leads, enrich emails, and draft outreach in one n8n workflow\u003c\/h3\u003e\n\u003cp\u003eThis n8n B2B Lead Gen Workflow pulls targeted decision makers from \u003cstrong\u003eCoreSignal\u003c\/strong\u003e, finds and verifies their emails via \u003cstrong\u003eApify\u003c\/strong\u003e, stores everything in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and creates personalized outreach email drafts using an \u003cstrong\u003eOpenRouter-hosted model\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eStarts from lead criteria\u003c\/strong\u003e submitted through an n8n form submission (industry, company size, region, and number of results).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSearches CoreSignal\u003c\/strong\u003e using the \u003cem\u003eCoreSignal Agentic Search API\u003c\/em\u003e to return matching decision makers, then \u003cstrong\u003esplits results\u003c\/strong\u003e into individual lead items.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpserts leads into Google Sheets\u003c\/strong\u003e into a “Leads” sheet, including company, name, title, LinkedIn URL, and score.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEnriches contacts\u003c\/strong\u003e by aggregating LinkedIn URLs and running an \u003cstrong\u003eApify actor\u003c\/strong\u003e to find contact emails, then updating the Google Sheet with enriched email fields.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilters and verifies\u003c\/strong\u003e leads that have an email address and runs an \u003cstrong\u003eApify email verification actor\u003c\/strong\u003e, writing email status back to Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDrafts outreach emails\u003c\/strong\u003e on manual runs: reads verified leads and the existing “Outreach” list from Google Sheets, removes leads already in outreach, and generates a draft using an \u003cstrong\u003eOpenRouter chat model\u003c\/strong\u003e (optionally leveraging an Apify web search tool).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSaves outreach drafts\u003c\/strong\u003e into a Google Sheets “Outreach” sheet with status set to \u003cstrong\u003ewaiting confirmation\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS teams building a repeatable inbound-to-outbound lead engine for specific industries and regions.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers setting up an end-to-end B2B lead generation and enrichment pipeline in n8n.\u003c\/li\u003e\n  \u003cli\u003eSales ops workflows that require verified email quality before outreach and organized tracking in Google Sheets.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCoreSignal\u003c\/strong\u003e: CoreSignal Agentic Search API via an authorized HTTP Request node.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApify\u003c\/strong\u003e: actors for LinkedIn email discovery and email verification (run after enriching LinkedIn URLs).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e: “Leads” and “Outreach” sheets for lead storage, email status updates, and draft outreach logging.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n logic \u0026amp; nodes\u003c\/strong\u003e: code, filter, split out, aggregate, sticky note, and form trigger.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOpenRouter\u003c\/strong\u003e: chat model to generate outreach email drafts from verified lead context.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46146266005683,"sku":"N8N-20263","price":14.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/8_HY1ySFkWaLpDGnQtsDs_GSp8ZWqE.png?v=1790845623","url":"https:\/\/buyflowscripts.com\/products\/n8n-b2b-lead-gen-workflow-coresignal-apify-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}