Discover, enrich, and email LinkedIn leads with Apify, Gmail, Gemini, and Sheets

by Dinakar Selvakumar ✓ · 135 views · created 2026-04-07 · Lead Generation, Multimodal AI

What this workflow does

This AI workflow has 36 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets, Google Gemini and Gmail. It also calls api.apify.com over HTTP.

How it runs

Trigger: Manually, when you click “Execute workflow”.

1. Read Leads for Outreach (Google Sheets): uses Google Sheets
2. Check Email Sent Status (If): checks a condition and branches into true / false
3. Batch Process Email Leads (Loop Over Items (Split in Batches)): loops over the items in batches
4. Send Initial Email via Gmail (Gmail): send and wait for a reply
5. Check Response to Email (If): checks a condition and branches into true / false
6. Append Email 1 Response (Google Sheets): append or update
7. Wait: waits 1 days
8. Send Follow-Up Email (Gmail): send and wait for a reply
9. Check Response to Email (If): checks a condition and branches into true / false
10. Append Email 2 Response (Google Sheets): append or update

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

Services it uses

Google SheetsGoogle GeminiGmail

HTTP calls to: api.apify.com

Before you upgrade to n8n 3.0

Nodes used (9)

• HTTP Requestn8n-nodes-base.httpRequest
• Coden8n-nodes-base.code
• Google Sheetsn8n-nodes-base.googleSheets
• Loop Over Items (Split in Batches)n8n-nodes-base.splitInBatches
• Ifn8n-nodes-base.if
• Google Gemini@n8n/n8n-nodes-langchain.googleGemini
• Manual Triggern8n-nodes-base.manualTrigger
• Gmailn8n-nodes-base.gmail
• Waitn8n-nodes-base.wait

From the author

Automate LinkedIn lead discovery, enrichment, and email follow-ups using Apify and Google Sheets --- What this template demonstrates - End-to-end lead pipeline (discovery → enrichment → outreach) - Google Search–based LinkedIn discovery (safe approach) -…

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