Send lead alerts, one reminder and daily summaries with Gmail and Data Tables
Ready for 3.0What 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).
- Your settings (Edit Fields (Set)): sets 4 fields: ownerEmail, reminderMinutes, repeatWindowDays…
- A new lead? (otherwise the evening summary) (If): checks a condition and branches into true / false
- Clean up the lead (Edit Fields (Set)): sets 7 fields: name, email, phone…
- Get today's leads (Data table): get (row)
- Look for the same lead (Data table): get (row)
- Count the day (Code): runs custom JavaScript code
- Seen within the repeat window? (If): checks a condition and branches into true / false
- Email the daily summary (Gmail): send (message)
- Store the lead (Data table): insert (row)
- Alert the owner (Gmail): send (message)
…plus 5 more steps. See the full node list below.
Services it uses
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)
- Webhook
n8n-nodes-base.webhook - Edit Fields (Set)
n8n-nodes-base.set - Schedule Trigger
n8n-nodes-base.scheduleTrigger - If
n8n-nodes-base.if - Data table
n8n-nodes-base.dataTable - No Operation, do nothing
n8n-nodes-base.noOp - Gmail
n8n-nodes-base.gmail - Wait
n8n-nodes-base.wait - Code
n8n-nodes-base.code
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…