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

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

Автоматизированный процесс отправки напоминаний об оплате с учётом австралийского НДС и предотвращением дублирования, реализованный в n8n и Google Sheets.

Задача

Automate sending invoice reminders while avoiding duplicate emails and handling AU GST wording.

Результат

Daily reminders sent idempotently, AU GST wording applied, sheet updated with last_stage_sent and last_sent_date.

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

• Schedule Trigger (daily 9am, workflow timezone set)
• Google Sheets "Get rows"
• Code node (decision logic)
• 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).

Источник

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

Источник

Test against a local SMTP catcher (e.g. Python aiosmtpd) before touching a real inbox.

Источник

If the business is GST-registered: "Tax invoice … Total includes GST of $X", where X = total ÷ 11 rounded to the cent. Otherwise: "Invoice … No GST has been charged".

Источник