{"product_id":"airtable-due-alerts-to-gmail-in-n8n-no-duplicate-emails","title":"Airtable Due Alerts to Gmail in n8n (No Duplicate Emails)","description":"\u003ch3\u003eAirtable Due Alerts to Gmail in n8n—without duplicate emails\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow checks your Airtable for overdue \u003cstrong\u003e“Next Action At”\u003c\/strong\u003e items every 10 minutes and sends a clean internal due-action summary to Gmail—while actively suppressing duplicate notifications for the same record and due time.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on schedule (every 10 minutes)\u003c\/strong\u003e or via a \u003cstrong\u003eManual Test\u003c\/strong\u003e trigger to start the due-item check.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSearches Airtable\u003c\/strong\u003e for records where \u003cstrong\u003e“Next Action At”\u003c\/strong\u003e is set and \u003cem\u003edue\u003c\/em\u003e, while excluding statuses such as \u003cstrong\u003eDone, Closed, Rejected,\u003c\/strong\u003e or \u003cstrong\u003eSuppressed\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDeduplicates alerts\u003c\/strong\u003e by tracking a key in workflow static data based on the \u003cstrong\u003eAirtable record\u003c\/strong\u003e, the `Next Action At` timestamp, and the \u003cstrong\u003eNext Action\u003c\/strong\u003e text—so repeated runs won’t spam the same due item.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBuilds one email\u003c\/strong\u003e containing a single subject and a message listing all newly due items in \u003cstrong\u003etime order\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends the internal summary\u003c\/strong\u003e using the \u003cstrong\u003eGmail\u003c\/strong\u003e node to your configured recipient.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSaaS operators\u003c\/strong\u003e who need reliable internal reminders for overdue tasks tracked in Airtable.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAutomation engineers\u003c\/strong\u003e building operational alerting with n8n, Airtable, and Gmail.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTeams managing follow-ups\u003c\/strong\u003e who want due-action notifications without duplicate emails during repeated scheduled checks.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes \/ components:\u003c\/strong\u003e code, Airtable, Gmail, sticky note, manual trigger, schedule trigger\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRequired Airtable fields:\u003c\/strong\u003e \u003cstrong\u003eStatus\u003c\/strong\u003e, \u003cstrong\u003eNext Action\u003c\/strong\u003e, \u003cstrong\u003eNext Action At\u003c\/strong\u003e (plus display fields like \u003cstrong\u003eCompany\u003c\/strong\u003e, \u003cstrong\u003eName\u003c\/strong\u003e, or \u003cstrong\u003eTitle\u003c\/strong\u003e)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow behavior:\u003c\/strong\u003e scheduled every 10 minutes; dedupe via workflow static data; summary email with due items in time order\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003e\u003cstrong\u003eSetup tip:\u003c\/strong\u003e Add Airtable and Gmail credentials, update your Base\/Table IDs, then run the \u003cstrong\u003eManual Test\u003c\/strong\u003e before enabling the scheduled trigger to confirm duplicate suppression.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46075754610867,"sku":"N8N-19825","price":42.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/fDID_o5Yr3F7B3f4p9I1n_VvGpGOHV.png?v=1790154318","url":"https:\/\/buyflowscripts.com\/products\/airtable-due-alerts-to-gmail-in-n8n-no-duplicate-emails","provider":"N8N Commerce","version":"1.0","type":"link"}