面向财务与会计的 AI 驱动发票提醒与付款追踪器
高级
这是一个Invoice Processing, Multimodal AI领域的自动化工作流，包含 35 个节点。主要使用 If, Set, Code, Webhook, Postgres 等节点。 基于AI的发票提醒与付款追踪器，专为财务与会计设计
前置要求
- •HTTP Webhook 端点（n8n 会自动生成）
- •PostgreSQL 数据库连接信息
- •OpenAI API Key
使用的节点 (35)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "uOMGyPBvAP5ytb64",
"meta": {
"instanceId": "dd69efaf8212c74ad206700d104739d3329588a6f3f8381a46a481f34c9cc281",
"templateCredsSetupCompleted": true
},
"name": "面向财务与会计的 AI 驱动发票提醒与付款追踪器",
"tags": [],
"nodes": [
{
"id": "5e70b579-3fec-471f-8788-2205c066e21f",
"name": "每日检查计划",
"type": "n8n-nodes-base.scheduleTrigger",
"notes": "Runs every day at 9 AM",
"position": [
0,
-304
],
"parameters": {
"rule": {
"interval": [
{
"field": "cronExpression",
"expression": "0 9 * * *"
}
]
}
},
"notesInFlow": true,
"typeVersion": 1.2
},
{
"id": "75c19552-8451-4c27-978c-54d6ea422b84",
"name": "获取待处理发票",
"type": "n8n-nodes-base.postgres",
"notes": "Query database for unpaid/overdue invoices",
"position": [
224,
-304
],
"parameters": {
"query": "SELECT \n invoice_id,\n client_name,\n client_email,\n invoice_number,\n invoice_amount,\n currency,\n issue_date,\n due_date,\n payment_status,\n days_overdue,\n last_reminder_sent\nFROM invoices \nWHERE payment_status != 'paid' \nAND due_date <= CURRENT_DATE + INTERVAL '7 days'\nORDER BY due_date ASC;",
"options": {},
"operation": "executeQuery"
},
"credentials": {
"postgres": {
"id": "4Y4qEFGqF2krfRHZ",
"name": "Postgres-test"
}
},
"notesInFlow": true,
"typeVersion": 2.4
},
{
"id": "3bf276a9-2041-4f5c-995c-ca3ffb4f0cd0",
"name": "筛选逾期发票",
"type": "n8n-nodes-base.if",
"notes": "Separate overdue from upcoming",
"position": [
448,
-304
],
"parameters": {
"options": {},
"conditions": {
"options": {
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "condition-1",
"operator": {
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.payment_status }}",
"rightValue": "unpaid"
},
{
"id": "condition-2",
"operator": {
"type": "number",
"operation": "gte"
},
"leftValue": "={{ $json.days_overdue }}",
"rightValue": 0
}
]
}
},
"notesInFlow": true,
"typeVersion": 2
},
{
"id": "000ea7a3-3db4-409d-bdea-b416590933e4",
"name": "计算提醒逻辑",
"type": "n8n-nodes-base.code",
"notes": "Smart logic for reminder timing",
"position": [
672,
-304
],
"parameters": {
"jsCode": "const invoices = $input.all();\nconst today = new Date();\nconst results = [];\n\nfor (const invoice of invoices) {\n const dueDate = new Date(invoice.json.due_date);\n const issueDate = new Date(invoice.json.issue_date);\n const lastReminder = invoice.json.last_reminder_sent ? new Date(invoice.json.last_reminder_sent) : null;\n \n // Calculate days overdue\n const daysOverdue = Math.floor((today - dueDate) / (1000 * 60 * 60 * 24));\n \n // Calculate days since last reminder\n const daysSinceReminder = lastReminder ? Math.floor((today - lastReminder) / (1000 * 60 * 60 * 24)) : 999;\n \n // Determine reminder type and urgency\n let reminderType = '';\n let urgencyLevel = '';\n let shouldSendReminder = false;\n \n if (daysOverdue > 30 && daysSinceReminder >= 3) {\n reminderType = 'final_notice';\n urgencyLevel = 'critical';\n shouldSendReminder = true;\n } else if (daysOverdue > 14 && daysSinceReminder >= 5) {\n reminderType = 'second_reminder';\n urgencyLevel = 'high';\n shouldSendReminder = true;\n } else if (daysOverdue > 0 && daysSinceReminder >= 7) {\n reminderType = 'first_reminder';\n urgencyLevel = 'medium';\n shouldSendReminder = true;\n } else if (daysOverdue === 0) {\n reminderType = 'due_today';\n urgencyLevel = 'medium';\n shouldSendReminder = true;\n } else if (daysOverdue < 0 && daysOverdue >= -3 && !lastReminder) {\n reminderType = 'upcoming_reminder';\n urgencyLevel = 'low';\n shouldSendReminder = true;\n }\n \n if (shouldSendReminder) {\n results.push({\n json: {\n ...invoice.json,\n daysOverdue,\n daysSinceReminder,\n reminderType,\n urgencyLevel,\n shouldSendReminder\n }\n });\n }\n}\n\nreturn results;"
},
"notesInFlow": true,
"typeVersion": 2
},
{
"id": "2879e970-5943-4a87-b74c-dd92e9c83662",
"name": "准备 AI 提示",
"type": "n8n-nodes-base.set",
"position": [
896,
-304
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "ai-prompt",
"name": "aiPrompt",
"type": "string",
"value": "=Generate a professional and friendly payment reminder email for the following invoice:\n\nClient Name: {{ $json.client_name }}\nInvoice Number: {{ $json.invoice_number }}\nAmount: {{ $json.currency }} {{ $json.invoice_amount }}\nIssue Date: {{ $json.issue_date }}\nDue Date: {{ $json.due_date }}\nDays Overdue: {{ $json.daysOverdue }}\nReminder Type: {{ $json.reminderType }}\nUrgency: {{ $json.urgencyLevel }}\n\nThe email should:\n- Be courteous and professional\n- Clearly state the outstanding amount and invoice details\n- Mention the due date and overdue status if applicable\n- Include a polite call-to-action for payment\n- Provide payment instructions or link\n- Be appropriately urgent based on the reminder type\n- End with a professional signature\n\nFormat the response as a complete email with subject line."
}
]
}
},
"typeVersion": 3.4
},
{
"id": "5e61c6ea-62df-4c69-95d8-5b5dd7a0eb66",
"name": "格式化邮件",
"type": "n8n-nodes-base.code",
"notes": "Format email with HTML styling",
"position": [
1472,
-304
],
"parameters": {
"jsCode": "const items = $input.all();\nconst results = [];\n\nfor (const item of items) {\n const aiResponse = item.json.message?.content || item.json.response || '';\n \n // Extract subject and body from AI response\n const subjectMatch = aiResponse.match(/Subject:(.+?)\\n/i);\n const subject = subjectMatch ? subjectMatch[1].trim() : `Payment Reminder - Invoice ${item.json.invoice_number}`;\n \n // Remove subject line from body\n let body = aiResponse.replace(/Subject:(.+?)\\n/i, '').trim();\n \n // Add invoice details table\n const invoiceTable = `\n <div style=\"background-color: #f5f5f5; padding: 20px; border-radius: 8px; margin: 20px 0;\">\n <h3 style=\"color: #333; margin-top: 0;\">Invoice Details</h3>\n <table style=\"width: 100%; border-collapse: collapse;\">\n <tr>\n <td style=\"padding: 8px; font-weight: bold;\">Invoice Number:</td>\n <td style=\"padding: 8px;\">${item.json.invoice_number}</td>\n </tr>\n <tr>\n <td style=\"padding: 8px; font-weight: bold;\">Amount:</td>\n <td style=\"padding: 8px;\">${item.json.currency} ${item.json.invoice_amount}</td>\n </tr>\n <tr>\n <td style=\"padding: 8px; font-weight: bold;\">Due Date:</td>\n <td style=\"padding: 8px;\">${item.json.due_date}</td>\n </tr>\n <tr>\n <td style=\"padding: 8px; font-weight: bold;\">Status:</td>\n <td style=\"padding: 8px; color: ${item.json.daysOverdue > 0 ? '#d32f2f' : '#f57c00'};\">\n ${item.json.daysOverdue > 0 ? `Overdue by ${item.json.daysOverdue} days` : 'Due Soon'}\n </td>\n </tr>\n </table>\n </div>\n `;\n \n // Convert body to HTML format\n body = body.replace(/\\n/g, '<br>').replace(/\\*\\*(.+?)\\*\\*/g, '<strong>$1</strong>');\n \n // Combine into HTML email\n const htmlBody = `\n <html>\n <body style=\"font-family: Arial, sans-serif; line-height: 1.6; color: #333;\">\n ${body.split('<br>')[0]}\n ${invoiceTable}\n ${body.split('<br>').slice(1).join('<br>')}\n <div style=\"margin-top: 30px; padding-top: 20px; border-top: 1px solid #ddd; font-size: 12px; color: #666;\">\n <p>This is an automated reminder. If you have already made the payment, please disregard this email.</p>\n </div>\n </body>\n </html>\n `;\n \n results.push({\n json: {\n ...item.json,\n emailSubject: subject,\n emailBody: htmlBody,\n emailBodyPlain: body.replace(/<[^>]*>/g, '')\n }\n });\n}\n\nreturn results;"
},
"notesInFlow": true,
"typeVersion": 2
},
{
"id": "49d9b854-ffda-4125-b07f-9997b799d5aa",
"name": "发送邮件提醒",
"type": "n8n-nodes-base.emailSend",
"notes": "Send the reminder email",
"position": [
1696,
-304
],
"webhookId": "b74f682a-e6cc-452f-b8ba-2d4390c6e61a",
"parameters": {
"options": {
"appendAttribution": false,
"allowUnauthorizedCerts": false
},
"subject": "={{ $json.emailSubject }}",
"toEmail": "abc@gmail.com",
"fromEmail": "xyz@gmail.com"
},
"credentials": {
"smtp": {
"id": "G1kyF8cSWTZ4vouN",
"name": "SMTP -test"
}
},
"notesInFlow": true,
"typeVersion": 2.1
},
{
"id": "6f307b3e-9222-4df7-a92b-9c7dbcea6d79",
"name": "更新提醒状态",
"type": "n8n-nodes-base.postgres",
"notes": "Log reminder sent in database",
"position": [
1920,
-304
],
"parameters": {
"query": "=UPDATE invoices \nSET \n last_reminder_sent = CURRENT_TIMESTAMP,\n reminder_count = reminder_count + 1,\n last_reminder_type = '{{ $json.reminderType }}'\nWHERE invoice_id = '{{ $json.invoice_id }}';",
"options": {},
"operation": "executeQuery"
},
"credentials": {
"postgres": {
"id": "4Y4qEFGqF2krfRHZ",
"name": "Postgres-test"
}
},
"notesInFlow": true,
"typeVersion": 2.4
},
{
"id": "07f23377-e924-49b1-b803-88aedd3de5bd",
"name": "创建活动日志",
"type": "n8n-nodes-base.set",
"position": [
2144,
-304
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "log-entry",
"name": "logEntry",
"type": "object",
"value": "={\n \"timestamp\": \"{{ $now.toISO() }}\",\n \"invoice_id\": \"{{ $json.invoice_id }}\",\n \"invoice_number\": \"{{ $json.invoice_number }}\",\n \"client_name\": \"{{ $json.client_name }}\",\n \"client_email\": \"{{ $json.client_email }}\",\n \"amount\": \"{{ $json.invoice_amount }}\",\n \"reminder_type\": \"{{ $json.reminderType }}\",\n \"urgency_level\": \"{{ $json.urgencyLevel }}\",\n \"days_overdue\": {{ $json.daysOverdue }},\n \"status\": \"reminder_sent\"\n}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "5884f963-de92-4613-ab16-5fc5bff620cd",
"name": "保存到活动日志",
"type": "n8n-nodes-base.postgres",
"position": [
2368,
-304
],
"parameters": {
"table": {
"__rl": true,
"mode": "list",
"value": "invoice_activity_log"
},
"schema": {
"__rl": true,
"mode": "list",
"value": "public"
},
"columns": {
"value": {},
"schema": [],
"mappingMode": "autoMapInputData",
"matchingColumns": []
},
"options": {}
},
"credentials": {
"postgres": {
"id": "4Y4qEFGqF2krfRHZ",
"name": "Postgres-test"
}
},
"typeVersion": 2.4
},
{
"id": "473efd7a-44f7-4724-a638-731e337e21e2",
"name": "生成每日摘要",
"type": "n8n-nodes-base.code",
"notes": "Create summary report",
"position": [
2592,
-304
],
"parameters": {
"jsCode": "const allItems = $input.all();\nconst summary = {\n totalReminders: allItems.length,\n byUrgency: {},\n byType: {},\n totalAmountOutstanding: 0,\n clients: []\n};\n\nfor (const item of allItems) {\n // Count by urgency\n summary.byUrgency[item.json.urgencyLevel] = (summary.byUrgency[item.json.urgencyLevel] || 0) + 1;\n \n // Count by type\n summary.byType[item.json.reminderType] = (summary.byType[item.json.reminderType] || 0) + 1;\n \n // Sum outstanding amounts\n summary.totalAmountOutstanding += parseFloat(item.json.invoice_amount);\n \n // Collect client info\n summary.clients.push({\n name: item.json.client_name,\n invoice: item.json.invoice_number,\n amount: item.json.invoice_amount,\n daysOverdue: item.json.daysOverdue,\n urgency: item.json.urgencyLevel\n });\n}\n\nreturn [{ json: summary }];"
},
"notesInFlow": true,
"typeVersion": 2
},
{
"id": "6a8c062f-093c-40cd-869f-e459ea3b0eac",
"name": "发送摘要给财务团队",
"type": "n8n-nodes-base.emailSend",
"position": [
2816,
-304
],
"webhookId": "ed662db6-84a8-4c6c-bef4-2ac72009a056",
"parameters": {
"options": {},
"subject": "=Daily Invoice Reminder Report - {{ $now.toFormat('yyyy-MM-dd') }}",
"toEmail": "abc@gmail.com",
"fromEmail": "xyz@gmail.com"
},
"credentials": {
"smtp": {
"id": "G1kyF8cSWTZ4vouN",
"name": "SMTP -test"
}
},
"typeVersion": 2.1
},
{
"id": "29cc7161-00b3-4ad6-8df4-e582296fc2ed",
"name": "Webhook：收到付款",
"type": "n8n-nodes-base.webhook",
"notes": "Trigger when payment is received",
"position": [
-48,
368
],
"webhookId": "invoice-payment-webhook",
"parameters": {
"path": "invoice-paid",
"options": {},
"httpMethod": "POST",
"responseMode": "responseNode"
},
"notesInFlow": true,
"typeVersion": 2
},
{
"id": "7338b886-106f-4aad-86b7-dd4cb743d8d1",
"name": "更新付款状态",
"type": "n8n-nodes-base.postgres",
"position": [
208,
368
],
"parameters": {
"query": "=UPDATE invoices \nSET \n payment_status = 'paid',\n payment_date = CURRENT_TIMESTAMP,\n payment_amount = {{ $json.body.amount }},\n payment_method = '{{ $json.body.payment_method }}'\nWHERE invoice_number = '{{ $json.body.invoice_number }}'\nRETURNING *;",
"options": {},
"operation": "executeQuery"
},
"credentials": {
"postgres": {
"id": "4Y4qEFGqF2krfRHZ",
"name": "Postgres-test"
}
},
"typeVersion": 2.4
},
{
"id": "f1699fe0-c7fe-48f7-9e39-62e983a7b063",
"name": "Webhook 响应",
"type": "n8n-nodes-base.respondToWebhook",
"position": [
464,
144
],
"parameters": {
"options": {},
"respondWith": "json",
"responseBody": "={\n \"success\": true,\n \"message\": \"Payment recorded successfully\",\n \"invoice_number\": \"{{ $json.invoice_number }}\",\n \"amount_paid\": {{ $json.payment_amount }},\n \"status\": \"{{ $json.payment_status }}\"\n}"
},
"typeVersion": 1.1
},
{
"id": "5554a9a8-1fc3-4743-9f98-896ae8a2b146",
"name": "发送付款确认",
"type": "n8n-nodes-base.emailSend",
"position": [
480,
576
],
"webhookId": "11ecce72-7466-43e6-8c05-d5f181c5ced7",
"parameters": {
"options": {},
"subject": "=Payment Confirmation - Invoice {{ $json.invoice_number }}",
"toEmail": "abc@gmail.com",
"fromEmail": "xyz@gmail.com"
},
"credentials": {
"smtp": {
"id": "G1kyF8cSWTZ4vouN",
"name": "SMTP -test"
}
},
"typeVersion": 2.1
},
{
"id": "8a45b060-fd84-4e2f-a880-5bb2db6e5cb4",
"name": "生成邮件",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"notes": "Use AI to generate personalized email",
"position": [
1200,
-80
],
"parameters": {
"model": "=gpt-4o-mini",
"options": {
"maxTokens": 500,
"temperature": 0.7
}
},
"credentials": {
"openAiApi": {
"id": "CDQ16eImh6D4tY15",
"name": "OpenAi account 2 - test"
}
},
"notesInFlow": true,
"typeVersion": 1
},
{
"id": "51c1516e-e53b-4435-ab0f-a8c147b3478a",
"name": "用于生成邮件内容的 AI 代理",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
1120,
-304
],
"parameters": {
"options": {}
},
"typeVersion": 2.2
},
{
"id": "278e2272-baa8-4c0e-81db-836db7204219",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-32,
-416
],
"parameters": {
"width": 192,
"height": 288,
"content": "每天早上自动启动工作流。"
},
"typeVersion": 1
},
{
"id": "77598975-6120-472e-b9a1-d1b23c64f651",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
640,
-416
],
"parameters": {
"width": 192,
"height": 288,
"content": "决定何时以及如何发送提醒。"
},
"typeVersion": 1
},
{
"id": "98bbe714-19b0-4be2-8610-95074be891e8",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
416,
-416
],
"parameters": {
"width": 192,
"height": 288,
"content": "仅保留逾期发票。"
},
"typeVersion": 1
},
{
"id": "d4b28ef6-da2a-4d6a-8486-5cb60c272115",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
192,
-416
],
"parameters": {
"width": 192,
"height": 288,
"content": "从数据库获取未付发票。"
},
"typeVersion": 1
},
{
"id": "7789557b-f95a-4336-ae2a-2247b215cc6e",
"name": "便签说明4",
"type": "n8n-nodes-base.stickyNote",
"position": [
864,
-416
],
"parameters": {
"width": 192,
"height": 288,
"content": "为每个客户创建个性化的 AI 提示。"
},
"typeVersion": 1
},
{
"id": "9e5d7552-ab77-48bd-9f64-78a82f9676b1",
"name": "便签说明5",
"type": "n8n-nodes-base.stickyNote",
"position": [
2096,
-416
],
"parameters": {
"width": 192,
"height": 288,
"content": "记录提醒活动以供审计。"
},
"typeVersion": 1
},
{
"id": "63b897b8-e59e-42c4-9d3f-194c52c850e6",
"name": "便签 6",
"type": "n8n-nodes-base.stickyNote",
"position": [
1872,
-416
],
"parameters": {
"width": 192,
"height": 288,
"content": "在数据库中将提醒标记为已发送。"
},
"typeVersion": 1
},
{
"id": "9ea47eb5-9b59-47df-873f-1f1060ae9bf5",
"name": "便签 7",
"type": "n8n-nodes-base.stickyNote",
"position": [
1648,
-416
],
"parameters": {
"width": 192,
"height": 288,
"content": "通过 Gmail 或 SMTP 发送邮件。"
},
"typeVersion": 1
},
{
"id": "9e881563-1895-40a0-8b1b-9f8fe886e284",
"name": "## 为什么选择 4o 模型？👆",
"type": "n8n-nodes-base.stickyNote",
"position": [
1424,
-416
],
"parameters": {
"width": 192,
"height": 288,
"content": "将 AI 文本转换为专业的 HTML 邮件。"
},
"typeVersion": 1
},
{
"id": "1b036318-bfc1-4bef-bde8-06c3523c5ccf",
"name": "便签 9",
"type": "n8n-nodes-base.stickyNote",
"position": [
1104,
-416
],
"parameters": {
"width": 272,
"height": 288,
"content": "使用 AI 起草提醒邮件。"
},
"typeVersion": 1
},
{
"id": "b570ef63-5ee6-4605-b461-429f1d817b8b",
"name": "便签10",
"type": "n8n-nodes-base.stickyNote",
"position": [
2544,
-416
],
"parameters": {
"width": 192,
"height": 288,
"content": "准备已发送提醒的报告。"
},
"typeVersion": 1
},
{
"id": "10b172aa-f4bb-4ccc-a102-2593e0d78ff8",
"name": "便签11",
"type": "n8n-nodes-base.stickyNote",
"position": [
2768,
-416
],
"parameters": {
"width": 192,
"height": 288,
"content": "将摘要通过邮件发送给财务团队。"
},
"typeVersion": 1
},
{
"id": "a0c95551-0747-4c97-9cf7-d61ff9c12fd8",
"name": "便签12",
"type": "n8n-nodes-base.stickyNote",
"position": [
2320,
-416
],
"parameters": {
"width": 192,
"height": 288,
"content": "存储原始工作流数据以供审查。"
},
"typeVersion": 1
},
{
"id": "4e422ead-f833-4de8-8f86-3b78116b2eab",
"name": "便签13",
"type": "n8n-nodes-base.stickyNote",
"position": [
432,
0
],
"parameters": {
"width": 192,
"height": 288,
"content": "通过 AI 生成感谢信息。"
},
"typeVersion": 1
},
{
"id": "0816a7b8-03bd-4416-aa58-a30f1e3af0f5",
"name": "便签 14",
"type": "n8n-nodes-base.stickyNote",
"position": [
-96,
240
],
"parameters": {
"width": 192,
"height": 288,
"content": "捕获付款通知。"
},
"typeVersion": 1
},
{
"id": "0f6e79b9-107d-4ddb-bbaa-421a07d47078",
"name": "便签 15",
"type": "n8n-nodes-base.stickyNote",
"position": [
160,
240
],
"parameters": {
"width": 192,
"height": 288,
"content": "将发票更新为\"已付款\"。"
},
"typeVersion": 1
},
{
"id": "ce1221dd-7976-47d1-9cc9-81389efc72fe",
"name": "便签16",
"type": "n8n-nodes-base.stickyNote",
"position": [
448,
416
],
"parameters": {
"width": 192,
"height": 288,
"content": "向客户发送付款收据。"
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "cb6d5397-a382-40d3-92c0-69022ceec1a5",
"connections": {
"Format Email": {
"main": [
[
{
"node": "Send Email Reminder",
"type": "main",
"index": 0
}
]
]
},
"Generate Email": {
"ai_languageModel": [
[
{
"node": "AI Agent For Generate Email Content",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Prepare AI Prompt": {
"main": [
[
{
"node": "AI Agent For Generate Email Content",
"type": "main",
"index": 0
}
]
]
},
"Create Activity Log": {
"main": [
[
{
"node": "Save to Activity Log",
"type": "main",
"index": 0
}
]
]
},
"Send Email Reminder": {
"main": [
[
{
"node": "Update Reminder Status",
"type": "main",
"index": 0
}
]
]
},
"Save to Activity Log": {
"main": [
[
{
"node": "Generate Daily Summary",
"type": "main",
"index": 0
}
]
]
},
"Schedule Daily Check": {
"main": [
[
{
"node": "Fetch Pending Invoices",
"type": "main",
"index": 0
}
]
]
},
"Update Payment Status": {
"main": [
[
{
"node": "Webhook Response",
"type": "main",
"index": 0
},
{
"node": "Send Payment Confirmation",
"type": "main",
"index": 0
}
]
]
},
"Fetch Pending Invoices": {
"main": [
[
{
"node": "Filter Overdue Invoices",
"type": "main",
"index": 0
}
]
]
},
"Generate Daily Summary": {
"main": [
[
{
"node": "Send Summary to Finance Team",
"type": "main",
"index": 0
}
]
]
},
"Update Reminder Status": {
"main": [
[
{
"node": "Create Activity Log",
"type": "main",
"index": 0
}
]
]
},
"Filter Overdue Invoices": {
"main": [
[
{
"node": "Calculate Reminder Logic",
"type": "main",
"index": 0
}
]
]
},
"Calculate Reminder Logic": {
"main": [
[
{
"node": "Prepare AI Prompt",
"type": "main",
"index": 0
}
]
]
},
"Webhook: Payment Received": {
"main": [
[
{
"node": "Update Payment Status",
"type": "main",
"index": 0
}
]
]
},
"AI Agent For Generate Email Content": {
"main": [
[
{
"node": "Format Email",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 发票处理, 多模态 AI
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
智能活动跟进与社交助手
使用 GPT-4、LinkedIn 和 HubSpot 多渠道触达实现活动跟进自动化
Code
Filter
Hubspot
+8
25 节点Oneclick AI Squad
客户培育
AI症状检查与医生推荐
使用Ollama AI和WhatsApp的医疗症状分析与医生推荐
If
Code
Webhook
+6
15 节点Oneclick AI Squad
客服机器人
使用 OpenAI、LangChain 和 API 集成的工作流自动化初学者指南
使用 OpenAI、LangChain 和 API 集成的工作流自动化初学者指南
If
Set
Code
+13
33 节点Meelioo
内容创作
AI驱动的活动后报告和摘要生成器
使用GPT-4生成活动后报告，支持邮件发送和数据库存储
Code
Webhook
Postgres
+6
13 节点Oneclick AI Squad
文档提取
房地产工作流
AI房产匹配和自动日历调度的房地产聊天机器人
If
Set
Code
+12
33 节点Genzi
客户培育
WhatsApp上的AI电影推荐器
WhatsApp上的AI电影推荐器
If
Set
Code
+5
20 节点Oneclick AI Squad
客服机器人
工作流信息
难度等级
高级
节点数量35
分类2
节点类型11
作者
Oneclick AI Squad
@oneclick-aiThe AI Squad Initiative is a pioneering effort to build, automate and scale AI-powered workflows using n8n.io. Our mission is to help individuals and businesses integrate AI agents seamlessly into their daily operations from automating tasks and enhancing productivity to creating innovative, intelligent solutions. We design modular, reusable AI workflow templates that empower creators, developers and teams to supercharge their automation with minimal effort and maximum impact.
外部链接
在 n8n.io 查看 →
分享此工作流