Send automated invoice payment reminders with Gmail, Google Sheets and Twilio — n8n 工作流
概览
This workflow streamlines accounts receivable management by automatically monitoring invoices in Google Sheets and sending scheduled payment reminders. It is designed for businesses using Gmail and Google Sheets that need a scalable alternative to complex accounting software.
How it works Watches for invoices: Triggers daily or via form submission to check for new entries. First Follow-up (Day 7): Checks payment status one week after the invoice date. If unpaid, it sends a friendly email (and o
使用的节点
Google SheetsTwilioGmail
工作流预览
⚡
I
Invoice Form Submission …
W
Wait 7 Days for First Fo…
Send First Payment Remin…
Check Payment Status in …
I
If Still Unpaid - First …
Send First SMS Reminder …
W
Wait 2 Days for Second F…
Check Payment Status in …
I
If Still Unpaid - Second…
Send Second Payment Remi…
Send Second SMS Reminder…
W
Wait 3 Days for Final Fo…
Check Payment Status in …
I
If Still Unpaid - Third …
Send Final Payment Remin…
Send Final SMS Reminder …
P
Process Complete
17 nodes18 edges
工作原理
- 1
触发器
工作流由 触发器 触发器启动。
- 2
处理
数据流经 17 个节点, connecting formtrigger, gmail, googlesheets。
- 3
输出
工作流完成自动化并将结果发送到配置的目标。
节点详情 (17)
GO#1
Google Sheets
googleSheets
TW#2
Twilio
twilio
GM#3
Gmail
gmail
如何导入此工作流
- 1点击右侧 下载 JSON 按钮保存工作流文件。
- 2打开你的 n8n 实例,依次点击 工作流 → 新建 → 从文件导入。
- 3选择下载的
send-automated-invoice-payment-reminders-with-gmail-google-sheets-and-twilio文件并点击导入。 - 4为每个服务节点配置 凭证(API 密钥、OAuth 等)。
- 5点击 测试工作流 验证一切正常,然后激活它。
或直接在 n8n → 从 JSON 导入 中粘贴:
{ "name": "Send automated invoice payment reminders with Gmail, Google Sheets and Twilio", "nodes": [...], ...}
集成
formtriggergmailgooglesheetsiftwiliowait
创建者
Neal Mcleod
@ctk-industries
标签
formtriggergmailgooglesheetsiftwiliowait