n8nを使用したAirtableからPostgresへの自動移行
上級
これはIT Ops分野の自動化ワークフローで、66個のノードを含みます。主にIf, Set, Code, Html, Limitなどのノードを使用。 n8nによるAirtableからPostgresへの自動移行
前提条件
- •HTTP Webhookエンドポイント（n8nが自動生成）
- •ターゲットAPIの認証情報が必要な場合あり
使用ノード (66)
カテゴリー
ワークフロープレビュー
ノード接続関係を可視化、ズームとパンをサポート
ワークフローをエクスポート
以下のJSON設定をn8nにインポートして、このワークフローを使用できます
{
"meta": {
"instanceId": "db80165df40cb07c0377167c050b3f9ab0b0fb04f0e8cae0dc53f5a8527103ca",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "7cc4e21b-cb92-479e-a1fb-3451afecfb1f",
"name": "ループ処理",
"type": "n8n-nodes-base.splitInBatches",
"position": [
740,
140
],
"parameters": {},
"typeVersion": 3
},
{
"id": "c38d0912-cce6-46fb-9a50-a466c2c25928",
"name": "付箋5",
"type": "n8n-nodes-base.stickyNote",
"position": [
700,
20
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "a63abdc8-3b60-43df-bcf3-91dd08fbbec4",
"name": "Create database",
"type": "n8n-nodes-base.code",
"position": [
1680,
200
],
"parameters": {},
"typeVersion": 2
},
{
"id": "2de91fa1-ad35-41d5-b37f-8ef4c80af3c1",
"name": "Ser user data",
"type": "n8n-nodes-base.set",
"position": [
1480,
200
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "32dc59c6-161b-4aa4-bd98-fe3036d793df",
"name": "set error",
"type": "n8n-nodes-base.set",
"position": [
1880,
200
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "20c9a32b-4d06-447d-98db-b2e0a728ca38",
"name": "制限1",
"type": "n8n-nodes-base.limit",
"disabled": true,
"position": [
520,
420
],
"parameters": {},
"typeVersion": 1
},
{
"id": "56795d8b-81bd-4add-b68f-ff924305d6e8",
"name": "ループ処理1",
"type": "n8n-nodes-base.splitInBatches",
"position": [
760,
580
],
"parameters": {},
"typeVersion": 3
},
{
"id": "92a44c39-91d1-4c96-a1c7-96ca8f99f86f",
"name": "Ser user data1",
"type": "n8n-nodes-base.set",
"position": [
1820,
660
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "b23dee3e-2ed4-4972-b62d-7eb86752fa16",
"name": "Edit Fields",
"type": "n8n-nodes-base.set",
"position": [
1640,
660
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "8f666a17-53a7-4361-af17-7f3abadc6c71",
"name": "Upsert records",
"type": "n8n-nodes-base.code",
"position": [
2000,
660
],
"parameters": {},
"typeVersion": 2
},
{
"id": "ceaa9cde-a1b0-41da-aaee-5e5ae6d772f7",
"name": "設定 columns",
"type": "n8n-nodes-base.set",
"position": [
920,
40
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "805b9321-e7f6-4834-a104-b61d1149ced0",
"name": "制限3",
"type": "n8n-nodes-base.limit",
"disabled": true,
"position": [
1240,
980
],
"parameters": {},
"typeVersion": 1
},
{
"id": "d23c5883-e59f-4315-99bc-9c148b1a2964",
"name": "Fields",
"type": "n8n-nodes-base.set",
"position": [
1400,
980
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "965c32c8-e6ef-4f2a-93e9-21993d397e65",
"name": "ループ処理2",
"type": "n8n-nodes-base.splitInBatches",
"position": [
1600,
980
],
"parameters": {},
"typeVersion": 3
},
{
"id": "abf83ac2-2b18-4a75-be09-b4edfeee91cb",
"name": "Ser user data2",
"type": "n8n-nodes-base.set",
"position": [
1840,
1120
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "e69aceba-f09d-4e30-8f2d-fd51f7707d68",
"name": "Edit Fields1",
"type": "n8n-nodes-base.set",
"position": [
1820,
960
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "7d2963d2-fd0b-4f79-8073-0e2b153b2b39",
"name": "付箋",
"type": "n8n-nodes-base.stickyNote",
"position": [
700,
920
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "45a53775-a5d2-423e-9e93-e9d69059ee69",
"name": "付箋1",
"type": "n8n-nodes-base.stickyNote",
"position": [
700,
460
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "1235d5c0-0213-4ed6-8a74-10436712f23f",
"name": "If1",
"type": "n8n-nodes-base.if",
"position": [
1100,
680
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "b782d0de-9c14-47ff-af73-4d0ca8874488",
"name": "get schema",
"type": "n8n-nodes-base.httpRequest",
"position": [
60,
420
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "2c1b1269-f6a8-48f3-a9ad-6ad3a640f6b3",
"name": "分割出力",
"type": "n8n-nodes-base.splitOut",
"position": [
200,
420
],
"parameters": {},
"typeVersion": 1
},
{
"id": "5474c06f-db29-4f9c-8905-cd2865509518",
"name": "set globals",
"type": "n8n-nodes-base.set",
"position": [
380,
420
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "527425b9-55a1-4416-bece-727413f2a1ef",
"name": "分割出力2",
"type": "n8n-nodes-base.splitOut",
"position": [
1060,
980
],
"parameters": {},
"typeVersion": 1
},
{
"id": "ea5c2bb4-a6d5-4027-bf1f-df70bab1f361",
"name": "Upsert records2",
"type": "n8n-nodes-base.code",
"onError": "continueRegularOutput",
"position": [
940,
1380
],
"parameters": {},
"typeVersion": 2
},
{
"id": "dd128785-1a30-43ec-a0f0-f4e1fc0b3f3d",
"name": "付箋2",
"type": "n8n-nodes-base.stickyNote",
"position": [
700,
1340
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "958dc213-4f2d-4814-b5b4-f469dd049698",
"name": "Airtable - Postgres",
"type": "n8n-nodes-base.webhook",
"position": [
-240,
-760
],
"webhookId": "f652c351-81e1-4a01-abca-d22ea59ae742",
"parameters": {},
"typeVersion": 2
},
{
"id": "132a2f21-ef78-40b1-98aa-2cf7ae83cb26",
"name": "Respond to Webhook トリガー",
"type": "n8n-nodes-base.respondToWebhook",
"position": [
340,
-760
],
"parameters": {},
"typeVersion": 1.1
},
{
"id": "2dbef75e-c917-42db-88f9-372cdde690d6",
"name": "Claude",
"type": "n8n-nodes-base.html",
"position": [
140,
-760
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "a57a0cd3-45c8-4e6f-a806-faa5a2d02d69",
"name": "Test credentials",
"type": "n8n-nodes-base.httpRequest",
"position": [
1140,
-500
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "55cb7baf-f712-4ec1-95b0-da82f2c9294c",
"name": "付箋3",
"type": "n8n-nodes-base.stickyNote",
"position": [
700,
-540
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "7d745baa-5841-49e5-953e-69000647367a",
"name": "付箋4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-300,
-800
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "aa35440f-e058-4ffc-b8b2-ee01c3c8ffbe",
"name": "Pass all data",
"type": "n8n-nodes-base.set",
"position": [
-760,
420
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "0b76bae8-0081-4782-8303-ae1524423a30",
"name": "If",
"type": "n8n-nodes-base.if",
"position": [
720,
-400
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "c4290ddb-6bf8-4ed6-b078-164dd6ae71c8",
"name": "Get records",
"type": "n8n-nodes-base.httpRequest",
"position": [
940,
680
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "4dfcc6f9-c738-4b69-8fa7-a33e9ac84e5f",
"name": "分割出力3",
"type": "n8n-nodes-base.splitOut",
"position": [
1280,
660
],
"parameters": {},
"typeVersion": 1
},
{
"id": "82fd4438-6c3a-4c7e-92ac-208eafef23fa",
"name": "設定 record fields",
"type": "n8n-nodes-base.set",
"position": [
1460,
660
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "d0915dfd-9256-40c4-b6a8-1e0204815a24",
"name": "New mapper",
"type": "n8n-nodes-base.code",
"position": [
1080,
220
],
"parameters": {},
"typeVersion": 2
},
{
"id": "ef13bffd-18c1-425f-ac49-5d4c8c219165",
"name": "If3",
"type": "n8n-nodes-base.if",
"position": [
1240,
220
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "17dfa37d-490f-4b31-84d9-75f20997d630",
"name": "Airtable - Postgres system",
"type": "n8n-nodes-base.webhook",
"position": [
-980,
420
],
"webhookId": "f652c351-81e1-4a01-abca-d22ea59ae742",
"parameters": {},
"typeVersion": 2
},
{
"id": "b612df7f-27b7-478b-a168-4f0cbc9a8bdb",
"name": "set tables found",
"type": "n8n-nodes-base.set",
"position": [
1660,
-500
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "3f48f6d3-d8f4-4b1b-b17e-6b1ae83e3bac",
"name": "success message",
"type": "n8n-nodes-base.set",
"position": [
1480,
-400
],
"parameters": {},
"executeOnce": true,
"typeVersion": 3.4
},
{
"id": "77d41da1-7fb6-4f7d-900a-e5fa8b895b78",
"name": "Failure message",
"type": "n8n-nodes-base.set",
"position": [
1500,
-240
],
"parameters": {},
"executeOnce": true,
"typeVersion": 3.4
},
{
"id": "7b7f1fdc-168b-4d59-aced-50a6fc94a250",
"name": "Pass both responses",
"type": "n8n-nodes-base.set",
"position": [
1680,
-240
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "62380ea4-521f-434e-b993-f80cfe46644f",
"name": "if successful",
"type": "n8n-nodes-base.if",
"position": [
1280,
-320
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "9a224788-cddc-4f84-b035-071bbcd18adb",
"name": "Test postgres credentials",
"type": "n8n-nodes-base.code",
"position": [
1100,
-320
],
"parameters": {},
"typeVersion": 2
},
{
"id": "086846b4-b698-4d25-b0cc-0eb0aa524f8a",
"name": "Edit postgres fields",
"type": "n8n-nodes-base.set",
"position": [
920,
-320
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "99d1c93c-52d1-4035-b0ff-83eb9a44d8de",
"name": "付箋6",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1720,
-260
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "44b12810-895a-4f50-a5e0-e2d306c11491",
"name": "base id to delete",
"type": "n8n-nodes-base.set",
"position": [
740,
980
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "a15b9dd2-e057-432f-84cf-270ee1e87b60",
"name": "get schema to delete",
"type": "n8n-nodes-base.httpRequest",
"position": [
900,
980
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "74940eee-8673-4353-82fa-1e14a6feedfe",
"name": "Delete table",
"type": "n8n-nodes-base.code",
"onError": "continueRegularOutput",
"position": [
2020,
1120
],
"parameters": {},
"typeVersion": 2
},
{
"id": "9a8ea80f-acd3-4aae-ac9c-d76217e74756",
"name": "設定 user data3",
"type": "n8n-nodes-base.set",
"position": [
740,
1380
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "73ef4d66-022d-42a9-a89e-1f2864bf8617",
"name": "Edit Fields2",
"type": "n8n-nodes-base.set",
"position": [
920,
500
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "363734be-a114-4963-8506-079cc8330176",
"name": "Edit airtable fields1",
"type": "n8n-nodes-base.respondToWebhook",
"position": [
2000,
960
],
"parameters": {},
"typeVersion": 1.1
},
{
"id": "79ff06d3-216d-4419-9103-d00030847648",
"name": "Edit airtable fields2",
"type": "n8n-nodes-base.respondToWebhook",
"position": [
1180,
1380
],
"parameters": {},
"typeVersion": 1.1
},
{
"id": "bee99633-57a6-413f-b26c-cba90b31ae5e",
"name": "スイッチ",
"type": "n8n-nodes-base.switch",
"position": [
-540,
400
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "3df05140-7aec-4333-958d-e68382168888",
"name": "付箋7",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1760,
60
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "7ec508c9-60e0-41f5-a79b-a1f100843f33",
"name": "set webhook",
"type": "n8n-nodes-base.set",
"position": [
-40,
-760
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "d2d998aa-b64c-4c09-ae6d-81fca23a306b",
"name": "postgres credentials",
"type": "n8n-nodes-base.set",
"position": [
-220,
-400
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "19486fd8-9dd6-45b6-8bfb-3d0b04c88921",
"name": "Credential response",
"type": "n8n-nodes-base.respondToWebhook",
"position": [
1860,
-400
],
"parameters": {},
"typeVersion": 1.1
},
{
"id": "5255ec1d-6f79-4d74-82d1-ee3ed1c8b401",
"name": "Credential response1",
"type": "n8n-nodes-base.respondToWebhook",
"position": [
1360,
520
],
"parameters": {},
"typeVersion": 1.1
},
{
"id": "16c6d887-f5c9-4a67-a9fc-62534bed91be",
"name": "Set webhook user data",
"type": "n8n-nodes-base.set",
"position": [
-240,
420
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "750c16c0-5111-49f9-92ca-c0e4be56f928",
"name": "airtable fields",
"type": "n8n-nodes-base.set",
"position": [
920,
-500
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "29bef374-f55d-4ff3-982e-3a86ff1bd828",
"name": "付箋8",
"type": "n8n-nodes-base.stickyNote",
"position": [
-580,
200
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "3efd48d2-e29c-4b1d-9b67-753c8197d0e6",
"name": "付箋9",
"type": "n8n-nodes-base.stickyNote",
"position": [
-320,
200
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "0de7ce0e-35da-43bc-818f-8d830047ea2d",
"name": "Validate base id",
"type": "n8n-nodes-base.set",
"position": [
-80,
420
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "6a59b874-7323-4cc9-85dd-c66d17b33250",
"name": "Field mapping",
"type": "n8n-nodes-base.set",
"position": [
920,
220
],
"parameters": {},
"typeVersion": 3.4
}
],
"pinData": {
"Edit Fields1": [
{
"table": "appointments_and_calls",
"existed": false,
"message": "Table \"appointments_and_calls\" did not exist. No action needed.",
"success": true
},
{
"table": "lead_enrichment",
"existed": false,
"message": "Table \"lead_enrichment\" did not exist. No action needed.",
"success": true
},
{
"table": "meeting_notes",
"existed": false,
"message": "Table \"meeting_notes\" did not exist. No action needed.",
"success": true
}
],
"Upsert records2": [
{
"tables": [
"Doc-Spezialisten",
"youtube_captions",
"user_google_tokens",
"profiles",
"chat_messages",
"newsletter_summaries",
"Doc-Spezialisten_websites",
"onboarding",
"user_property_preferences"
],
"success": true
}
],
"Airtable - Postgres system": [
{
"body": {
"airtable": {
"airtableId": "app12345",
"airtableToken": "pjhy.iyhhs"
}
},
"query": {},
"params": {
"variable": "validate-airtable"
},
"headers": {
"via": "1.1 Caddy",
"host": "dev.funautomations.io",
"accept": "application/json,text/html,application/xhtml+xml,application/xml,text/*;q=0.9, image/*;q=0.8, */*;q=0.7",
"user-agent": "axios/1.8.3",
"content-type": "application/json",
"content-length": "67",
"accept-encoding": "gzip, compress, deflate, br",
"x-forwarded-for": "10.0.1.1",
"x-forwarded-host": "dev.funautomations.io",
"x-forwarded-proto": "https"
},
"webhookUrl": "https://dev.funautomations.io/webhook-test/f652c351-81e1-4a01-abca-d22ea59ae742/:variable",
"executionMode": "test"
}
]
},
"connections": {
"0b76bae8-0081-4782-8303-ae1524423a30": {
"main": [
[
{
"node": "750c16c0-5111-49f9-92ca-c0e4be56f928",
"type": "main",
"index": 0
}
],
[
{
"node": "086846b4-b698-4d25-b0cc-0eb0aa524f8a",
"type": "main",
"index": 0
}
]
]
},
"1235d5c0-0213-4ed6-8a74-10436712f23f": {
"main": [
[
{
"node": "Split Out3",
"type": "main",
"index": 0
}
],
[
{
"node": "Loop Over Items1",
"type": "main",
"index": 0
}
]
]
},
"ef13bffd-18c1-425f-ac49-5d4c8c219165": {
"main": [
[
{
"node": "2de91fa1-ad35-41d5-b37f-8ef4c80af3c1",
"type": "main",
"index": 0
}
],
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"2dbef75e-c917-42db-88f9-372cdde690d6": {
"main": [
[
{
"node": "Respond to Webhook",
"type": "main",
"index": 0
}
]
]
},
"d23c5883-e59f-4315-99bc-9c148b1a2964": {
"main": [
[
{
"node": "Loop Over Items2",
"type": "main",
"index": 0
}
]
]
},
"Limit1": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
},
{
"node": "Loop Over Items1",
"type": "main",
"index": 0
}
]
]
},
"Limit3": {
"main": [
[
{
"node": "d23c5883-e59f-4315-99bc-9c148b1a2964",
"type": "main",
"index": 0
}
]
]
},
"Switch": {
"main": [
[
{
"node": "d2d998aa-b64c-4c09-ae6d-81fca23a306b",
"type": "main",
"index": 0
}
],
[
{
"node": "16c6d887-f5c9-4a67-a9fc-62534bed91be",
"type": "main",
"index": 0
}
],
[
{
"node": "44b12810-895a-4f50-a5e0-e2d306c11491",
"type": "main",
"index": 0
}
],
[
{
"node": "Set user data3",
"type": "main",
"index": 0
}
]
]
},
"Split Out": {
"main": [
[
{
"node": "5474c06f-db29-4f9c-8905-cd2865509518",
"type": "main",
"index": 0
}
]
]
},
"32dc59c6-161b-4aa4-bd98-fe3036d793df": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"d0915dfd-9256-40c4-b6a8-1e0204815a24": {
"main": [
[
{
"node": "ef13bffd-18c1-425f-ac49-5d4c8c219165",
"type": "main",
"index": 0
}
]
]
},
"Split Out2": {
"main": [
[
{
"node": "Limit3",
"type": "main",
"index": 0
}
]
]
},
"Split Out3": {
"main": [
[
{
"node": "Set record fields",
"type": "main",
"index": 0
}
]
]
},
"b782d0de-9c14-47ff-af73-4d0ca8874488": {
"main": [
[
{
"node": "Split Out",
"type": "main",
"index": 0
}
]
]
},
"b23dee3e-2ed4-4972-b62d-7eb86752fa16": {
"main": [
[
{
"node": "92a44c39-91d1-4c96-a1c7-96ca8f99f86f",
"type": "main",
"index": 0
}
]
]
},
"c4290ddb-6bf8-4ed6-b078-164dd6ae71c8": {
"main": [
[
{
"node": "1235d5c0-0213-4ed6-8a74-10436712f23f",
"type": "main",
"index": 0
}
]
]
},
"5474c06f-db29-4f9c-8905-cd2865509518": {
"main": [
[
{
"node": "Limit1",
"type": "main",
"index": 0
}
]
]
},
"7ec508c9-60e0-41f5-a79b-a1f100843f33": {
"main": [
[
{
"node": "2dbef75e-c917-42db-88f9-372cdde690d6",
"type": "main",
"index": 0
}
]
]
},
"74940eee-8673-4353-82fa-1e14a6feedfe": {
"main": [
[
{
"node": "Loop Over Items2",
"type": "main",
"index": 0
}
]
]
},
"e69aceba-f09d-4e30-8f2d-fd51f7707d68": {
"main": [
[
{
"node": "363734be-a114-4963-8506-079cc8330176",
"type": "main",
"index": 0
}
]
]
},
"73ef4d66-022d-42a9-a89e-1f2864bf8617": {
"main": [
[
{
"node": "5255ec1d-6f79-4d74-82d1-ee3ed1c8b401",
"type": "main",
"index": 0
}
]
]
},
"6a59b874-7323-4cc9-85dd-c66d17b33250": {
"main": [
[
{
"node": "d0915dfd-9256-40c4-b6a8-1e0204815a24",
"type": "main",
"index": 0
}
]
]
},
"aa35440f-e058-4ffc-b8b2-ee01c3c8ffbe": {
"main": [
[
{
"node": "Switch",
"type": "main",
"index": 0
}
]
]
},
"2de91fa1-ad35-41d5-b37f-8ef4c80af3c1": {
"main": [
[
{
"node": "a63abdc8-3b60-43df-bcf3-91dd08fbbec4",
"type": "main",
"index": 0
}
]
]
},
"62380ea4-521f-434e-b993-f80cfe46644f": {
"main": [
[
{
"node": "3f48f6d3-d8f4-4b1b-b17e-6b1ae83e3bac",
"type": "main",
"index": 0
}
],
[
{
"node": "77d41da1-7fb6-4f7d-900a-e5fa8b895b78",
"type": "main",
"index": 0
}
]
]
},
"92a44c39-91d1-4c96-a1c7-96ca8f99f86f": {
"main": [
[
{
"node": "8f666a17-53a7-4361-af17-7f3abadc6c71",
"type": "main",
"index": 0
}
]
]
},
"abf83ac2-2b18-4a75-be09-b4edfeee91cb": {
"main": [
[
{
"node": "74940eee-8673-4353-82fa-1e14a6feedfe",
"type": "main",
"index": 0
}
]
]
},
"Set user data3": {
"main": [
[
{
"node": "ea5c2bb4-a6d5-4027-bf1f-df70bab1f361",
"type": "main",
"index": 0
}
]
]
},
"8f666a17-53a7-4361-af17-7f3abadc6c71": {
"main": [
[
{
"node": "Loop Over Items1",
"type": "main",
"index": 0
}
]
]
},
"a63abdc8-3b60-43df-bcf3-91dd08fbbec4": {
"main": [
[
{
"node": "32dc59c6-161b-4aa4-bd98-fe3036d793df",
"type": "main",
"index": 0
}
]
]
},
"77d41da1-7fb6-4f7d-900a-e5fa8b895b78": {
"main": [
[
{
"node": "7b7f1fdc-168b-4d59-aced-50a6fc94a250",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items": {
"main": [
[
{
"node": "Set columns",
"type": "main",
"index": 0
}
],
[
{
"node": "6a59b874-7323-4cc9-85dd-c66d17b33250",
"type": "main",
"index": 0
}
]
]
},
"ea5c2bb4-a6d5-4027-bf1f-df70bab1f361": {
"main": [
[
{
"node": "79ff06d3-216d-4419-9103-d00030847648",
"type": "main",
"index": 0
}
]
]
},
"750c16c0-5111-49f9-92ca-c0e4be56f928": {
"main": [
[
{
"node": "a57a0cd3-45c8-4e6f-a806-faa5a2d02d69",
"type": "main",
"index": 0
}
]
]
},
"3f48f6d3-d8f4-4b1b-b17e-6b1ae83e3bac": {
"main": [
[
{
"node": "7b7f1fdc-168b-4d59-aced-50a6fc94a250",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items1": {
"main": [
[
{
"node": "73ef4d66-022d-42a9-a89e-1f2864bf8617",
"type": "main",
"index": 0
}
],
[
{
"node": "c4290ddb-6bf8-4ed6-b078-164dd6ae71c8",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items2": {
"main": [
[
{
"node": "e69aceba-f09d-4e30-8f2d-fd51f7707d68",
"type": "main",
"index": 0
}
],
[
{
"node": "abf83ac2-2b18-4a75-be09-b4edfeee91cb",
"type": "main",
"index": 0
}
]
]
},
"a57a0cd3-45c8-4e6f-a806-faa5a2d02d69": {
"main": [
[
{
"node": "b612df7f-27b7-478b-a168-4f0cbc9a8bdb",
"type": "main",
"index": 0
}
]
]
},
"b612df7f-27b7-478b-a168-4f0cbc9a8bdb": {
"main": [
[
{
"node": "19486fd8-9dd6-45b6-8bfb-3d0b04c88921",
"type": "main",
"index": 0
}
]
]
},
"Set record fields": {
"main": [
[
{
"node": "b23dee3e-2ed4-4972-b62d-7eb86752fa16",
"type": "main",
"index": 0
}
]
]
},
"0de7ce0e-35da-43bc-818f-8d830047ea2d": {
"main": [
[
{
"node": "b782d0de-9c14-47ff-af73-4d0ca8874488",
"type": "main",
"index": 0
}
]
]
},
"44b12810-895a-4f50-a5e0-e2d306c11491": {
"main": [
[
{
"node": "a15b9dd2-e057-432f-84cf-270ee1e87b60",
"type": "main",
"index": 0
}
]
]
},
"958dc213-4f2d-4814-b5b4-f469dd049698": {
"main": [
[
{
"node": "7ec508c9-60e0-41f5-a79b-a1f100843f33",
"type": "main",
"index": 0
}
],
[]
]
},
"7b7f1fdc-168b-4d59-aced-50a6fc94a250": {
"main": [
[
{
"node": "19486fd8-9dd6-45b6-8bfb-3d0b04c88921",
"type": "main",
"index": 0
}
]
]
},
"086846b4-b698-4d25-b0cc-0eb0aa524f8a": {
"main": [
[
{
"node": "9a224788-cddc-4f84-b035-071bbcd18adb",
"type": "main",
"index": 0
}
]
]
},
"a15b9dd2-e057-432f-84cf-270ee1e87b60": {
"main": [
[
{
"node": "Split Out2",
"type": "main",
"index": 0
}
]
]
},
"d2d998aa-b64c-4c09-ae6d-81fca23a306b": {
"main": [
[
{
"node": "0b76bae8-0081-4782-8303-ae1524423a30",
"type": "main",
"index": 0
}
]
]
},
"16c6d887-f5c9-4a67-a9fc-62534bed91be": {
"main": [
[
{
"node": "0de7ce0e-35da-43bc-818f-8d830047ea2d",
"type": "main",
"index": 0
}
]
]
},
"9a224788-cddc-4f84-b035-071bbcd18adb": {
"main": [
[
{
"node": "62380ea4-521f-434e-b993-f80cfe46644f",
"type": "main",
"index": 0
}
]
]
},
"17dfa37d-490f-4b31-84d9-75f20997d630": {
"main": [
[
{
"node": "aa35440f-e058-4ffc-b8b2-ee01c3c8ffbe",
"type": "main",
"index": 0
}
]
]
}
}
}よくある質問
このワークフローの使い方は？
上記のJSON設定コードをコピーし、n8nインスタンスで新しいワークフローを作成して「JSONからインポート」を選択、設定を貼り付けて認証情報を必要に応じて変更してください。
このワークフローはどんな場面に適していますか？
上級 - IT運用
有料ですか？
このワークフローは完全無料です。ただし、ワークフローで使用するサードパーティサービス（OpenAI APIなど）は別途料金が発生する場合があります。
関連ワークフロー
Microsoft Teams会議分析をGPT-4.1、Outlook、Mem.aiを使用して自動化
GPT-4.1、Outlook、Mem.aiを使ってMicrosoft Teams会議の分析を自動化する
If
Set
Code
+
If
Set
Code
61 ノードWayne Simpson
人事
Scalewayサーバーの情報すべてを取得
Dynamic filteringを使用してScalewayサーバ情報を取得
If
Set
Code
+
If
Set
Code
24 ノードPablo
エンジニアリング
n8nノードの探索（可視化リファレンスライブラリ内）
n8nノードを可視化リファレンスライブラリで探索
If
Ftp
Set
+
If
Ftp
Set
113 ノードI versus AI
その他
GitHub 同期ダッシュボード - V2
コミット履歴とロールバック機能を備えた GitHub ワークフロー バージョン管理ダッシュボード
If
N8n
Set
+
If
N8n
Set
94 ノードEduard
DevOps
[テンプレート] AIペットショップ v8
AIペットショップアシスタント - GPT-4o、Googleカレンダー、WhatsApp/Instagram/Facebookを統合
If
N8n
Set
+
If
N8n
Set
244 ノードAmanda Benks
営業
AI エージェント レストラン [テンプレート]
🤖 WhatsApp、Instagram、MessengerのAIレストランアシスタント
If
N8n
Set
+
If
N8n
Set
239 ノードAmanda Benks
その他
ワークフロー情報
難易度
上級
ノード数66
カテゴリー1
ノードタイプ12
作成者
Imperol
@imperolqAutomation expert with years of experience helping businesses improve their efficiency and productivity with smart automations that are affordable, scalable, and flexible.
外部リンク
n8n.ioで表示 →
このワークフローを共有