Invoice Creator with Google Sheets & Automated Email Payment Reminder System — n8n 工作流
概览
This automated n8n workflow streamlines invoice creation and payment reminders. It generates invoices on a monthly schedule and sends reminders for overdue payments, updating records in Google Sheets.
Good to Know Supports monthly invoice generation and daily overdue checks Integrates with Google Sheets for data management Uses email notifications for invoice delivery and reminders Includes logging for tracking and auditing Features multiple reminder types based on overdue duration
How It Work
使用的节点
Send EmailGoogle SheetsCode
工作流预览
⚡
M
Monthly Invoice Trigger
⚡
D
Daily Payment Reminder C…
Get Clients for Invoicing
Get Overdue Invoices
Filter Active Clients
Filter Overdue Invoices
Generate Invoice Data
Save Invoice to Google S…
Send Invoice Email
Calculate Reminder Type
S
Switch Reminder Type
Send Gentle Reminder
Send Follow-up Reminder
Send Urgent Reminder
Send Final Notice
Update Reminder Log
Log Invoice Creation
17 nodes18 edges
工作原理
- 1
触发器
工作流由 定时 触发器启动,按预定计划运行。
- 2
处理
数据流经 17 个节点, connecting code, cron, emailsend。
- 3
输出
工作流完成自动化并将结果发送到配置的目标。
节点详情 (17)
SE#1
Send Email
emailSend
GO#2
Google Sheets
googleSheets
CO#3
Code
code
如何导入此工作流
- 1点击右侧 下载 JSON 按钮保存工作流文件。
- 2打开你的 n8n 实例,依次点击 工作流 → 新建 → 从文件导入。
- 3选择下载的
invoice-creator-with-google-sheets-automated-email-payment-reminder-system文件并点击导入。 - 4为每个服务节点配置 凭证(API 密钥、OAuth 等)。
- 5点击 测试工作流 验证一切正常,然后激活它。
或直接在 n8n → 从 JSON 导入 中粘贴:
{ "name": "Invoice Creator with Google Sheets & Automated Email Payment Reminder System", "nodes": [...], ...}
集成
codecronemailsendgooglesheetsswitch
创建者
Oneclick AI Squad
@oneclick-ai
标签
codecronemailsendgooglesheetsswitch