Build an invoice reminder workflow in n8n with Google Sheets (idempotent, AU GST wording)

Описание и применение

Автоматизированный, идемпотентный процесс отправки напоминаний об оплате счетов с учётом часового пояса, корректной обработки дат и формулировок GST в Австралии.

Задача

Automate sending invoice reminders based on due dates while handling time zones, date formats, idempotency, and GST wording.

Результат

Automated, idempotent invoice reminders with correct timezone-aware date logic, robust date parsing, and AU GST wording.

Рабочий процесс

• 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)

Доказательства

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.

Источник