n8n B2B Lead Gen Workflow: CoreSignal + Apify + Google Sheets

Generate verified B2B decision-maker leads, enrich emails, and draft outreach in one n8n workflow

This n8n B2B Lead Gen Workflow pulls targeted decision makers from CoreSignal, finds and verifies their emails via Apify, stores everything in Google Sheets, and creates personalized outreach email drafts using an OpenRouter-hosted model.

What this workflow does

• Starts from lead criteria submitted through an n8n form submission (industry, company size, region, and number of results).
• Searches CoreSignal using the CoreSignal Agentic Search API to return matching decision makers, then splits results into individual lead items.
• Upserts leads into Google Sheets into a “Leads” sheet, including company, name, title, LinkedIn URL, and score.
• Enriches contacts by aggregating LinkedIn URLs and running an Apify actor to find contact emails, then updating the Google Sheet with enriched email fields.
• Filters and verifies leads that have an email address and runs an Apify email verification actor, writing email status back to Google Sheets.
• Drafts outreach emails 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 OpenRouter chat model (optionally leveraging an Apify web search tool).
• Saves outreach drafts into a Google Sheets “Outreach” sheet with status set to waiting confirmation.

Use cases

• SaaS teams building a repeatable inbound-to-outbound lead engine for specific industries and regions.
• Automation engineers setting up an end-to-end B2B lead generation and enrichment pipeline in n8n.
• Sales ops workflows that require verified email quality before outreach and organized tracking in Google Sheets.

Technical details

• CoreSignal: CoreSignal Agentic Search API via an authorized HTTP Request node.
• Apify: actors for LinkedIn email discovery and email verification (run after enriching LinkedIn URLs).
• Google Sheets: “Leads” and “Outreach” sheets for lead storage, email status updates, and draft outreach logging.
• n8n logic & nodes: code, filter, split out, aggregate, sticky note, and form trigger.
• OpenRouter: chat model to generate outreach email drafts from verified lead context.