Loading page...Загружаем страницу...正在加载页面...
AtlasRepo

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

Source

daysFromDue = today − due_date, where today is the date in the workflow timezone: $today.toFormat('yyyy-MM-dd'), not new Date().toISOString()

Source

Send only if that stage's index is greater than the stored last_stage_sent index (idempotent).

Source

Send Email v2.1 appends an n8n attribution footer by default. Turn it off under Options.

Source

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.

Source

  • Record date: 2026-10-17T05:41:20.443Z