請求書処理と検証 - n8n テンプレート
上級
これはFinance, AI分野の自動化ワークフローで、47個のノードを含みます。主にIf, Set, Code, Wait, Gmailなどのノードを使用、AI技術を活用したスマート自動化を実現。 Gmail、ドライブ、スプレッドシート、OCR AIに基づく請求書検証と確認
前提条件
- •Googleアカウント + Gmail API認証情報
- •Google Drive API認証情報
- •Google Sheets API認証情報
使用ノード (47)
ワークフロープレビュー
ノード接続関係を可視化、ズームとパンをサポート
ワークフローをエクスポート
以下のJSON設定をn8nにインポートして、このワークフローを使用できます
{
"id": "WAoelkm3KLBC3HS5",
"meta": {
"instanceId": "761a3dddae2bb21eb8973ffca0ba97d5b4f499405873760164a536f547546882",
"templateCredsSetupCompleted": true
},
"name": "Invoice Process & Validation - n8n Template",
"tags": [
{
"id": "1z2CftJo81tuGP80",
"createdAt": "2025-04-22T11:45:54.057Z",
"updatedAt": "2025-04-22T11:45:54.057Z"
}
],
"nodes": [
{
"id": "1d22cbef-a424-4c22-9365-9b5925de2dd5",
"name": "ファイルから抽出",
"type": "n8n-nodes-base.extractFromFile",
"position": [
-1240,
320
],
"parameters": {},
"typeVersion": 1
},
{
"id": "5ed93d14-2ccf-4608-af7e-0de45c8a8b4f",
"name": "OpenRouter Chat Model",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenRouter",
"position": [
-800,
300
],
"parameters": {},
"typeVersion": 1
},
{
"id": "801a89a2-1033-46ce-a514-da48581ad7aa",
"name": "分割",
"type": "n8n-nodes-base.splitOut",
"position": [
20,
0
],
"parameters": {},
"typeVersion": 1
},
{
"id": "13284bb7-9e59-42b8-ac39-d1a0a3694a5a",
"name": "後処理",
"type": "n8n-nodes-base.code",
"position": [
-380,
60
],
"parameters": {},
"typeVersion": 2
},
{
"id": "e7e86334-ac7b-43d0-b518-68111c358ad6",
"name": "テキスト抽出",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
-820,
140
],
"parameters": {},
"retryOnFail": true,
"typeVersion": 1.8
},
{
"id": "320d2a1f-92b3-46b7-ae9e-6b025c50393e",
"name": "条件分岐",
"type": "n8n-nodes-base.if",
"position": [
-200,
60
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "14320290-f059-4e23-a9b3-dac08dee0038",
"name": "生テキスト再送信",
"type": "n8n-nodes-base.set",
"position": [
0,
240
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "a482f4f6-02c5-4dc5-8101-355e44870a14",
"name": "項目ループ処理",
"type": "n8n-nodes-base.splitInBatches",
"position": [
-1000,
260
],
"parameters": {},
"typeVersion": 3
},
{
"id": "2b8174d9-6ea3-4b54-a556-856b8bf2ce01",
"name": "請求書データ送信",
"type": "n8n-nodes-base.googleSheets",
"position": [
480,
0
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "de512a48-39b7-49f8-a149-c50a188f3067",
"name": "マスターデータ取得",
"type": "n8n-nodes-base.googleSheets",
"position": [
680,
0
],
"parameters": {},
"executeOnce": true,
"typeVersion": 4.5
},
{
"id": "9edf61a4-5675-4497-9101-a3971f643f7c",
"name": "結果更新",
"type": "n8n-nodes-base.googleSheets",
"position": [
1120,
0
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "3afe5d8b-71a1-4678-a84a-038820b172ae",
"name": "待機",
"type": "n8n-nodes-base.wait",
"position": [
1760,
260
],
"webhookId": "bc95034e-d5a7-4f01-9edc-2d0fba1fdc1e",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "cd7afab5-1834-44d0-b7d7-8be7ca6e927d",
"name": "合計更新",
"type": "n8n-nodes-base.googleSheets",
"position": [
1540,
0
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "aee40f65-662f-468f-b78b-d21a7ba1e35e",
"name": "最終インデックス取得",
"type": "n8n-nodes-base.code",
"position": [
1320,
0
],
"parameters": {},
"typeVersion": 2
},
{
"id": "eaccc050-0cb9-4c0a-b51c-a65519543e28",
"name": "一意キー生成",
"type": "n8n-nodes-base.set",
"position": [
220,
0
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "52b6e590-13aa-43de-b926-73ba35119749",
"name": "検証",
"type": "n8n-nodes-base.code",
"position": [
940,
0
],
"parameters": {},
"typeVersion": 2
},
{
"id": "d16d5797-7edb-4a8a-bd87-37318a262635",
"name": "請求書アップロード",
"type": "n8n-nodes-base.googleDrive",
"position": [
-1240,
60
],
"parameters": {},
"executeOnce": false,
"retryOnFail": true,
"typeVersion": 3
},
{
"id": "7ff71799-9511-420f-8e5d-d2bedee65435",
"name": "添付ファイル取得",
"type": "n8n-nodes-base.code",
"position": [
-1480,
160
],
"parameters": {},
"typeVersion": 2
},
{
"id": "08a26b26-40a6-40a3-9b24-d4213c5ac99d",
"name": "結合",
"type": "n8n-nodes-base.merge",
"position": [
-1700,
160
],
"parameters": {},
"notesInFlow": false,
"typeVersion": 3.1
},
{
"id": "4b04705c-41bd-4e72-b82b-e45ed81ed421",
"name": "月次フォルダ作成",
"type": "n8n-nodes-base.googleDrive",
"position": [
-3020,
180
],
"parameters": {},
"executeOnce": true,
"typeVersion": 3
},
{
"id": "57fe45ba-46d0-4523-9898-98e1c4d06771",
"name": "日次フォルダ作成",
"type": "n8n-nodes-base.googleDrive",
"position": [
-2140,
160
],
"parameters": {},
"executeOnce": true,
"typeVersion": 3
},
{
"id": "c345741a-4b01-4c59-98ff-4d671e0ee6b2",
"name": "月次フォルダ検索",
"type": "n8n-nodes-base.googleDrive",
"position": [
-3440,
180
],
"parameters": {},
"executeOnce": true,
"typeVersion": 3,
"alwaysOutputData": true
},
{
"id": "64fecc15-e87b-41f0-ad3d-7c9aae9089f6",
"name": "月次フォルダ発見？",
"type": "n8n-nodes-base.if",
"position": [
-3240,
180
],
"parameters": {},
"executeOnce": true,
"typeVersion": 2.2
},
{
"id": "d1ff1737-5edb-4c48-95a1-31a3b6158658",
"name": "日次フォルダ検索",
"type": "n8n-nodes-base.googleDrive",
"position": [
-2800,
180
],
"parameters": {},
"executeOnce": true,
"typeVersion": 3,
"alwaysOutputData": true
},
{
"id": "7a119c08-83f3-4cfa-b5af-6a2c6eb96db2",
"name": "日次フォルダ発見？",
"type": "n8n-nodes-base.if",
"position": [
-2580,
180
],
"parameters": {},
"executeOnce": true,
"typeVersion": 2.2
},
{
"id": "ed86ba5d-6c46-4c9e-bfdc-c3f3a0ff1bb2",
"name": "親フォルダID取得",
"type": "n8n-nodes-base.googleDrive",
"position": [
-2360,
160
],
"parameters": {},
"typeVersion": 3
},
{
"id": "9299234c-fbe3-4b8d-a4f1-c2be9e3e8475",
"name": "日次フォルダID取得",
"type": "n8n-nodes-base.googleDrive",
"position": [
-1920,
160
],
"parameters": {},
"executeOnce": true,
"typeVersion": 3
},
{
"id": "d06008eb-b173-41b6-8750-01482ae99978",
"name": "本日の日付",
"type": "n8n-nodes-base.code",
"disabled": true,
"position": [
-4340,
260
],
"parameters": {},
"typeVersion": 2
},
{
"id": "a0c8c338-0db6-4136-8ec6-61be5026a071",
"name": "日付と時刻",
"type": "n8n-nodes-base.dateTime",
"disabled": true,
"position": [
-4560,
260
],
"parameters": {},
"typeVersion": 2
},
{
"id": "cb7c60c4-7754-4a58-a93f-8c7e38910317",
"name": "メッセージ読み取り",
"type": "n8n-nodes-base.gmail",
"position": [
-3680,
180
],
"webhookId": "c8dc8289-fd07-47ca-936a-60b773f1d5db",
"parameters": {},
"executeOnce": true,
"typeVersion": 2.1
},
{
"id": "42702132-3f06-4013-912e-8e203e751a4f",
"name": "メール件名から日付抽出",
"type": "n8n-nodes-base.code",
"position": [
-3900,
180
],
"parameters": {},
"typeVersion": 2
},
{
"id": "f462ff4f-d8e5-4055-b154-b27da3c05810",
"name": "付箋",
"type": "n8n-nodes-base.stickyNote",
"position": [
-4780,
160
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "fb3658be-c114-45e3-8277-265fca27bdf7",
"name": "Gmail トリガー",
"type": "n8n-nodes-base.gmail",
"position": [
-4100,
260
],
"webhookId": "5367935e-e021-4f57-ad94-aed46a7fb330",
"parameters": {},
"executeOnce": true,
"typeVersion": 2.1
},
{
"id": "d5f01e22-2920-4763-ad33-cf5af192ef8e",
"name": "スケジュールトリガー",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-4720,
260
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "cb99d7e4-2f71-4553-8636-5cb29b9f5ba7",
"name": "付箋1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-4140,
120
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "3577a2e3-5c6b-4871-bf50-568eda532e71",
"name": "付箋2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-3480,
120
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "aede2ed7-98c0-4f4c-853f-adfb6c7c7379",
"name": "付箋3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2820,
120
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "02652793-e97c-4125-af9e-9dcdc115adc1",
"name": "付箋4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1960,
100
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "55392a23-4ee8-404e-b316-4f693a28679c",
"name": "付箋5",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1300,
0
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "d908e128-4ce2-433c-8d07-7a45a43f9d66",
"name": "付箋6",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1300,
260
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "79afcd7b-c925-418a-a076-1186a6f5f95e",
"name": "付箋7",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1040,
60
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "4a071404-9e78-4d11-baee-ef19b9b91323",
"name": "付箋8",
"type": "n8n-nodes-base.stickyNote",
"position": [
-420,
0
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "e1a063cc-b1cf-492e-b395-b051786bde66",
"name": "付箋9",
"type": "n8n-nodes-base.stickyNote",
"position": [
-20,
-60
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "a3d4be55-4ff6-413f-9b83-d22d7fa7e946",
"name": "付箋10",
"type": "n8n-nodes-base.stickyNote",
"position": [
420,
-80
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "f9d7132f-c9a3-49f6-9a7b-c7a6851bbb06",
"name": "付箋11",
"type": "n8n-nodes-base.stickyNote",
"position": [
880,
-80
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "e7e7b9e0-3fdf-45e3-9ae1-4979ba55a028",
"name": "付箋12",
"type": "n8n-nodes-base.stickyNote",
"position": [
1300,
-80
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "ee01bd07-ab06-4ab2-812d-f0ea1fb77c72",
"name": "通知",
"type": "n8n-nodes-base.gmail",
"position": [
-980,
-120
],
"webhookId": "ef127986-3e93-4314-9292-ea6d4001bf2c",
"parameters": {},
"typeVersion": 2.1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "532de742-f619-4951-8521-541dbd3b8f81",
"connections": {
"320d2a1f-92b3-46b7-ae9e-6b025c50393e": {
"main": [
[
{
"node": "14320290-f059-4e23-a9b3-dac08dee0038",
"type": "main",
"index": 0
}
],
[
{
"node": "801a89a2-1033-46ce-a514-da48581ad7aa",
"type": "main",
"index": 0
}
]
]
},
"3afe5d8b-71a1-4678-a84a-038820b172ae": {
"main": [
[
{
"node": "a482f4f6-02c5-4dc5-8101-355e44870a14",
"type": "main",
"index": 0
}
]
]
},
"08a26b26-40a6-40a3-9b24-d4213c5ac99d": {
"main": [
[
{
"node": "7ff71799-9511-420f-8e5d-d2bedee65435",
"type": "main",
"index": 0
}
]
]
},
"801a89a2-1033-46ce-a514-da48581ad7aa": {
"main": [
[
{
"node": "eaccc050-0cb9-4c0a-b51c-a65519543e28",
"type": "main",
"index": 0
}
]
]
},
"52b6e590-13aa-43de-b926-73ba35119749": {
"main": [
[
{
"node": "9edf61a4-5675-4497-9101-a3971f643f7c",
"type": "main",
"index": 0
}
]
]
},
"a0c8c338-0db6-4136-8ec6-61be5026a071": {
"main": [
[
{
"node": "d06008eb-b173-41b6-8750-01482ae99978",
"type": "main",
"index": 0
}
]
]
},
"cb7c60c4-7754-4a58-a93f-8c7e38910317": {
"main": [
[
{
"node": "c345741a-4b01-4c59-98ff-4d671e0ee6b2",
"type": "main",
"index": 0
}
]
]
},
"d06008eb-b173-41b6-8750-01482ae99978": {
"main": [
[
{
"node": "fb3658be-c114-45e3-8277-265fca27bdf7",
"type": "main",
"index": 0
}
]
]
},
"fb3658be-c114-45e3-8277-265fca27bdf7": {
"main": [
[
{
"node": "42702132-3f06-4013-912e-8e203e751a4f",
"type": "main",
"index": 0
},
{
"node": "08a26b26-40a6-40a3-9b24-d4213c5ac99d",
"type": "main",
"index": 1
}
]
]
},
"cd7afab5-1834-44d0-b7d7-8be7ca6e927d": {
"main": [
[
{
"node": "3afe5d8b-71a1-4678-a84a-038820b172ae",
"type": "main",
"index": 0
}
]
]
},
"aee40f65-662f-468f-b78b-d21a7ba1e35e": {
"main": [
[
{
"node": "cd7afab5-1834-44d0-b7d7-8be7ca6e927d",
"type": "main",
"index": 0
}
]
]
},
"e7e86334-ac7b-43d0-b518-68111c358ad6": {
"main": [
[
{
"node": "13284bb7-9e59-42b8-ac39-d1a0a3694a5a",
"type": "main",
"index": 0
}
]
]
},
"9edf61a4-5675-4497-9101-a3971f643f7c": {
"main": [
[
{
"node": "aee40f65-662f-468f-b78b-d21a7ba1e35e",
"type": "main",
"index": 0
}
]
]
},
"7ff71799-9511-420f-8e5d-d2bedee65435": {
"main": [
[
{
"node": "d16d5797-7edb-4a8a-bd87-37318a262635",
"type": "main",
"index": 0
},
{
"node": "1d22cbef-a424-4c22-9365-9b5925de2dd5",
"type": "main",
"index": 0
}
]
]
},
"a482f4f6-02c5-4dc5-8101-355e44870a14": {
"main": [
[
{
"node": "ee01bd07-ab06-4ab2-812d-f0ea1fb77c72",
"type": "main",
"index": 0
}
],
[
{
"node": "e7e86334-ac7b-43d0-b518-68111c358ad6",
"type": "main",
"index": 0
}
]
]
},
"13284bb7-9e59-42b8-ac39-d1a0a3694a5a": {
"main": [
[
{
"node": "320d2a1f-92b3-46b7-ae9e-6b025c50393e",
"type": "main",
"index": 0
}
]
]
},
"d5f01e22-2920-4763-ad33-cf5af192ef8e": {
"main": [
[
{
"node": "a0c8c338-0db6-4136-8ec6-61be5026a071",
"type": "main",
"index": 0
}
]
]
},
"57fe45ba-46d0-4523-9898-98e1c4d06771": {
"main": [
[
{
"node": "9299234c-fbe3-4b8d-a4f1-c2be9e3e8475",
"type": "main",
"index": 0
}
]
]
},
"7a119c08-83f3-4cfa-b5af-6a2c6eb96db2": {
"main": [
[
{
"node": "ed86ba5d-6c46-4c9e-bfdc-c3f3a0ff1bb2",
"type": "main",
"index": 0
}
],
[
{
"node": "9299234c-fbe3-4b8d-a4f1-c2be9e3e8475",
"type": "main",
"index": 0
}
]
]
},
"1d22cbef-a424-4c22-9365-9b5925de2dd5": {
"main": [
[
{
"node": "a482f4f6-02c5-4dc5-8101-355e44870a14",
"type": "main",
"index": 0
}
]
]
},
"de512a48-39b7-49f8-a149-c50a188f3067": {
"main": [
[
{
"node": "52b6e590-13aa-43de-b926-73ba35119749",
"type": "main",
"index": 0
}
]
]
},
"9299234c-fbe3-4b8d-a4f1-c2be9e3e8475": {
"main": [
[
{
"node": "08a26b26-40a6-40a3-9b24-d4213c5ac99d",
"type": "main",
"index": 0
}
]
]
},
"d1ff1737-5edb-4c48-95a1-31a3b6158658": {
"main": [
[
{
"node": "7a119c08-83f3-4cfa-b5af-6a2c6eb96db2",
"type": "main",
"index": 0
}
]
]
},
"2b8174d9-6ea3-4b54-a556-856b8bf2ce01": {
"main": [
[
{
"node": "de512a48-39b7-49f8-a149-c50a188f3067",
"type": "main",
"index": 0
}
]
]
},
"4b04705c-41bd-4e72-b82b-e45ed81ed421": {
"main": [
[
{
"node": "d1ff1737-5edb-4c48-95a1-31a3b6158658",
"type": "main",
"index": 0
}
]
]
},
"eaccc050-0cb9-4c0a-b51c-a65519543e28": {
"main": [
[
{
"node": "2b8174d9-6ea3-4b54-a556-856b8bf2ce01",
"type": "main",
"index": 0
}
]
]
},
"64fecc15-e87b-41f0-ad3d-7c9aae9089f6": {
"main": [
[
{
"node": "4b04705c-41bd-4e72-b82b-e45ed81ed421",
"type": "main",
"index": 0
}
],
[
{
"node": "d1ff1737-5edb-4c48-95a1-31a3b6158658",
"type": "main",
"index": 0
}
]
]
},
"c345741a-4b01-4c59-98ff-4d671e0ee6b2": {
"main": [
[
{
"node": "64fecc15-e87b-41f0-ad3d-7c9aae9089f6",
"type": "main",
"index": 0
}
]
]
},
"14320290-f059-4e23-a9b3-dac08dee0038": {
"main": [
[
{
"node": "e7e86334-ac7b-43d0-b518-68111c358ad6",
"type": "main",
"index": 0
}
]
]
},
"ed86ba5d-6c46-4c9e-bfdc-c3f3a0ff1bb2": {
"main": [
[
{
"node": "57fe45ba-46d0-4523-9898-98e1c4d06771",
"type": "main",
"index": 0
}
]
]
},
"5ed93d14-2ccf-4608-af7e-0de45c8a8b4f": {
"ai_languageModel": [
[
{
"node": "e7e86334-ac7b-43d0-b518-68111c358ad6",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"42702132-3f06-4013-912e-8e203e751a4f": {
"main": [
[
{
"node": "cb7c60c4-7754-4a58-a93f-8c7e38910317",
"type": "main",
"index": 0
}
]
]
}
}
}よくある質問
このワークフローの使い方は？
上記のJSON設定コードをコピーし、n8nインスタンスで新しいワークフローを作成して「JSONからインポート」を選択、設定を貼り付けて認証情報を必要に応じて変更してください。
このワークフローはどんな場面に適していますか？
上級 - 財務, 人工知能
有料ですか？
このワークフローは完全無料です。ただし、ワークフローで使用するサードパーティサービス（OpenAI APIなど）は別途料金が発生する場合があります。
関連ワークフロー
ペットショップ 4
ペットショップ予約AIエージェント
If
Set
Code
+
If
Set
Code
187 ノードBruno Dias
人工知能
アクセルレーション隊スプリント計画の自動化
OpenAI、Googleカレンダー、Gmailを使ってアジャイルチームのスプリント計画を自動化
If
Set
Code
+
If
Set
Code
52 ノードWillemijn
プロダクト
OCR、AI、Google Sheetsをベースとした請求書処理と検証
OCR、AI、Googleスプレッドシートに基づく請求書処理と検証ツール
If
Set
Code
+
If
Set
Code
22 ノードDhrumil Patel
財務
n8nノードの探索（可視化リファレンスライブラリ内）
n8nノードを可視化リファレンスライブラリで探索
If
Ftp
Set
+
If
Ftp
Set
113 ノードI versus AI
その他
基于AIのMISエージェント
基于AIの管理信息系统エージェント
If
Set
Code
+
If
Set
Code
129 ノードKumar Shivam
サポート
AI、ElevenLabs、マルチプラットフォーム公開を使ってPOVビデオの作成と承認
AI、ElevenLabs、そしてマルチプラットフォーム公開を使ったPOVビデオの作成と承認（TikTok/IG/YT）
If
Set
Code
+
If
Set
Code
60 ノードImmanuel
デザイン
ワークフロー情報
難易度
上級
ノード数47
カテゴリー2
ノードタイプ16
作成者
Dhrumil Patel
@itechdp🚀 Automation Enthusiast | n8n Creator | SaaS & AI Innovator. I'm Dhrumil Patel, founder of SentIIMenta AI. I build smart solutions using n8n to automate workflows, connect data, and boost efficiency. Passionate about AI, SaaS, and no-code tools. Let’s simplify work and create impact together! 🌐 https://sentiimenta-ai.com | 📩 founder@sentiimenta-ai.com
外部リンク
n8n.ioで表示 →
このワークフローを共有