台湾銀行カード支払いリマインダーと追跡
上級
これは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-SINOPAC",
"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": "SINOPAC_PDF",
"type": "n8n-nodes-base.extractFromFile",
"position": [
40,
-220
],
"parameters": {},
"typeVersion": 1
},
{
"id": "6171ac4c-0172-4081-b3c4-b71d54cdd728",
"name": "SINOPAC_set field",
"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カレンダーイベント作成",
"type": "n8n-nodes-base.googleCalendar",
"position": [
680,
280
],
"parameters": {},
"typeVersion": 1.3
},
{
"id": "7f0b3a85-ff72-413f-a0f2-43ed65d23d6c",
"name": "Googleカレンダー更新 - ステータス変更",
"type": "n8n-nodes-base.googleCalendar",
"position": [
1100,
280
],
"parameters": {},
"typeVersion": 1.3
},
{
"id": "b387f226-878b-47fe-8d0d-8be96073f1bc",
"name": "Cathay_set field",
"type": "n8n-nodes-base.set",
"position": [
240,
-60
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "1b737a0a-476a-4135-b92e-1062133849df",
"name": "Gmail-CTBC",
"type": "n8n-nodes-base.gmailTrigger",
"position": [
-180,
120
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "33558faf-b386-4853-8482-e1f3a62eeddb",
"name": "CTBC_set field",
"type": "n8n-nodes-base.set",
"position": [
240,
120
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "2dc09bdc-1736-4209-adfb-2bcb384a3f0b",
"name": "Gmail-Cathay",
"type": "n8n-nodes-base.gmailTrigger",
"position": [
-180,
-60
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "86e8f0de-a82a-4dd7-964d-5e6ebc8b98bb",
"name": "Gmail-Fubon",
"type": "n8n-nodes-base.gmailTrigger",
"position": [
-180,
280
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "e0c37b7e-3124-45c5-9eba-ea3cea3fde00",
"name": "Fubon_PDF",
"type": "n8n-nodes-base.extractFromFile",
"position": [
40,
280
],
"parameters": {},
"typeVersion": 1
},
{
"id": "9987b2e7-22a5-4d64-8732-287a50db7c94",
"name": "Fubon_set field",
"type": "n8n-nodes-base.set",
"position": [
240,
280
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "541bb50b-5d1d-4b05-b15a-3d023494af5c",
"name": "Gmail-E.SUN",
"type": "n8n-nodes-base.gmailTrigger",
"position": [
-180,
440
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "edeca715-2478-4501-9950-2954d59dce8e",
"name": "E.SUN_PDF",
"type": "n8n-nodes-base.extractFromFile",
"position": [
40,
440
],
"parameters": {},
"typeVersion": 1
},
{
"id": "fcd79f66-68d8-4653-92f2-a2e88e4ce93b",
"name": "E.SUN_set field",
"type": "n8n-nodes-base.set",
"position": [
240,
440
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "e1f97003-9422-4ce3-a43c-4263c052ba19",
"name": "Gmail-DBS",
"type": "n8n-nodes-base.gmailTrigger",
"position": [
-180,
600
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "5414313b-d946-4c29-ba37-c2e638eccdf4",
"name": "DBS_PDF",
"type": "n8n-nodes-base.extractFromFile",
"position": [
40,
600
],
"parameters": {},
"typeVersion": 1
},
{
"id": "92035b9d-165e-4683-85f1-032f3fb6e024",
"name": "DBS_set field",
"type": "n8n-nodes-base.set",
"position": [
240,
600
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "25167f22-cfee-466e-af99-9598e98dd538",
"name": "Gmail-Union",
"type": "n8n-nodes-base.gmailTrigger",
"position": [
-180,
780
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "c793972f-6b17-4de7-99eb-d17f3e9b83c9",
"name": "Union_PDF",
"type": "n8n-nodes-base.extractFromFile",
"position": [
40,
780
],
"parameters": {},
"typeVersion": 1
},
{
"id": "9a121b73-61fb-47d6-8164-9c8b4f85ddc9",
"name": "Union_set fields",
"type": "n8n-nodes-base.set",
"position": [
240,
780
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "355b16e1-e9bf-42ab-b288-44b3fe50efb8",
"name": "Gmail-Taishin",
"type": "n8n-nodes-base.gmailTrigger",
"position": [
-180,
940
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "39b9103b-36a2-404c-818d-46a5b9fae9eb",
"name": "Taishin_PDF",
"type": "n8n-nodes-base.extractFromFile",
"position": [
40,
940
],
"parameters": {},
"typeVersion": 1
},
{
"id": "d64e3188-d6ab-45b0-9f9d-e9c2d999708f",
"name": "Taishin_set fields",
"type": "n8n-nodes-base.set",
"position": [
240,
940
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "d0f4865c-07d9-4291-9b16-c359d9593ec0",
"name": "GoogleカレンダーイベントID取得",
"type": "n8n-nodes-base.googleCalendar",
"position": [
60,
1280
],
"parameters": {},
"typeVersion": 1.3
},
{
"id": "567a8341-4098-43d0-a109-ae4d2c5c6dfb",
"name": "Googleカレンダーイベントステータス更新",
"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": {
"5414313b-d946-4c29-ba37-c2e638eccdf4": {
"main": [
[
{
"node": "92035b9d-165e-4683-85f1-032f3fb6e024",
"type": "main",
"index": 0
}
]
]
},
"4b0ea74d-db59-4363-81b3-78eef942c841": {
"main": [
[
{
"node": "d0f4865c-07d9-4291-9b16-c359d9593ec0",
"type": "main",
"index": 0
}
]
]
},
"edeca715-2478-4501-9950-2954d59dce8e": {
"main": [
[
{
"node": "fcd79f66-68d8-4653-92f2-a2e88e4ce93b",
"type": "main",
"index": 0
}
]
]
},
"e0c37b7e-3124-45c5-9eba-ea3cea3fde00": {
"main": [
[
{
"node": "9987b2e7-22a5-4d64-8732-287a50db7c94",
"type": "main",
"index": 0
}
]
]
},
"e1f97003-9422-4ce3-a43c-4263c052ba19": {
"main": [
[
{
"node": "5414313b-d946-4c29-ba37-c2e638eccdf4",
"type": "main",
"index": 0
}
]
]
},
"c793972f-6b17-4de7-99eb-d17f3e9b83c9": {
"main": [
[
{
"node": "9a121b73-61fb-47d6-8164-9c8b4f85ddc9",
"type": "main",
"index": 0
}
]
]
},
"1b737a0a-476a-4135-b92e-1062133849df": {
"main": [
[
{
"node": "33558faf-b386-4853-8482-e1f3a62eeddb",
"type": "main",
"index": 0
}
]
]
},
"541bb50b-5d1d-4b05-b15a-3d023494af5c": {
"main": [
[
{
"node": "edeca715-2478-4501-9950-2954d59dce8e",
"type": "main",
"index": 0
}
]
]
},
"86e8f0de-a82a-4dd7-964d-5e6ebc8b98bb": {
"main": [
[
{
"node": "e0c37b7e-3124-45c5-9eba-ea3cea3fde00",
"type": "main",
"index": 0
}
]
]
},
"25167f22-cfee-466e-af99-9598e98dd538": {
"main": [
[
{
"node": "c793972f-6b17-4de7-99eb-d17f3e9b83c9",
"type": "main",
"index": 0
}
]
]
},
"bf9c1bee-d8f0-4e9c-b13f-e2b3c7fbe32e": {
"main": [
[
{
"node": "6171ac4c-0172-4081-b3c4-b71d54cdd728",
"type": "main",
"index": 0
}
]
]
},
"39b9103b-36a2-404c-818d-46a5b9fae9eb": {
"main": [
[
{
"node": "d64e3188-d6ab-45b0-9f9d-e9c2d999708f",
"type": "main",
"index": 0
}
]
]
},
"2dc09bdc-1736-4209-adfb-2bcb384a3f0b": {
"main": [
[
{
"node": "b387f226-878b-47fe-8d0d-8be96073f1bc",
"type": "main",
"index": 0
}
]
]
},
"92035b9d-165e-4683-85f1-032f3fb6e024": {
"main": [
[
{
"node": "4122913f-4fff-4401-b52d-3e5fef868baa",
"type": "main",
"index": 0
}
]
]
},
"05026ee8-7b99-4ffd-9fda-cfa87b729633": {
"main": [
[
{
"node": "bf9c1bee-d8f0-4e9c-b13f-e2b3c7fbe32e",
"type": "main",
"index": 0
}
]
]
},
"355b16e1-e9bf-42ab-b288-44b3fe50efb8": {
"main": [
[
{
"node": "39b9103b-36a2-404c-818d-46a5b9fae9eb",
"type": "main",
"index": 0
}
]
]
},
"6c3b6c00-a0ac-474f-92a1-fcdea66516d7": {
"main": [
[
{
"node": "7f0b3a85-ff72-413f-a0f2-43ed65d23d6c",
"type": "main",
"index": 0
}
]
]
},
"4122913f-4fff-4401-b52d-3e5fef868baa": {
"main": [
[
{
"node": "26b44b81-539d-412b-8db5-009a62778fbe",
"type": "main",
"index": 0
}
]
]
},
"33558faf-b386-4853-8482-e1f3a62eeddb": {
"main": [
[
{
"node": "4122913f-4fff-4401-b52d-3e5fef868baa",
"type": "main",
"index": 0
}
]
]
},
"fcd79f66-68d8-4653-92f2-a2e88e4ce93b": {
"main": [
[
{
"node": "4122913f-4fff-4401-b52d-3e5fef868baa",
"type": "main",
"index": 0
}
]
]
},
"9987b2e7-22a5-4d64-8732-287a50db7c94": {
"main": [
[
{
"node": "4122913f-4fff-4401-b52d-3e5fef868baa",
"type": "main",
"index": 0
}
]
]
},
"b387f226-878b-47fe-8d0d-8be96073f1bc": {
"main": [
[
{
"node": "4122913f-4fff-4401-b52d-3e5fef868baa",
"type": "main",
"index": 0
}
]
]
},
"9a121b73-61fb-47d6-8164-9c8b4f85ddc9": {
"main": [
[
{
"node": "4122913f-4fff-4401-b52d-3e5fef868baa",
"type": "main",
"index": 0
}
]
]
},
"6171ac4c-0172-4081-b3c4-b71d54cdd728": {
"main": [
[
{
"node": "4122913f-4fff-4401-b52d-3e5fef868baa",
"type": "main",
"index": 0
}
]
]
},
"d64e3188-d6ab-45b0-9f9d-e9c2d999708f": {
"main": [
[
{
"node": "4122913f-4fff-4401-b52d-3e5fef868baa",
"type": "main",
"index": 0
}
]
]
},
"26b44b81-539d-412b-8db5-009a62778fbe": {
"main": [
[
{
"node": "6c3b6c00-a0ac-474f-92a1-fcdea66516d7",
"type": "main",
"index": 0
}
]
]
},
"d0f4865c-07d9-4291-9b16-c359d9593ec0": {
"main": [
[
{
"node": "567a8341-4098-43d0-a109-ae4d2c5c6dfb",
"type": "main",
"index": 0
}
]
]
},
"567a8341-4098-43d0-a109-ae4d2c5c6dfb": {
"main": [
[
{
"node": "99e6733b-d441-472f-80d3-034c3d658ea5",
"type": "main",
"index": 0
}
]
]
}
}
}よくある質問
このワークフローの使い方は？
上記のJSON設定コードをコピーし、n8nインスタンスで新しいワークフローを作成して「JSONからインポート」を選択、設定を貼り付けて認証情報を必要に応じて変更してください。
このワークフローはどんな場面に適していますか？
上級 - 財務
有料ですか？
このワークフローは完全無料です。ただし、ワークフローで使用するサードパーティサービス（OpenAI APIなど）は別途料金が発生する場合があります。
関連ワークフロー
n8nノードの探索（可視化リファレンスライブラリ内）
n8nノードを可視化リファレンスライブラリで探索
If
Ftp
Set
+
If
Ftp
Set
113 ノードI versus AI
その他
（Tung）OCRを使った領収書情報のテーブルコピーへ抽出
自動領収書・レシートOCRをGoogleスプレッドシートへ - ドライブ・Gmail・Telegramトリガー対応
If
Set
Code
+
If
Set
Code
25 ノードDaniel Ng
財務
ランニング河湖での毎日の飲水量自動追跡ツール
の水分を自動のに追跡 - テーブルに保存しSlackに通知
If
Set
Wait
+
If
Set
Wait
21 ノードdarrell_tw
その他
n8napi- which model to use workflow
ワークフローで使用されているAIモデルを確認する
N8n
Set
Filter
+
N8n
Set
Filter
12 ノードdarrell_tw
人工知能
テンプレートデモ - chatgpt - 画像 - 1 - drive および sheet 有りコピー
GPT-image-1で画像を生成し、Google Driveに保存（コスト追跡付き）
Set
Split Out
Aggregate
+
Set
Split Out
Aggregate
16 ノードdarrell_tw
デザイン
OCR、AI、Google Sheetsをベースとした請求書処理と検証
OCR、AI、Googleスプレッドシートに基づく請求書処理と検証ツール
If
Set
Code
+
If
Set
Code
22 ノードDhrumil Patel
財務
ワークフロー情報
難易度
上級
ノード数39
カテゴリー1
ノードタイプ8
作成者
darrell_tw
@darrelltwMartech Engineer with automation. here is my website: https://www.darrelltw.com/
外部リンク
n8n.ioで表示 →
このワークフローを共有