Templates / Send lead alerts, one reminder and daily summaries with Gmail and Data Tables

Send lead alerts, one reminder and daily summaries with Gmail and Data Tables

Ready for 3.0

by Thiago Cavalcanti ✓ · 4 views · created 2026-09-30 · Lead Generation

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 workflow has 18 nodes and runs when an HTTP POST request hits its webhook URL (plus 1 other trigger). Along the way it connects Gmail.

How it runs

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

  1. Your settings (Edit Fields (Set)): sets 4 fields: ownerEmail, reminderMinutes, repeatWindowDays…
  2. A new lead? (otherwise the evening summary) (If): checks a condition and branches into true / false
  3. Clean up the lead (Edit Fields (Set)): sets 7 fields: name, email, phone…
  4. Get today's leads (Data table): get (row)
  5. Look for the same lead (Data table): get (row)
  6. Count the day (Code): runs custom JavaScript code
  7. Seen within the repeat window? (If): checks a condition and branches into true / false
  8. Email the daily summary (Gmail): send (message)
  9. Store the lead (Data table): insert (row)
  10. Alert the owner (Gmail): send (message)

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

Services it uses

Gmail

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 This workflow accepts website leads via a webhook, deduplicates and stores them in an n8n Data Table, emails the owner a Gmail alert with an “answered” link, sends a single reminder after 30 minutes if not marked answered, and delivers a daily…

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