Airtable Due Alerts to Gmail in n8n (No Duplicate Emails)

Airtable Due Alerts to Gmail in n8n—without duplicate emails

This n8n workflow checks your Airtable for overdue “Next Action At” 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.

What this workflow does

• Runs on schedule (every 10 minutes) or via a Manual Test trigger to start the due-item check.
• Searches Airtable for records where “Next Action At” is set and due, while excluding statuses such as Done, Closed, Rejected, or Suppressed.
• Deduplicates alerts by tracking a key in workflow static data based on the Airtable record, the `Next Action At` timestamp, and the Next Action text—so repeated runs won’t spam the same due item.
• Builds one email containing a single subject and a message listing all newly due items in time order.
• Sends the internal summary using the Gmail node to your configured recipient.

Use cases

• SaaS operators who need reliable internal reminders for overdue tasks tracked in Airtable.
• Automation engineers building operational alerting with n8n, Airtable, and Gmail.
• Teams managing follow-ups who want due-action notifications without duplicate emails during repeated scheduled checks.

Technical details

• Nodes / components: code, Airtable, Gmail, sticky note, manual trigger, schedule trigger
• Required Airtable fields: Status, Next Action, Next Action At (plus display fields like Company, Name, or Title)
• Workflow behavior: scheduled every 10 minutes; dedupe via workflow static data; summary email with due items in time order

Setup tip: Add Airtable and Gmail credentials, update your Base/Table IDs, then run the Manual Test before enabling the scheduled trigger to confirm duplicate suppression.