Quick overview
Quick overview This workflow runs every morning, reads an invoice tracker from Google Sheets, and uses Gmail to send escalating reminder emails for unpaid invoices based on how many days they are overdue, then logs reminder activity back to the spreadsheet and alerts you when a final notice is sent. How it works Runs every day at 9:00. Reads all rows from the Invoices tab in Google Sheets. Filters to unpaid invoices that are at least 3 days overdue and have not been emailed in the last 7 days, then assigns an escalation tier (1, 2, or 3) and drafts an email subject and body. Sends the reminder email to the client via Gmail. Updates the same Google Sheets row with the new RemindersSent count and LastReminderDate. When the reminder is a tier-3 final notice, sends an additional escalation alert to your email address via Gmail. Setup Create or adapt a Google Sheet with an Invoices tab and the required columns (including Status, DueDate, ClientEmail, LastReminderDate, and RemindersSent). Add Google Sheets credentials in n8n and replace YOUR_GOOGLE_SHEET_ID in both Google Sheets nodes with your document ID. Add Gmail credentials in n8n for sending client reminders and internal alerts. Customize the tier 1/2/3 email templates in the code step to match your wording and payment terms. Replace you@yourcompany.com in the escalation alert email step with your own address. Requirements Google account with Google Sheets and Gmail access (credentials connected in n8n) Customization Change the escalation tier thresholds (3/14/30 days) and the 7-day throttle — they are single constants in the code step Swap Gmail for SMTP or Outlook by replacing the two email steps Add a Slack or Telegram alert step next to the escalation email for instant notifications Additional info The email templates are deliberately plain text strings in one code step, so you can rewrite them in your own voice without touching the logic. Need this wired into QuickBooks, Xero or Stripe, SMS/WhatsApp escalation, or a multi-client version? I build custom versions with async delivery — contact links in my creator profile. An n8n automation workflow template by Vitaliy Voitik.
Vitaliy Voitik
web
free
Others in the same category, ranked by how often they are opened.
