[AI 自動化] 用 n8n 做刷卡消費記錄（富邦、國泰、匯豐）

{from:(noreply@uber.com) AND {subject:(透過 Uber Eats 系統送出的訂單) OR subject:(在 Uber 平台上搭乘的行程)}} OR {from:(no_reply@email.apple.com) AND subject:(Your invoice)} OR {{from:(invoice+statements) OR from:(@stripe.com)} AND subject:(receipt)} OR {from:(bot@heroku.com) AND subject:([billing] Heroku Invoice)} OR {from:(noreply@messaging.hsbc.com.tw) AND subject:(匯豐(台灣) "刷卡消費通知”)} OR {from:(hello@crypto.com) AND subject:(purchase complete)} OR {from:(@taipeifubon.com.tw) AND subject:(富邦 即時消費通知)} OR {from:(service@pxbillrc01.cathaybk.com.tw) AND subject:(國泰世華銀行消費彙整通知)}

{
"meta": {
"instanceId": "3986dc65ca3ddc4ee46e71fc194b0a9d4ef46d960a5e71624f9f7eaa198213cb"
},
"nodes": [
{
"parameters": {
"pollTimes": {
"item": [
{
"mode": "everyHour"
}
]
},
"simple": false,
"filters": {
"q": "{from:(service@pxbillrc01.cathaybk.com.tw) AND subject:(國泰世華銀行消費彙整通知)} Google CLOUD XRGQKv"
},
"options": {}
},
"id": "c29453ec-9666-4c22-8dbf-72e7c3181269",
"name": "Gmail Trigger",
"type": "n8n-nodes-base.gmailTrigger",
"typeVersion": 1.1,
"position": [
720,
380
],
"credentials": {
"gmailOAuth2": {
"id": "fegneFqi8XJX3NJH",
"name": "Gmail account (hana@hanamizuki.tw)"
}
}
},
{
"parameters": {
"operation": "extractHtmlContent",
"dataPropertyName": "=html",
"extractionValues": {
"values": [
{
"key": "spend",
"cssSelector": ".spend-table",
"returnArray": true
}
]
},
"options": {}
},
"id": "20101b69-469f-41f4-83b9-f5bc4ea7045f",
"name": "HTML",
"type": "n8n-nodes-base.html",
"typeVersion": 1.2,
"position": [
1120,
160
]
},
{
"parameters": {
"fieldToSplitOut": "spend",
"options": {}
},
"id": "cc0e4fc9-35d5-4a45-8421-06b3ed1f9837",
"name": "Split Out",
"type": "n8n-nodes-base.splitOut",
"typeVersion": 1,
"position": [
1260,
160
]
},
{
"parameters": {
"schemaType": "manual",
"inputSchema": "{\n "title": "消費記錄 Schema",\n "description": "用於解析消費記錄信件的 Schema，包括日期、服務名稱、交易詳情、金額、類別、貨幣和卡片。",\n "type": "object",\n "properties": {\n "date": {\n "type": "string",\n "description": "交易日期，可參考信件日期或內容內的消費日期。若有多個日期，以最早的日期為主。格式為 'YYYY-MM-DD'，例如 '2024-09-02'。",\n "pattern": "^\\d{4}-\\d{2}-\\d{2}$",\n "examples": ["2024-09-02"]\n },\n "service": {\n "type": ["string", "null"],\n "description": "服務或商店的名稱，例如 'GOOGLE'、'Uber' 等。",\n "examples": ["GOOGLE", "Uber Eats", "Uber", "CLAUDE.AI"]\n },\n "details": {\n "type": ["string", "null"],\n "description": "交易的詳細訊息，如海外刷卡、網路刷卡、餐廳名稱或消費細節。若無可留空或為 null。",\n "examples": ["Uber:從復興北路到民權東路", "餐廳名稱", null]\n },\n "amount": {\n "type": "number",\n "description": "交易金額。若為美元，保留小數點後兩位（如 50.12）；若為台幣則使用整數（如 550）。",\n "examples": [50.12, 550]\n },\n "category": {\n "type": "string",\n "description": "交易類別",\n "examples": ["交通", "餐飲", "雲端服務", "美妝", "日用品"]\n },\n "currency": {\n "type": "string",\n "description": "交易使用的貨幣代碼，如果金額是 NT$ 開頭，curreny 就是 TWD。",\n "enum": ["TWD", "USD", "JPY", "EUR", "SGD"],\n "examples": ["USD", "TWD"]\n },\n "card": {\n "type": ["string", "null"],\n "description": "交易使用的信用卡。",\n "enum": ["匯豐 3088", "匯豐 3854", "富邦卡", "Crypto.com Card", "國泰卡", null],\n "examples": ["匯豐 3088", "匯豐 3854"]\n }\n },\n "required": ["date", "amount", "category", "currency"]\n}"
},
"id": "a896950c-f612-42d5-b1e5-6624e8164523",
"name": "Structured Output Parser1",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"typeVersion": 1.2,
"position": [
1760,
540
]
},
{
"parameters": {
"modelName": "models/gemini-1.5-flash",
"options": {}
},
"id": "59e4aeb9-4c37-4c60-abe3-44654dc020e2",
"name": "Google Gemini Chat Model1",
"type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
"typeVersion": 1,
"position": [
1580,
540
],
"credentials": {
"googlePalmApi": {
"id": "QR3KfTwhKpbgAGWU",
"name": "Google Gemini(PaLM) Api account"
}
}
},
{
"parameters": {
"assignments": {
"assignments": [
{
"id": "75b16672-71cf-4157-bcb6-683099ff1620",
"name": "email_date",
"value": "={{ $('Gmail Trigger').item.json.date }}",
"type": "string"
},
{
"id": "3298f680-5d17-42fd-8b41-a6ca621af37d",
"name": "email_subject",
"value": "={{ $('Gmail Trigger').item.json.subject }}",
"type": "string"
},
{
"id": "cf7181b7-fef9-437a-8bbe-cd4a4eda85b8",
"name": "email_content",
"value": "={{ $ifEmpty($json.spend, $ifEmpty( $('Gmail Trigger').item.json.text, $json.html)) }}",
"type": "string"
},
{
"id": "1a524cb4-6975-4d45-ac0e-f1ac1f9b0417",
"name": "email_type",
"value": "={{ $prevNode.outputIndex }}",
"type": "number"
}
]
},
"options": {}
},
"id": "da440b99-e257-46e9-a353-aee363669053",
"name": "Set data",
"type": "n8n-nodes-base.set",
"typeVersion": 3.4,
"position": [
1400,
380
]
},
{
"parameters": {
"operation": "append",
"documentId": {
"__rl": true,
"value": "https://docs.google.com/spreadsheets/d/1ccwhQeUSUkINccAucC6_clRyNF5Mw4IjIxAtcH4ftIs/edit?gid=370005862#gid=370005862",
"mode": "url"
},
"sheetName": {
"__rl": true,
"value": 868414094,
"mode": "list",
"cachedResultName": "raw data",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1ccwhQeUSUkINccAucC6_clRyNF5Mw4IjIxAtcH4ftIs/edit#gid=868414094"
},
"columns": {
"mappingMode": "defineBelow",
"value": {
"date": "={{ $json.output.date }}",
"service": "={{ $json.output.service }}",
"details": "={{ $json.output.details }}",
"amount": "={{ $json.output.amount }}",
"category": "={{ $json.output.category }}",
"currency": "={{ $json.output.currency }}",
"card": "={{ $json.output.card }}"
},
"matchingColumns": [],
"schema": [
{
"id": "date",
"displayName": "date",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "service",
"displayName": "service",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "details",
"displayName": "details",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "amount",
"displayName": "amount",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "category",
"displayName": "category",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "currency",
"displayName": "currency",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "card",
"displayName": "card",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
}
]
},
"options": {}
},
"id": "da5fa9e4-7566-4384-9015-07017bae37d8",
"name": "Send",
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.5,
"position": [
1920,
380
],
"credentials": {
"googleSheetsOAuth2Api": {
"id": "flAcWUeyvdjh7MiW",
"name": "Google Sheets account: hana@hanamizuki.tw (GCP: n8n)"
}
}
},
{
"parameters": {
"promptType": "define",
"text": "=這是我的消費明細信件中的單筆消費內容，請幫我擷取內容來記帳。其中信件來源有 0, 1, 2 三種選項。0 是國泰卡明細，1 是其他信用卡明細，2 是消費記錄。如果是 2，card 欄位回傳 null。",
"hasOutputParser": true,
"messages": {
"messageValues": [
{
"type": "HumanMessagePromptTemplate",
"message": "=信件日期：{{ $json.email_date }}\n信件標題：{{ $json.email_subject }}\n信件內容：\n{{ $json.email_content }}\n信件來源：{{ $json.email_type }}"
}
]
}
},
"id": "160835e8-e304-4988-adbd-147a3f035f74",
"name": "Extract details",
"type": "@n8n/n8n-nodes-langchain.chainLlm",
"typeVersion": 1.4,
"position": [
1580,
380
]
},
{
"parameters": {
"rules": {
"values": [
{
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict"
},
"conditions": [
{
"leftValue": "={{ $json.from.value[0].address }}",
"rightValue": "service@pxbillrc01.cathaybk.com.tw",
"operator": {
"type": "string",
"operation": "equals"
}
}
],
"combinator": "and"
},
"renameOutput": true,
"outputKey": "國泰刷卡記錄"
},
{
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict"
},
"conditions": [
{
"id": "47e3b84f-903c-4594-9297-785cfbea0316",
"leftValue": "={{ $json.from.value[0].address }}",
"rightValue": "\b(?:noreply@messaging\.hsbc\.com\.tw|hello@crypto\.com|taipeifubon\.com\.tw)\b",
"operator": {
"type": "string",
"operation": "regex"
}
}
],
"combinator": "and"
},
"renameOutput": true,
"outputKey": "其他信用卡刷卡記錄"
},
{
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict"
},
"conditions": [
{
"id": "db9d40f1-8fa4-4908-9010-985072b3f319",
"leftValue": "={{ $json.from.value[0].address }}",
"rightValue": "\b(?:noreply@messaging\.hsbc\.com\.tw|hello@crypto\.com|taipeifubon\.com\.tw)\b",
"operator": {
"type": "string",
"operation": "notRegex"
}
}
],
"combinator": "and"
},
"renameOutput": true,
"outputKey": "消費記錄"
}
]
},
"options": {}
},
"id": "86b7ce41-8bd2-4e29-9f53-f4995bbffe7c",
"name": "Switch",
"type": "n8n-nodes-base.switch",
"typeVersion": 3.1,
"position": [
920,
380
],
"alwaysOutputData": false,
"executeOnce": false
}
],
"connections": {
"Gmail Trigger": {
"main": [
[
{
"node": "Switch",
"type": "main",
"index": 0
}
]
]
},
"HTML": {
"main": [
[
{
"node": "Split Out",
"type": "main",
"index": 0
}
]
]
},
"Split Out": {
"main": [
[
{
"node": "Set data",
"type": "main",
"index": 0
}
]
]
},
"Structured Output Parser1": {
"ai_outputParser": [
[
{
"node": "Extract details",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"Google Gemini Chat Model1": {
"ai_languageModel": [
[
{
"node": "Extract details",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Set data": {
"main": [
[
{
"node": "Extract details",
"type": "main",
"index": 0
}
]
]
},
"Extract details": {
"main": [
[
{
"node": "Send",
"type": "main",
"index": 0
}
]
]
},
"Switch": {
"main": [
[
{
"node": "HTML",
"type": "main",
"index": 0
}
],
[
{
"node": "Set data",
"type": "main",
"index": 0
}
],
[
{
"node": "Set data",
"type": "main",
"index": 0
}
]
]
}
},
"pinData": {}
}