{"product_id":"n8n-lead-alerts-workflow-gmail-alerts-reminder-daily-summary","title":"n8n Lead Alerts Workflow: Gmail Alerts, Reminder \u0026 Daily Summary","description":"\u003ch3\u003eNever miss a website lead: instant Gmail alerts + reminders + daily summaries (n8n)\u003c\/h3\u003e\n\u003cp\u003eThis n8n Lead Alerts Workflow automatically captures new website leads via a \u003cb\u003ewebhook\u003c\/b\u003e (or runs nightly), deduplicates them in an \u003cb\u003en8n Data Table\u003c\/b\u003e, sends a \u003cb\u003eGmail alert\u003c\/b\u003e with an “answered” link, issues a one-time reminder after 30 minutes if unanswered, and emails an \u003cb\u003eevening daily summary\u003c\/b\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eReceives leads\u003c\/b\u003e through a POST webhook when an \u003cb\u003eemail or phone\u003c\/b\u003e is present, or runs nightly on a schedule.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eNormalizes \u0026amp; deduplicates\u003c\/b\u003e lead fields, generates a \u003cb\u003eSHA-256 lead key\u003c\/b\u003e from email\/phone, and checks the Data Table for a recent matching lead within a configurable repeat window.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eSends a Gmail alert\u003c\/b\u003e to the owner for new leads only, including a private “mark as answered” resume link.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eWaits for confirmation\u003c\/b\u003e until the owner opens the “answered” link, or until the reminder time limit expires.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eIssues a reminder once\u003c\/b\u003e: if not answered in time, it sends one Gmail reminder and records \u003cb\u003ereminded_at\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eSends a daily summary\u003c\/b\u003e every evening by pulling today’s Data Table rows and calculating counts (received, answered-in-time, opened, reminded), then emailing them via Gmail.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eA SaaS operator wants immediate visibility when prospects submit a contact form, without duplicate notifications.\u003c\/li\u003e\n  \u003cli\u003eAn automation engineer needs a reliable lead tracking flow with “answered” state managed inside n8n.\u003c\/li\u003e\n  \u003cli\u003eA small team uses Gmail as the single source of notifications while still getting daily performance metrics.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eIntegrations\/Nodes:\u003c\/b\u003e \u003ccode\u003eif\u003c\/code\u003e, \u003ccode\u003eset\u003c\/code\u003e, \u003ccode\u003ecode\u003c\/code\u003e, \u003ccode\u003eno op\u003c\/code\u003e, \u003ccode\u003ewait\u003c\/code\u003e, \u003ccode\u003egmail\u003c\/code\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eStorage:\u003c\/b\u003e \u003cb\u003en8n Data Table\u003c\/b\u003e with columns like \u003ccode\u003elead_key\u003c\/code\u003e, \u003ccode\u003ename\u003c\/code\u003e, \u003ccode\u003eemail\u003c\/code\u003e, \u003ccode\u003ephone\u003c\/code\u003e, \u003ccode\u003esource\u003c\/code\u003e, \u003ccode\u003ereceived_at\u003c\/code\u003e, \u003ccode\u003eanswered_at\u003c\/code\u003e, \u003ccode\u003ereminded_at\u003c\/code\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eAuth:\u003c\/b\u003e Gmail OAuth2 credentials for alert, reminder, and daily summary emails\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eKey logic:\u003c\/b\u003e SHA-256 lead key + repeat-window deduplication\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46146448457907,"sku":"N8N-20212","price":39.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/OxGAZTHTGp1e1P0-qIWCu_ccBUePh0.png?v=1790846991","url":"https:\/\/buyflowscripts.com\/products\/n8n-lead-alerts-workflow-gmail-alerts-reminder-daily-summary","provider":"N8N Commerce","version":"1.0","type":"link"}