n8n Lead Alerts Workflow: Gmail Alerts, Reminder & Daily Summary

Never miss a website lead: instant Gmail alerts + reminders + daily summaries (n8n)

This n8n Lead Alerts Workflow automatically captures new website leads via a webhook (or runs nightly), deduplicates them in an n8n Data Table, sends a Gmail alert with an “answered” link, issues a one-time reminder after 30 minutes if unanswered, and emails an evening daily summary.

What this workflow does

• Receives leads through a POST webhook when an email or phone is present, or runs nightly on a schedule.
• Normalizes & deduplicates lead fields, generates a SHA-256 lead key from email/phone, and checks the Data Table for a recent matching lead within a configurable repeat window.
• Sends a Gmail alert to the owner for new leads only, including a private “mark as answered” resume link.
• Waits for confirmation until the owner opens the “answered” link, or until the reminder time limit expires.
• Issues a reminder once: if not answered in time, it sends one Gmail reminder and records reminded_at.
• Sends a daily summary every evening by pulling today’s Data Table rows and calculating counts (received, answered-in-time, opened, reminded), then emailing them via Gmail.

Use cases

• A SaaS operator wants immediate visibility when prospects submit a contact form, without duplicate notifications.
• An automation engineer needs a reliable lead tracking flow with “answered” state managed inside n8n.
• A small team uses Gmail as the single source of notifications while still getting daily performance metrics.

Technical details

• Integrations/Nodes: if, set, code, no op, wait, gmail
• Storage: n8n Data Table with columns like lead_key, name, email, phone, source, received_at, answered_at, reminded_at
• Auth: Gmail OAuth2 credentials for alert, reminder, and daily summary emails
• Key logic: SHA-256 lead key + repeat-window deduplication