Templates / Scrape B2B leads from Apollo, generate Groq AI emails, and send via Gmail

Scrape B2B leads from Apollo, generate Groq AI emails, and send via Gmail

Ready for 3.0

by Shreya Bhingarkar ✓ · 635 views · created 2026-03-18 · Lead Generation, Multimodal AI

Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.

What this workflow does

This AI workflow has 28 nodes and runs manually, when you click “Execute workflow” (plus 1 other trigger). Along the way it connects Groq Chat Model, Google Sheets and Gmail. It also calls api.apollo.io over HTTP.

How it runs

Trigger: Manually, when you click “Execute workflow” (plus 1 other trigger).

  1. Fetch Leads from Sheet (Google Sheets): uses Google Sheets
  2. Apollo — Search Leads (HTTP Request): calls api.apollo.io (POST)
  3. Filter Pending Leads (If): checks a condition and branches into true / false
  4. Extract People Data (Code): runs custom JavaScript code
  5. Email Generation Loop (Loop Over Items (Split in Batches)): loops over the items in batches
  6. Process Each Lead (Loop Over Items (Split in Batches)): loops over the items in batches
  7. Fetch Leads for Mail (Google Sheets): uses Google Sheets
  8. AI Cold Email Writer (AI Agent): runs an AI agent, with model: Groq LLM (Fast AI); output parser: Parse Email JSON
  9. Merge: merges the data from its input branches
  10. Fetch Existing Lead IDs (Google Sheets): uses Google Sheets

…plus 14 more steps. See the full node list below.

Services it uses

Groq Chat ModelGoogle SheetsGmail

HTTP calls to: api.apollo.io

Before you upgrade to n8n 3.0

Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.

Nodes used (15)

From the author

This n8n workflow automates your entire B2B outreach pipeline from lead discovery to personalized cold email delivery. Submit a form, let Apollo find and enrich your leads, review AI-generated emails in your sheet and send them all with one click. How it…

Excerpt from Shreya Bhingarkar's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.