Templates / Qualify Facebook lead ads and send follow-ups with Gemini, Gmail, and Sheets

Qualify Facebook lead ads and send follow-ups with Gemini, Gmail, and Sheets

Ready for 3.0

by Hassan ✓ · 218 views · created 2026-07-20 · Lead Generation, AI Summarization

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 14 nodes and runs when an HTTP POST request hits its webhook URL (plus 1 other trigger). Along the way it connects Facebook Lead Ads, Google Gemini, Google Sheets and Gmail and 2 more.

How it runs

Trigger: When an HTTP POST request hits its webhook URL (plus 1 other trigger).

  1. Extract & Normalize Lead Details (Code): runs custom JavaScript code
  2. Qualify & Draft Follow-Up (Google Gemini): uses Google Gemini
  3. Parse AI Output (Code): runs custom JavaScript code
  4. Has Email? (If): checks a condition and branches into true / false
  5. Has Phone? (If): checks a condition and branches into true / false
  6. Send Follow-Up Email (Gmail): uses Gmail
  7. Log to Facebook Leads Sheet (Google Sheets): append
  8. Send WhatsApp Follow-Up (WhatsApp Business Cloud): send
  9. Is Lead Hot? (If): checks a condition and branches into true / false
  10. Notify Agent — Hot Lead (Gmail): uses Gmail

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

Services it uses

Facebook Lead AdsGoogle GeminiGoogle SheetsGmailWhatsApp Business CloudSlack

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 (9)

From the author

Quick overview Turn every Facebook ad lead into a qualified, followed-up prospect within seconds. AI scores their intent, sends a personalized email tailored to their score, logs campaign intelligence to Google Sheets, and alerts you instantly to hot leads…

Excerpt from Hassan'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.