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

Description

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 Gmail summary. How it works Receives a new lead via a POST webhook (only if an email or phone number is present) or runs nightly on a schedule. Normalizes the lead fields, generates a SHA-256 lead key from email/phone, and checks an n8n Data Table for a recent matching lead. If the lead is new (not seen within the repeat window), inserts it into the Data Table and sends a Gmail alert to the owner containing a private “mark as answered” resume link. Waits until the owner opens the “answered” link or until the reminder time limit expires. If marked answered, updates the Data Table row with an answered timestamp; otherwise, sends one Gmail reminder and records the reminder timestamp. Every evening, pulls today’s Data Table rows, calculates received/answered-in-time/open/reminded counts, and emails the daily summary via Gmail. Setup Create an n8n Data Table with columns lead_key, name, email, phone, source (text) and received_at, answered_at, reminded_at (date/time), then select it in all Data Table nodes. Add a Gmail OAuth2 credential for the Gmail nodes used to send the alert, reminder, and daily summary. Update the “Your settings” values (owner email, reminder minutes, repeat window days, and timezone) to match your team’s requirements. Copy the webhook production URL from the lead webhook and configure your form tool to send a POST request with lead fields (name, email, phone, message, source). Requirements A Gmail account and n8n with Data Tables Customization Swap the Gmail nodes for Slack, Telegram or Outlook, change the evening summary time and timezone, or add Header Auth to the webhook if your form can send a header. Additional info Made by Betterlane. Step-by-step guide: https://betterlaneagency.com/learn/n8n-workflow-runs-twice. An n8n automation workflow template by Thiago Cavalcanti.

Community Metrics

Categories

• Automation

Tags

• n8n
• workflow
• gmail
• code

Capabilities

• 2 nodes

Information