Build an invoice reminder workflow in n8n with Google Sheets (idempotent, AU GST wording)
Description and use
Automated, idempotent invoice reminder workflow with timezone-aware date handling, robust date parsing, and AU GST wording.
Problem
Automate sending invoice reminders based on due dates while handling time zones, date formats, idempotency, and GST wording.
Outcome
Automated, idempotent invoice reminders with correct timezone-aware date logic, robust date parsing, and AU GST wording.
Workflow
- Schedule Trigger (daily 9am, workflow timezone set)
- Google Sheets Get rows
- Code node to decide which rows need reminders
- Send Email (SMTP)
- Google Sheets Update row (match on row_number)
Evidence
Schedule Trigger (daily 9am, workflow timezone set) → Google Sheets "Get rows" → Code node (decide) → Send Email (SMTP) → Google Sheets "Update row" (match on row_number).
daysFromDue = today − due_date, where today is the date in the workflow timezone: $today.toFormat('yyyy-MM-dd'), not new Date().toISOString()
Send only if that stage's index is greater than the stored last_stage_sent index (idempotent).
Send Email v2.1 appends an n8n attribution footer by default. Turn it off under Options.
Google Sheets can hand you a date cell as a serial number (46312 is 17 Oct 2026), depending on the Get rows node's Options → Output Formatting → Date Formatting.
- Record date: 2026-10-17T05:41:20.443Z