台湾银行信用卡还款提醒与追踪
高级
这是一个Finance领域的自动化工作流，包含 39 个节点。主要使用 Set, Webhook, GmailTrigger, GoogleSheets, ManualTrigger 等节点。 台湾银行信用卡还款提醒与追踪系统
前置要求
- •HTTP Webhook 端点（n8n 会自动生成）
- •Google 账号和 Gmail API 凭证
- •Google Sheets API 凭证
分类
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "rgucabdLVKaezGa6",
"meta": {
"instanceId": "fddb3e91967f1012c95dd02bf5ad21f279fc44715f47a7a96a33433621caa253"
},
"tags": [
{
"id": "IifyzA4m8rqIfnph",
"name": "public_template",
"createdAt": "2025-02-08T07:12:26.837Z",
"updatedAt": "2025-02-08T07:12:26.837Z"
}
],
"nodes": [
{
"id": "682ace62-1acf-4327-b24e-5d40382ad750",
"name": "点击\"测试工作流\"时",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-980,
380
],
"parameters": {},
"typeVersion": 1
},
{
"id": "6c3b6c00-a0ac-474f-92a1-fcdea66516d7",
"name": "Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
880,
280
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "4b0ea74d-db59-4363-81b3-78eef942c841",
"name": "Webhook",
"type": "n8n-nodes-base.webhook",
"position": [
-200,
1280
],
"webhookId": "3516a92a-a24a-42eb-be10-121b8c797846",
"parameters": {},
"typeVersion": 2
},
{
"id": "64259065-086a-4e5c-8936-193f36c4b71e",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-280,
-320
],
"parameters": {},
"typeVersion": 1
},
{
"id": "aaeb32a5-5850-4f44-9869-fa0ed9233683",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-280,
1180
],
"parameters": {},
"typeVersion": 1
},
{
"id": "8df56f9c-d621-440a-b4b5-413f5dd800af",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-700,
-200
],
"parameters": {},
"typeVersion": 1
},
{
"id": "50ddb4a9-e905-4c54-88a3-1080f4003aed",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-680,
280
],
"parameters": {},
"typeVersion": 1
},
{
"id": "9ec5ba91-6745-4a4e-8607-4987fd2cc50b",
"name": "便利贴5",
"type": "n8n-nodes-base.stickyNote",
"position": [
-680,
440
],
"parameters": {},
"typeVersion": 1
},
{
"id": "e0a8ca70-1fee-4401-b03a-edd599de2fe9",
"name": "便签 6",
"type": "n8n-nodes-base.stickyNote",
"position": [
-680,
600
],
"parameters": {},
"typeVersion": 1
},
{
"id": "b96c9572-3770-437b-9241-85adadc25f64",
"name": "便签 7",
"type": "n8n-nodes-base.stickyNote",
"position": [
-680,
780
],
"parameters": {},
"typeVersion": 1
},
{
"id": "29caac66-9c6e-4ff6-80f4-3c28b841d66e",
"name": "便签8",
"type": "n8n-nodes-base.stickyNote",
"position": [
-680,
940
],
"parameters": {},
"typeVersion": 1
},
{
"id": "05026ee8-7b99-4ffd-9fda-cfa87b729633",
"name": "Gmail-永丰银行",
"type": "n8n-nodes-base.gmailTrigger",
"notes": "Email coming from sinopac creditcard email",
"position": [
-180,
-220
],
"parameters": {},
"notesInFlow": true,
"typeVersion": 1.2
},
{
"id": "bf9c1bee-d8f0-4e9c-b13f-e2b3c7fbe32e",
"name": "永丰银行_PDF",
"type": "n8n-nodes-base.extractFromFile",
"position": [
40,
-220
],
"parameters": {},
"typeVersion": 1
},
{
"id": "6171ac4c-0172-4081-b3c4-b71d54cdd728",
"name": "永丰银行_设置字段",
"type": "n8n-nodes-base.set",
"position": [
240,
-220
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "4122913f-4fff-4401-b52d-3e5fef868baa",
"name": "整理数据",
"type": "n8n-nodes-base.set",
"position": [
480,
280
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "26b44b81-539d-412b-8db5-009a62778fbe",
"name": "创建 Google Calendar 事件",
"type": "n8n-nodes-base.googleCalendar",
"position": [
680,
280
],
"parameters": {},
"typeVersion": 1.3
},
{
"id": "7f0b3a85-ff72-413f-a0f2-43ed65d23d6c",
"name": "更新Google Calendar - 更改状态",
"type": "n8n-nodes-base.googleCalendar",
"position": [
1100,
280
],
"parameters": {},
"typeVersion": 1.3
},
{
"id": "b387f226-878b-47fe-8d0d-8be96073f1bc",
"name": "国泰世华_设置字段",
"type": "n8n-nodes-base.set",
"position": [
240,
-60
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "1b737a0a-476a-4135-b92e-1062133849df",
"name": "Gmail-中国信托",
"type": "n8n-nodes-base.gmailTrigger",
"position": [
-180,
120
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "33558faf-b386-4853-8482-e1f3a62eeddb",
"name": "中国信托_设置字段",
"type": "n8n-nodes-base.set",
"position": [
240,
120
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "2dc09bdc-1736-4209-adfb-2bcb384a3f0b",
"name": "Gmail-国泰世华",
"type": "n8n-nodes-base.gmailTrigger",
"position": [
-180,
-60
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "86e8f0de-a82a-4dd7-964d-5e6ebc8b98bb",
"name": "Gmail-富邦银行",
"type": "n8n-nodes-base.gmailTrigger",
"position": [
-180,
280
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "e0c37b7e-3124-45c5-9eba-ea3cea3fde00",
"name": "富邦银行_PDF",
"type": "n8n-nodes-base.extractFromFile",
"position": [
40,
280
],
"parameters": {},
"typeVersion": 1
},
{
"id": "9987b2e7-22a5-4d64-8732-287a50db7c94",
"name": "富邦银行_设置字段",
"type": "n8n-nodes-base.set",
"position": [
240,
280
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "541bb50b-5d1d-4b05-b15a-3d023494af5c",
"name": "Gmail-玉山银行",
"type": "n8n-nodes-base.gmailTrigger",
"position": [
-180,
440
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "edeca715-2478-4501-9950-2954d59dce8e",
"name": "玉山银行_PDF",
"type": "n8n-nodes-base.extractFromFile",
"position": [
40,
440
],
"parameters": {},
"typeVersion": 1
},
{
"id": "fcd79f66-68d8-4653-92f2-a2e88e4ce93b",
"name": "玉山银行_设置字段",
"type": "n8n-nodes-base.set",
"position": [
240,
440
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "e1f97003-9422-4ce3-a43c-4263c052ba19",
"name": "Gmail-星展银行",
"type": "n8n-nodes-base.gmailTrigger",
"position": [
-180,
600
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "5414313b-d946-4c29-ba37-c2e638eccdf4",
"name": "星展银行_PDF",
"type": "n8n-nodes-base.extractFromFile",
"position": [
40,
600
],
"parameters": {},
"typeVersion": 1
},
{
"id": "92035b9d-165e-4683-85f1-032f3fb6e024",
"name": "星展银行_设置字段",
"type": "n8n-nodes-base.set",
"position": [
240,
600
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "25167f22-cfee-466e-af99-9598e98dd538",
"name": "Gmail-联邦银行",
"type": "n8n-nodes-base.gmailTrigger",
"position": [
-180,
780
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "c793972f-6b17-4de7-99eb-d17f3e9b83c9",
"name": "联邦银行_PDF",
"type": "n8n-nodes-base.extractFromFile",
"position": [
40,
780
],
"parameters": {},
"typeVersion": 1
},
{
"id": "9a121b73-61fb-47d6-8164-9c8b4f85ddc9",
"name": "联邦银行_设置字段",
"type": "n8n-nodes-base.set",
"position": [
240,
780
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "355b16e1-e9bf-42ab-b288-44b3fe50efb8",
"name": "Gmail-台新银行",
"type": "n8n-nodes-base.gmailTrigger",
"position": [
-180,
940
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "39b9103b-36a2-404c-818d-46a5b9fae9eb",
"name": "台新银行_PDF",
"type": "n8n-nodes-base.extractFromFile",
"position": [
40,
940
],
"parameters": {},
"typeVersion": 1
},
{
"id": "d64e3188-d6ab-45b0-9f9d-e9c2d999708f",
"name": "台新银行_设置字段",
"type": "n8n-nodes-base.set",
"position": [
240,
940
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "d0f4865c-07d9-4291-9b16-c359d9593ec0",
"name": "通过ID获取Google Calendar事件",
"type": "n8n-nodes-base.googleCalendar",
"position": [
60,
1280
],
"parameters": {},
"typeVersion": 1.3
},
{
"id": "567a8341-4098-43d0-a109-ae4d2c5c6dfb",
"name": "更新Google Calendar事件状态",
"type": "n8n-nodes-base.googleCalendar",
"position": [
260,
1280
],
"parameters": {},
"typeVersion": 1.3
},
{
"id": "99e6733b-d441-472f-80d3-034c3d658ea5",
"name": "更新Google Sheets付款状态",
"type": "n8n-nodes-base.googleSheets",
"position": [
480,
1280
],
"parameters": {},
"typeVersion": 4.5
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "6c41c292-31dd-41cf-8ca6-9d6ceeb16b5a",
"connections": {
"DBS_PDF": {
"main": [
[
{
"node": "DBS_set field",
"type": "main",
"index": 0
}
]
]
},
"Webhook": {
"main": [
[
{
"node": "Get Google Calendar Event by id",
"type": "main",
"index": 0
}
]
]
},
"E.SUN_PDF": {
"main": [
[
{
"node": "E.SUN_set field",
"type": "main",
"index": 0
}
]
]
},
"Fubon_PDF": {
"main": [
[
{
"node": "Fubon_set field",
"type": "main",
"index": 0
}
]
]
},
"Gmail-DBS": {
"main": [
[
{
"node": "DBS_PDF",
"type": "main",
"index": 0
}
]
]
},
"Union_PDF": {
"main": [
[
{
"node": "Union_set fields",
"type": "main",
"index": 0
}
]
]
},
"Gmail-CTBC": {
"main": [
[
{
"node": "CTBC _set field",
"type": "main",
"index": 0
}
]
]
},
"Gmail-E.SUN": {
"main": [
[
{
"node": "E.SUN_PDF",
"type": "main",
"index": 0
}
]
]
},
"Gmail-Fubon": {
"main": [
[
{
"node": "Fubon_PDF",
"type": "main",
"index": 0
}
]
]
},
"Gmail-Union": {
"main": [
[
{
"node": "Union_PDF",
"type": "main",
"index": 0
}
]
]
},
"SINOPAC_PDF": {
"main": [
[
{
"node": "SINOPAC_set field",
"type": "main",
"index": 0
}
]
]
},
"Taishin_PDF": {
"main": [
[
{
"node": "Taishin_set fields",
"type": "main",
"index": 0
}
]
]
},
"Gmail-Cathay": {
"main": [
[
{
"node": "Cathay_set field",
"type": "main",
"index": 0
}
]
]
},
"DBS_set field": {
"main": [
[
{
"node": "Organize Data",
"type": "main",
"index": 0
}
]
]
},
"Gmail-SINOPAC": {
"main": [
[
{
"node": "SINOPAC_PDF",
"type": "main",
"index": 0
}
]
]
},
"Gmail-Taishin": {
"main": [
[
{
"node": "Taishin_PDF",
"type": "main",
"index": 0
}
]
]
},
"Google Sheets": {
"main": [
[
{
"node": "Update Google Calendar - change status",
"type": "main",
"index": 0
}
]
]
},
"Organize Data": {
"main": [
[
{
"node": "Create Google Calendar Event",
"type": "main",
"index": 0
}
]
]
},
"CTBC _set field": {
"main": [
[
{
"node": "Organize Data",
"type": "main",
"index": 0
}
]
]
},
"E.SUN_set field": {
"main": [
[
{
"node": "Organize Data",
"type": "main",
"index": 0
}
]
]
},
"Fubon_set field": {
"main": [
[
{
"node": "Organize Data",
"type": "main",
"index": 0
}
]
]
},
"Cathay_set field": {
"main": [
[
{
"node": "Organize Data",
"type": "main",
"index": 0
}
]
]
},
"Union_set fields": {
"main": [
[
{
"node": "Organize Data",
"type": "main",
"index": 0
}
]
]
},
"SINOPAC_set field": {
"main": [
[
{
"node": "Organize Data",
"type": "main",
"index": 0
}
]
]
},
"Taishin_set fields": {
"main": [
[
{
"node": "Organize Data",
"type": "main",
"index": 0
}
]
]
},
"Create Google Calendar Event": {
"main": [
[
{
"node": "Google Sheets",
"type": "main",
"index": 0
}
]
]
},
"Get Google Calendar Event by id": {
"main": [
[
{
"node": "Update Google Calendar event staus",
"type": "main",
"index": 0
}
]
]
},
"Update Google Calendar event staus": {
"main": [
[
{
"node": "Update Google Sheets pay status",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 财务
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
在可视化参考库中探索n8n节点
在可视化参考库中探索n8n节点
If
Ftp
Set
+93
113 节点I versus AI
其他
(Tung) OCR发票提取到电子表格副本
自动发票和收据OCR到Google表格 - 支持云端硬盘、Gmail和Telegram触发
If
Set
Code
+10
25 节点Daniel Ng
财务
饮水量自动追踪器
自动追踪饮水量 - 存储在表格中并在Slack通知
If
Set
Wait
+9
21 节点darrell_tw
其他
n8napi-检查使用哪个模型的工作流
检查工作流中使用的AI模型
N8n
Set
Filter
+5
12 节点darrell_tw
人工智能
模板演示-chatgpt-图片-1-带-drive-和-sheet副本
使用GPT-image-1生成图像并存储到Google Drive，包含成本跟踪
Set
Split Out
Aggregate
+8
16 节点darrell_tw
设计
基于OCR、AI和Google表格的发票处理与验证器
基于OCR、AI和Google表格的发票处理与验证器
If
Set
Code
+8
22 节点Dhrumil Patel
财务
工作流信息
难度等级
高级
节点数量39
分类1
节点类型8
作者
darrell_tw
@darrelltwMartech Engineer with automation. here is my website: https://www.darrelltw.com/
外部链接
在 n8n.io 查看 →
分享此工作流