Invoice Management System with Gmail Reminders, Google Sheets, and Slack Escalations — n8n 工作流
概览
Who is this for?
This template is designed for freelancers, small businesses, and finance teams who need automated invoice management with intelligent payment follow-ups. Perfect for service providers, agencies, or any business that needs to track receivables and reduce late payments.
What this workflow does
This workflow provides complete invoice lifecycle management with two main flows:
Invoice Generation Flow: Receives order data via webhook with line items Splits line items using Split O
使用的节点
Google SheetsSlackGmailCode
工作流预览
⚡
N
New Invoice Request
I
Initialize Invoice
S
Split Line Items
Calculate Line Total
A
Aggregate Line Items
Build Invoice Object
Save Invoice to Sheet
Send Invoice Email
⚡
I
Invoice Created Response
⚡
D
Daily Overdue Check
Get Unpaid Invoices
Calculate Overdue Days
L
Loop Over Invoices
R
Route by Reminder Level
First Reminder Email
Second Reminder Email
Urgent Reminder Email
Final Notice Email
Escalate to Collections
M
Merge Reminder Paths
Update Reminder Date
Continue Loop
22 nodes25 edges
工作原理
- 1
触发器
工作流由 webhook 触发器启动。
- 2
处理
数据流经 22 个节点, connecting aggregate, code, gmail。
- 3
输出
工作流完成自动化并将结果发送到配置的目标。
节点详情 (22)
GO#1
Google Sheets
googleSheets
SL#2
Slack
slack
GM#3
Gmail
gmail
CO#4
Code
code
如何导入此工作流
- 1点击右侧 下载 JSON 按钮保存工作流文件。
- 2打开你的 n8n 实例,依次点击 工作流 → 新建 → 从文件导入。
- 3选择下载的
invoice-management-system-with-gmail-reminders-google-sheets-and-slack-escalations文件并点击导入。 - 4为每个服务节点配置 凭证(API 密钥、OAuth 等)。
- 5点击 测试工作流 验证一切正常,然后激活它。
或直接在 n8n → 从 JSON 导入 中粘贴:
{ "name": "Invoice Management System with Gmail Reminders, Google Sheets, and Slack Escalations", "nodes": [...], ...}
集成
aggregatecodegmailgooglesheetsmergerespondtowebhookscheduletriggersetslacksplitinbatchessplitoutswitchwebhook
创建者
飯盛 正幹
@isakai
标签
aggregatecodegmailgooglesheetsmergerespondtowebhookscheduletriggersetslacksplitinbatches