私のワークフロー4
上級
これはDocument Extraction, AI Summarization分野の自動化ワークフローで、25個のノードを含みます。主にSet, Code, Merge, Switch, Webhookなどのノードを使用。 JSON、Googleスプレッドシート、GPT-4oを使用したSAP B1仕訳転記の自動化
前提条件
- •HTTP Webhookエンドポイント（n8nが自動生成）
- •ターゲットAPIの認証情報が必要な場合あり
- •Google Sheets API認証情報
- •OpenAI API Key
ワークフロープレビュー
ノード接続関係を可視化、ズームとパンをサポート
ワークフローをエクスポート
以下のJSON設定をn8nにインポートして、このワークフローを使用できます
{
"id": "6f68qrMxAD14jS4i",
"meta": {
"instanceId": "558d88703fb65b2d0e44613bc35916258b0f0bf983c5d4730c00c424b77ca36a"
},
"name": "My workflow 4",
"tags": [
{
"id": "GvklsLWXMBUjgBiK",
"name": "SAPB1-2=Finanzas",
"createdAt": "2025-07-03T12:55:09.224Z",
"updatedAt": "2025-07-03T12:55:09.224Z"
}
],
"nodes": [
{
"id": "6f3055d0-2612-49e5-8b70-ade568596658",
"name": "Webhook Trigger",
"type": "n8n-nodes-base.webhook",
"position": [
-1820,
720
],
"webhookId": "991024c1-f7fc-4515-99ef-2b53df96f8cb",
"parameters": {},
"typeVersion": 1
},
{
"id": "a85066bb-91fa-4e1f-bb09-d7164165b2f6",
"name": "SAPログイン",
"type": "n8n-nodes-base.httpRequest",
"position": [
-1580,
720
],
"parameters": {},
"typeVersion": 4.2,
"alwaysOutputData": false
},
{
"id": "a53020c0-c167-4cf1-9597-95b07d7b87cd",
"name": "ソース別ルーティング",
"type": "n8n-nodes-base.switch",
"position": [
-1300,
720
],
"parameters": {},
"typeVersion": 3.2,
"alwaysOutputData": false
},
{
"id": "08c6fdef-b4e9-4f82-8080-7f8d06ba4336",
"name": "JSON フィールドのマッピング",
"type": "n8n-nodes-base.set",
"position": [
-720,
480
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "ff7679dd-811c-4b83-9e35-f61c4a6ac2b2",
"name": "仕訳転記 (JSON)",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueErrorOutput",
"position": [
-480,
480
],
"parameters": {},
"typeVersion": 4.2,
"alwaysOutputData": false
},
{
"id": "838b28c5-1ccb-40bc-9e07-88569e11287f",
"name": "成功ログ (JSON)",
"type": "n8n-nodes-base.googleSheets",
"position": [
-240,
320
],
"parameters": {},
"typeVersion": 4.6,
"alwaysOutputData": false
},
{
"id": "1900cd98-9b64-41f7-af03-68018376e6da",
"name": "エラーログ (JSON)",
"type": "n8n-nodes-base.googleSheets",
"position": [
-240,
540
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "a9d367d5-cef4-40d8-8d13-dc0da04e424a",
"name": "LLM変換 (手動)",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
-780,
1500
],
"parameters": {},
"typeVersion": 1.8
},
{
"id": "41f1f35e-a4b2-4510-8910-8b1742df417f",
"name": "仕訳転記 (手動)",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueErrorOutput",
"position": [
-380,
1500
],
"parameters": {},
"typeVersion": 4.2,
"alwaysOutputData": false
},
{
"id": "2c445e36-67b3-44c1-912d-1225ab4d5077",
"name": "成功ログ (手動)",
"type": "n8n-nodes-base.googleSheets",
"position": [
-100,
1360
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "42d94e4b-0a1d-482a-88bb-5397129dd29a",
"name": "エラーログ (手動)",
"type": "n8n-nodes-base.googleSheets",
"position": [
-100,
1580
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "fab58a6e-27c7-4021-9183-065d40f25e7d",
"name": "SAPデータ設定",
"type": "n8n-nodes-base.set",
"position": [
-740,
980
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "980fa23f-1850-4594-9e92-6aea0a6e62bb",
"name": "シートデータ読み込み",
"type": "n8n-nodes-base.googleSheets",
"position": [
-480,
1100
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "d83ac837-292a-4a5c-b537-e89d3671c23c",
"name": "シート明細行の整形",
"type": "n8n-nodes-base.set",
"position": [
-220,
1100
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "532419b3-33fe-4b6d-8ec0-6db03126faa1",
"name": "シート JSON の解析",
"type": "n8n-nodes-base.code",
"position": [
20,
1100
],
"parameters": {},
"typeVersion": 2
},
{
"id": "aa35f48c-7aee-4b57-85bc-1acaaace7324",
"name": "LLM変換 (シート)",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
240,
1100
],
"parameters": {},
"typeVersion": 1.8
},
{
"id": "0fda167e-545f-4b3d-ae86-366ca46f83c1",
"name": "仕訳本体の構築",
"type": "n8n-nodes-base.set",
"position": [
580,
1100
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "2fbf56de-2d73-46bb-851a-174ff3eedb73",
"name": "ヘッダーと明細行の結合",
"type": "n8n-nodes-base.merge",
"position": [
780,
960
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "2ea523f5-16b4-4fa7-96e1-d3f0fd415d8c",
"name": "仕訳転記 (シート)",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueErrorOutput",
"position": [
980,
960
],
"parameters": {},
"typeVersion": 4.2,
"alwaysOutputData": false
},
{
"id": "470caa25-52dd-424e-a000-d07ebabcb6e5",
"name": "成功ログ (シート)",
"type": "n8n-nodes-base.googleSheets",
"position": [
1220,
800
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "a17b7dd8-747e-4b5b-9f2f-dadd607e8b3f",
"name": "エラーログ (シート)",
"type": "n8n-nodes-base.googleSheets",
"position": [
1220,
1020
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "12d5eb01-d326-4b35-b922-5bb148b32fc4",
"name": "付箋",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1880,
560
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "a621ad9e-20e1-454d-acb9-1ce7376da82c",
"name": "付箋1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-800,
240
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "2230580e-5800-4dc0-96f4-276152c330f3",
"name": "付箋2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-800,
760
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "94b1309f-5a8f-479e-a82b-6dea66f4cf17",
"name": "付箋3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-800,
1320
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "a7b337d9-989c-45b5-bb73-457c480ce81c",
"connections": {
"a85066bb-91fa-4e1f-bb09-d7164165b2f6": {
"main": [
[
{
"node": "a53020c0-c167-4cf1-9597-95b07d7b87cd",
"type": "main",
"index": 0
}
]
]
},
"fab58a6e-27c7-4021-9183-065d40f25e7d": {
"main": [
[
{
"node": "980fa23f-1850-4594-9e92-6aea0a6e62bb",
"type": "main",
"index": 0
},
{
"node": "2fbf56de-2d73-46bb-851a-174ff3eedb73",
"type": "main",
"index": 1
}
]
]
},
"980fa23f-1850-4594-9e92-6aea0a6e62bb": {
"main": [
[
{
"node": "d83ac837-292a-4a5c-b537-e89d3671c23c",
"type": "main",
"index": 0
}
]
]
},
"08c6fdef-b4e9-4f82-8080-7f8d06ba4336": {
"main": [
[
{
"node": "ff7679dd-811c-4b83-9e35-f61c4a6ac2b2",
"type": "main",
"index": 0
}
]
]
},
"a53020c0-c167-4cf1-9597-95b07d7b87cd": {
"main": [
[
{
"node": "08c6fdef-b4e9-4f82-8080-7f8d06ba4336",
"type": "main",
"index": 0
}
],
[
{
"node": "fab58a6e-27c7-4021-9183-065d40f25e7d",
"type": "main",
"index": 0
}
],
[
{
"node": "a9d367d5-cef4-40d8-8d13-dc0da04e424a",
"type": "main",
"index": 0
}
]
]
},
"6f3055d0-2612-49e5-8b70-ade568596658": {
"main": [
[
{
"node": "a85066bb-91fa-4e1f-bb09-d7164165b2f6",
"type": "main",
"index": 0
}
]
]
},
"532419b3-33fe-4b6d-8ec0-6db03126faa1": {
"main": [
[
{
"node": "aa35f48c-7aee-4b57-85bc-1acaaace7324",
"type": "main",
"index": 0
}
]
]
},
"d83ac837-292a-4a5c-b537-e89d3671c23c": {
"main": [
[
{
"node": "532419b3-33fe-4b6d-8ec0-6db03126faa1",
"type": "main",
"index": 0
}
]
]
},
"0fda167e-545f-4b3d-ae86-366ca46f83c1": {
"main": [
[
{
"node": "2fbf56de-2d73-46bb-851a-174ff3eedb73",
"type": "main",
"index": 0
}
]
]
},
"ff7679dd-811c-4b83-9e35-f61c4a6ac2b2": {
"main": [
[
{
"node": "838b28c5-1ccb-40bc-9e07-88569e11287f",
"type": "main",
"index": 0
}
],
[
{
"node": "1900cd98-9b64-41f7-af03-68018376e6da",
"type": "main",
"index": 0
}
]
]
},
"2fbf56de-2d73-46bb-851a-174ff3eedb73": {
"main": [
[
{
"node": "2ea523f5-16b4-4fa7-96e1-d3f0fd415d8c",
"type": "main",
"index": 0
}
]
]
},
"2ea523f5-16b4-4fa7-96e1-d3f0fd415d8c": {
"main": [
[
{
"node": "470caa25-52dd-424e-a000-d07ebabcb6e5",
"type": "main",
"index": 0
}
],
[
{
"node": "a17b7dd8-747e-4b5b-9f2f-dadd607e8b3f",
"type": "main",
"index": 0
}
]
]
},
"aa35f48c-7aee-4b57-85bc-1acaaace7324": {
"main": [
[
{
"node": "0fda167e-545f-4b3d-ae86-366ca46f83c1",
"type": "main",
"index": 0
}
]
]
},
"41f1f35e-a4b2-4510-8910-8b1742df417f": {
"main": [
[
{
"node": "2c445e36-67b3-44c1-912d-1225ab4d5077",
"type": "main",
"index": 0
}
],
[
{
"node": "42d94e4b-0a1d-482a-88bb-5397129dd29a",
"type": "main",
"index": 0
}
]
]
},
"a9d367d5-cef4-40d8-8d13-dc0da04e424a": {
"main": [
[
{
"node": "41f1f35e-a4b2-4510-8910-8b1742df417f",
"type": "main",
"index": 0
}
]
]
}
}
}よくある質問
このワークフローの使い方は？
上記のJSON設定コードをコピーし、n8nインスタンスで新しいワークフローを作成して「JSONからインポート」を選択、設定を貼り付けて認証情報を必要に応じて変更してください。
このワークフローはどんな場面に適していますか？
上級 - 文書抽出, AI要約
有料ですか？
このワークフローは完全無料です。ただし、ワークフローで使用するサードパーティサービス（OpenAI APIなど）は別途料金が発生する場合があります。
関連ワークフロー
毎日の WhatsApp グループ スマート分析：GPT-4.1 による分析と音声メッセージの transcrição
毎日の WhatsApp グループ インタラクティブ分析：GPT-4.1 分析と音声メッセージ文字起こし
If
Set
Code
+
If
Set
Code
52 ノードDaniel Lianes
その他
VEXA、OpenAI、Mem0を使った会議のAI分析の自動化
VEXA、OpenAI、Mem0を使った会議対話洞察の自動分析
Set
Code
Merge
+
Set
Code
Merge
26 ノードStephan Koning
文書抽出
潜在顧客開掘とメールワーキングフロー
Google Maps、SendGrid、AIを使用してB2Bリード獲得とメールマーケティングを自動化
If
Set
Code
+
If
Set
Code
141 ノードEzema Kingsley Chibuzo
リード獲得
OCR テレグラム - SAP
Telegram、GPT-4o、OCR、SAPを活用した自動入金処理
Set
Code
Wait
+
Set
Code
Wait
29 ノードRaquel Giugliano
人工知能
GPT-4o、WordPress、LinkedInを使ってRSSから自動でブログ記事を投稿
GPT-4o、WordPress、LinkedInを使ってRSSコンテンツを自動のにブログ記事へ公開
If
Set
Code
+
If
Set
Code
40 ノードImmanuel
人工知能
AI、ElevenLabs、マルチプラットフォーム公開を使ってPOVビデオの作成と承認
AI、ElevenLabs、そしてマルチプラットフォーム公開を使ったPOVビデオの作成と承認（TikTok/IG/YT）
If
Set
Code
+
If
Set
Code
60 ノードImmanuel
デザイン
