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

说明与用途

在 n8n 与 Google Sheets 中实现的自动发票提醒工作流，支持澳大利亚 GST 词汇和防止重复发送，使用本地 SMTP 捕获器进行测试。

问题

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

来源