Gmail与QuickBooks Online工作流
中级
这是一个Invoice Processing, Multimodal AI领域的自动化工作流，包含 11 个节点。主要使用 Gmail, GmailTrigger, ScheduleTrigger 等节点。 Gmail与QuickBooks Online工作流
前置要求
- •Google 账号和 Gmail API 凭证
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"meta": {
"instanceId": "d6e2f2f655b1125bbcac14a4cac6d2e46c7a150e927f85fc96fdca1a6dc39e0e",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "030584dd-ad50-49e3-a12e-49ccd867ae8c",
"name": "每天上午8点",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-80,
0
],
"parameters": {
"rule": {
"interval": [
{
"triggerAtHour": 8
}
]
}
},
"typeVersion": 1.2
},
{
"id": "6b5f5472-b602-4775-b010-5b5a0fe77be5",
"name": "收到新邮件收据",
"type": "n8n-nodes-base.gmailTrigger",
"position": [
-80,
-192
],
"parameters": {
"filters": {
"labelIds": [
"Label_1709246557347095595"
]
},
"pollTimes": {
"item": [
{
"mode": "everyMinute"
}
]
}
},
"credentials": {
"gmailOAuth2": {
"id": "YVZiLPppXZw84rIU",
"name": "BTMobileGTA Gmail"
}
},
"typeVersion": 1.3
},
{
"id": "bbd5cdaf-905a-4f5d-abb8-ff736e4b5aa9",
"name": "从邮件获取新收据",
"type": "n8n-nodes-base.gmail",
"position": [
176,
-96
],
"webhookId": "449f7eea-0be5-4d86-a254-ef047b9f8d67",
"parameters": {
"simple": false,
"filters": {
"labelIds": [
"Label_1709246557347095595"
]
},
"options": {},
"operation": "getAll",
"returnAll": true
},
"credentials": {
"gmailOAuth2": {
"id": "YVZiLPppXZw84rIU",
"name": "BTMobileGTA Gmail"
}
},
"typeVersion": 2.1
},
{
"id": "6f5e3ebf-fef1-4508-be4e-0e7d9f106c01",
"name": "将收据转发至QBO",
"type": "n8n-nodes-base.gmail",
"position": [
416,
-96
],
"webhookId": "0a979bd8-edd5-468e-8eab-4a914e2f80c3",
"parameters": {
"sendTo": "user@qbodocs.com",
"message": "={{ $json.html }}",
"options": {
"appendAttribution": false
},
"subject": "Email Receipt"
},
"credentials": {
"gmailOAuth2": {
"id": "YVZiLPppXZw84rIU",
"name": "BTMobileGTA Gmail"
}
},
"typeVersion": 2.1
},
{
"id": "2c05914d-8b61-4449-b55f-fe280939446c",
"name": "移除旧标签",
"type": "n8n-nodes-base.gmail",
"position": [
656,
-96
],
"webhookId": "722818d7-391e-428b-b173-fe5bb744f54c",
"parameters": {
"labelIds": [
"Label_1709246557347095595"
],
"messageId": "={{ $('Get New Receipt from Email').item.json.id }}",
"operation": "removeLabels"
},
"credentials": {
"gmailOAuth2": {
"id": "YVZiLPppXZw84rIU",
"name": "BTMobileGTA Gmail"
}
},
"typeVersion": 2.1
},
{
"id": "1cab2ebf-4f27-401c-a65e-d98486d367e7",
"name": "添加\"已处理\"标签",
"type": "n8n-nodes-base.gmail",
"position": [
864,
-96
],
"webhookId": "0bf6f5ce-90be-4789-9e1f-415988c600c3",
"parameters": {
"labelIds": [
"Label_3375203355533515697"
],
"messageId": "={{ $('Get New Receipt from Email').item.json.id }}",
"operation": "addLabels"
},
"credentials": {
"gmailOAuth2": {
"id": "YVZiLPppXZw84rIU",
"name": "BTMobileGTA Gmail"
}
},
"typeVersion": 2.1
},
{
"id": "5645be8e-7cfc-47be-b492-9901877fb0d5",
"name": "便签7",
"type": "n8n-nodes-base.stickyNote",
"position": [
-928,
-752
],
"parameters": {
"width": 736,
"height": 1328,
"content": "## 自动将邮件收据转发至QuickBooks Online"
},
"typeVersion": 1
},
{
"id": "214f3e76-bad5-485e-a093-e302642c7adf",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
112,
-192
],
"parameters": {
"color": 7,
"width": 224,
"height": 288,
"content": "此节点将查找带有您所选标签的邮件"
},
"typeVersion": 1
},
{
"id": "813e7187-18e0-4d52-b39c-142de6041603",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
352,
-192
],
"parameters": {
"color": 7,
"width": 224,
"height": 288,
"content": "请在此处设置您的QBO转发地址"
},
"typeVersion": 1
},
{
"id": "a50aac4a-8fb7-457b-a3dc-55879f50c547",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
592,
-192
],
"parameters": {
"color": 7,
"width": 448,
"height": 288,
"content": "此流程可防止重复邮件发送至QBO"
},
"typeVersion": 1
},
{
"id": "3d24c1e3-e40d-4f05-baff-7b5e34bec23b",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-160,
-352
],
"parameters": {
"color": 7,
"width": 256,
"height": 512,
"content": "当收到带有匹配标签的新邮件时，工作流开始执行。"
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"Every Day at 8 AM": {
"main": [
[
{
"node": "Get New Receipt from Email",
"type": "main",
"index": 0
}
]
]
},
"Remove the Old Label": {
"main": [
[
{
"node": "Add the \"Processed\" Label",
"type": "main",
"index": 0
}
]
]
},
"Forward the Receipt to QBO": {
"main": [
[
{
"node": "Remove the Old Label",
"type": "main",
"index": 0
}
]
]
},
"Get New Receipt from Email": {
"main": [
[
{
"node": "Forward the Receipt to QBO",
"type": "main",
"index": 0
}
]
]
},
"New Email Receipt Received": {
"main": [
[
{
"node": "Get New Receipt from Email",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
中级 - 发票处理, 多模态 AI
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
从Gmail标签使用GPT-4O + QuickBooks自动创建发票
从Gmail标签使用GPT-4O + QuickBooks自动创建发票
Code
Gmail
Quickbooks
+5
23 节点Rosh Ragel
发票处理
自动通过 Gmail 发送 Square 月度销售报告
自动通过 Gmail 发送 Square 月度销售报告
If
Code
Gmail
+5
16 节点Rosh Ragel
内容创作
使用Outlook和QuickBooks自动化客户账单详情收集与开票
使用Outlook和QuickBooks自动化客户账单详情收集与开票
Quickbooks
Form Trigger
Microsoft Outlook
+1
15 节点Rosh Ragel
发票处理
Google Sheets和QuickBooks费用自动化模板
Google Sheets和QuickBooks费用自动化模板
If
Set
Split Out
+6
16 节点Rosh Ragel
发票处理
自动通过 Outlook 发送 Square 月度销售报告
自动通过 Outlook 发送 Square 月度销售报告
If
Code
Split Out
+5
16 节点Rosh Ragel
文档提取
客户账单详情收集与发票生成（Gmail 和 QuickBooks）
使用 Gmail 和 QuickBooks 收集客户账单详情并生成发票
Gmail
Quickbooks
Form Trigger
+1
15 节点Rosh Ragel
发票处理
