アドレス検証
上級
これはSales分野の自動化ワークフローで、31個のノードを含みます。主にIf, Set, Wait, Filter, Webhookなどのノードを使用。 Billbee注文における error な配送先住所の自動修正
前提条件
- •HTTP Webhookエンドポイント（n8nが自動生成）
- •ターゲットAPIの認証情報が必要な場合あり
カテゴリー
ワークフロープレビュー
ノード接続関係を可視化、ズームとパンをサポート
ワークフローをエクスポート
以下のJSON設定をn8nにインポートして、このワークフローを使用できます
{
"id": "VaU41OXvni95OlAL",
"meta": {
"instanceId": "1bc0f4fa5e7d17ac362404cbb49337e51e5061e019cfa24022a8667c1f1ce287",
"templateCredsSetupCompleted": true
},
"name": "address validation",
"tags": [],
"nodes": [
{
"id": "c6e389ae-6db2-416b-8f6f-91749fbc860f",
"name": "注文データ取得",
"type": "n8n-nodes-base.httpRequest",
"position": [
2500,
880
],
"parameters": {
"url": "=https://api.billbee.io/api/v1/orders/{{ $json.orderID }}",
"options": {},
"sendHeaders": true,
"authentication": "genericCredentialType",
"genericAuthType": "httpBasicAuth",
"headerParameters": {
"parameters": [
{
"name": "X-Billbee-Api-Key",
"value": "={{ $json['X-Billbee-Api-Key'] }}"
}
]
}
},
"typeVersion": 4.1
},
{
"id": "1b27594b-af74-4c25-bb4f-27550bcd152e",
"name": "注文データ分割",
"type": "n8n-nodes-base.splitOut",
"position": [
2660,
880
],
"parameters": {
"options": {},
"fieldToSplitOut": "Data.ShippingAddress.BillbeeId, Data.ShippingAddress.FirstName, Data.ShippingAddress.LastName, Data.ShippingAddress.Street, Data.ShippingAddress.HouseNumber, Data.ShippingAddress.Zip, Data.ShippingAddress.City, Data.ShippingAddress.CountryISO2, Data.ShippingAddress.Line2, Data.ShippingAddress.NameAddition"
},
"typeVersion": 1
},
{
"id": "43808f6f-815d-419c-9e6f-c12d436108f2",
"name": "住所フィールド設定",
"type": "n8n-nodes-base.set",
"position": [
2820,
880
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "dbda7791-09eb-4ae9-b1e8-7ce8582a5b4a",
"name": "first_name",
"type": "string",
"value": "={{ $json['Data.ShippingAddress.FirstName'] }}"
},
{
"id": "1d13d702-b422-48c4-be04-db7869776897",
"name": "family_name",
"type": "string",
"value": "={{ $json['Data.ShippingAddress.LastName'] }}"
},
{
"id": "9169466f-5639-4b58-80d3-c041ccea5e21",
"name": "Street",
"type": "string",
"value": "={{ $json['Data.ShippingAddress.Street'] }}"
},
{
"id": "ea20b727-83c0-4c23-94c7-29f4f57eda78",
"name": "housenumber",
"type": "string",
"value": "={{ $json['Data.ShippingAddress.HouseNumber'].replace(\"/\",\"\")}}"
},
{
"id": "81c3ebb0-6975-4b69-93f1-42dba7f2f60b",
"name": "zip",
"type": "string",
"value": "={{ $json['Data.ShippingAddress.Zip'] }}"
},
{
"id": "2f1a6786-d48b-4475-805e-1db2fef2b5c3",
"name": "location",
"type": "string",
"value": "={{ $json['Data.ShippingAddress.City'] }}"
},
{
"id": "4b6a4eb2-8867-4d9e-a4fb-32b66f466b58",
"name": "BillbeeID",
"type": "string",
"value": "={{ $('Webhook').item.json.query.Id }}"
},
{
"id": "814513e9-9e56-4fb8-84bc-fd01456af443",
"name": "BillbeeShippingAddressID",
"type": "string",
"value": "={{ $json['Data.ShippingAddress.BillbeeId'] }}"
},
{
"id": "bd45c9b8-d9fb-4d3f-be13-d202b8a3430d",
"name": "CountryISO2",
"type": "string",
"value": "={{ $json['Data.ShippingAddress.CountryISO2'] }}"
},
{
"id": "c8e08606-d860-4482-8b4e-c68fe4c1974f",
"name": "AddressLine2",
"type": "string",
"value": "={{ $json['Data.ShippingAddress.Line2'] }}"
},
{
"id": "fe1cb8a4-6c21-4505-8337-e31f07386a8c",
"name": "NameAddition",
"type": "string",
"value": "={{ $json['Data.ShippingAddress.NameAddition'] }}"
}
]
}
},
"typeVersion": 3.3
},
{
"id": "3e5f3fc5-d3e2-4f4a-978e-795893e016cc",
"name": "住所チェック endereco api",
"type": "n8n-nodes-base.httpRequest",
"position": [
4140,
760
],
"parameters": {
"url": "https://endereco-service.de/rpc/v1",
"method": "POST",
"options": {},
"jsonBody": "={\n \"jsonrpc\": \"2.0\",\n \"id\": 1,\n \"method\": \"addressCheck\",\n \"params\": {\n \"country\": \"{{ $json['CountryISO2']}}\",\n \"language\": \"{{ $json[\"CountryISO2\"] }}\",\n \"postCode\": \"{{ $json[\"zip\"] }}\",\n \"cityName\": \"{{ $json[\"location\"] }}\",\n \"street\": \"{{ $json[\"Street\"] }}\",\n \"houseNumber\": \"{{ $json[\"housenumber\"] }}\"\n }\n}",
"sendBody": true,
"sendHeaders": true,
"specifyBody": "json",
"headerParameters": {
"parameters": [
{
"name": "X-Auth-Key",
"value": "={{ $('ConfigNode').item.json['X-Auth-Key-Endereco'] }}"
},
{
"name": "Content-Type",
"value": "application/json"
},
{
"name": "X-Transaction-Id",
"value": "not_required"
},
{
"name": "X-Transaction-Referer",
"value": "n8n"
},
{
"name": "X-Agent",
"value": "n8n"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "3b02a11e-719b-41ef-b84f-b1e06d83854a",
"name": "修正住所分割",
"type": "n8n-nodes-base.splitOut",
"position": [
4600,
720
],
"parameters": {
"options": {},
"fieldToSplitOut": "result.predictions"
},
"typeVersion": 1
},
{
"id": "a3b6135a-6a0e-4c37-95ef-6e33f14c5e74",
"name": "Billbeeに新配送先住所を設定",
"type": "n8n-nodes-base.httpRequest",
"position": [
4920,
720
],
"parameters": {
"url": "=https://api.billbee.io/api/v1/customers/addresses/{{ $('Set Address Fields').item.json[\"BillbeeShippingAddressID\"] }}",
"method": "PATCH",
"options": {},
"sendBody": true,
"sendHeaders": true,
"authentication": "genericCredentialType",
"bodyParameters": {
"parameters": [
{
"name": "Housenumber",
"value": "={{ $json.houseNumber }}"
},
{
"name": "Street",
"value": "={{ $json.street }}"
},
{
"name": "Zip",
"value": "={{ $json.postCode }}"
},
{
"name": "City",
"value": "={{ $json.cityName }}"
}
]
},
"genericAuthType": "httpBasicAuth",
"headerParameters": {
"parameters": [
{
"name": "X-Billbee-Api-Key",
"value": "={{ $('ConfigNode').item.json['X-Billbee-Api-Key'] }}"
}
]
}
},
"typeVersion": 4.1
},
{
"id": "b170217c-b2d7-4514-b070-403e29964e4b",
"name": "待機",
"type": "n8n-nodes-base.wait",
"position": [
2120,
960
],
"webhookId": "0f7b87d2-ec90-4f54-9971-31e564206980",
"parameters": {
"amount": 1
},
"typeVersion": 1.1
},
{
"id": "17ea8895-05cd-4ffd-af31-aace970f8073",
"name": "待機1",
"type": "n8n-nodes-base.wait",
"position": [
4760,
720
],
"webhookId": "b7a0738c-0890-45f5-a435-bc9d9a9062bb",
"parameters": {
"amount": 1
},
"typeVersion": 1.1
},
{
"id": "d8d005e4-3b94-49d6-82dc-2919ca69dd2f",
"name": "新住所が空でないか確認",
"type": "n8n-nodes-base.if",
"position": [
4320,
760
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "2a9d055a-4607-4e87-bb6a-ecc1a31826e0",
"operator": {
"type": "array",
"operation": "notEmpty",
"singleValue": true
},
"leftValue": "={{ $json.result.predictions }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "3ad15e79-e4c8-4adf-90a5-aaf61cfe4825",
"name": "Billbeeタグ設定",
"type": "n8n-nodes-base.httpRequest",
"position": [
4580,
920
],
"parameters": {
"url": "=https://api.billbee.io/api/v1/orders/{{ $('Set Address Fields').item.json[\"BillbeeID\"] }}/tags",
"method": "POST",
"options": {},
"jsonBody": "{\n \"Tags\": [\n \"endereco_address_failed\"\n ]\n}",
"sendBody": true,
"sendHeaders": true,
"specifyBody": "json",
"authentication": "genericCredentialType",
"genericAuthType": "httpBasicAuth",
"headerParameters": {
"parameters": [
{
"name": "X-Billbee-Api-Key",
"value": "={{ $('ConfigNode').item.json['X-Billbee-Api-Key'] }}"
}
]
}
},
"typeVersion": 4.1
},
{
"id": "6b0e5cfb-95d5-43a0-a665-6b8db6b6ad98",
"name": "付箋",
"type": "n8n-nodes-base.stickyNote",
"position": [
2260,
820
],
"parameters": {
"color": 4,
"width": 481,
"height": 198,
"content": "## Get and Prepare Oder Data"
},
"typeVersion": 1
},
{
"id": "a2524895-b0dd-492b-b425-548ccbabf5c2",
"name": "付箋1",
"type": "n8n-nodes-base.stickyNote",
"position": [
460,
460
],
"parameters": {
"color": 7,
"width": 1110.4301052736698,
"height": 544.444950562247,
"content": "# **Address Validation Workflow**\n### **Requirements**\n- **Billbee Developer API Key**: Request via email: `support@billbee.io`.\n- **Billbee User API Key**: Found in the **Billbee settings**.\n- **Endereco API Key**: Register at [Endereco API](https://www.endereco.de/en/integrations/address-api/). **30-Day Free Trial available**.\n## **About**\nThis workflow automates the process of validating client shipping addresses, saving time and reducing errors. Your **warehouse team** will appreciate it!\n## **How it Works**\n1. **Start**: The workflow is triggered by a **Webhook** sent from Billbee (see configuration). The webhook provides the **Order ID**.\n2. **Retrieve Order Data**: Use the Order ID to call the **Billbee Order Endpoint**. This fetches the client's shipping address.\n3. **Data Mapping and Manipulation**: Rename and map the fields. Apply optional filters and data adjustments.\n3.1 **Validating the housenumber** (Most common error)\n4. **Validate Address**: Send the shipping address to the **Endereco API**. The API validates the address and, if necessary, suggests a corrected address.\n5. **Conditional Check**: **Was a new address suggested?** **Yes**: Update the client’s shipping address in Billbee. **No**: Add a **\"Validation Error\"** tag to the Billbee order.\n6. **Tag the Order**: For successfully validated orders, add a tag in Billbee to mark them as processed.\n### **Benefits**\n- **Time-Saving**: Automates address validation, reducing manual effort.\n- **Error Reduction**: Identifies incorrect addresses and suggests corrections automatically.\n- **Transparency**: Tracks the validation status with tags in Billbee.\n"
},
"typeVersion": 1
},
{
"id": "31bb6e73-e702-4577-8b7f-a9850e80cbaf",
"name": "付箋2",
"type": "n8n-nodes-base.stickyNote",
"position": [
1060,
1040
],
"parameters": {
"width": 276,
"height": 219,
"content": "## API Docs\n\nEndereco:\nhttps://github.com/Endereco/enderecoservice_api\n\nBillbee:\nhttps://app.billbee.io//swagger/ui/index\n"
},
"typeVersion": 1
},
{
"id": "4bb9d0c1-0838-449b-bb1e-c4912173d9df",
"name": "付箋3",
"type": "n8n-nodes-base.stickyNote",
"position": [
460,
1040
],
"parameters": {
"color": 5,
"width": 574.5277463210057,
"height": 573.7065374509425,
"content": "### Bilbee Setup \n### **Rule Settings**\n- **Name of the Rule:** Endereco Address Validation\n- **Comment:** *No comment provided.*\n- **Active:** ✅ Active\n- **Stop Rule Processing After This Rule:** ⬜ Disabled\n### **Trigger:**\n- **Event:** Order imported \n- **Import Type:** All import types\n### **Conditions:**\n- **Restrict Shop:** Rule applies only if the order comes from one of the defined shops.\n### **Actions:**\n- **Call External URL:** \n - **URL:** `YOUR_N8N_WEBHOOK_LINK?Id={OrderId}`\nThis rule ensures that for every imported order from a specific shop, the external webhook URL is triggered with the `OrderId` as a parameter.\n\n### Option 2\n\nIf order state gets changed to \"gepackt\", \"In Fulfillment\" by this you can manually correct the orders within Billbee as most address are fine. Make sure that the State does not trigger a different automation"
},
"typeVersion": 1
},
{
"id": "ad409a55-db7f-4699-9d56-98d7a2164afe",
"name": "番地が空でないか確認",
"type": "n8n-nodes-base.if",
"position": [
3260,
880
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "5dbd8016-9c70-4cd8-9c7b-22b6779d7ae3",
"operator": {
"type": "string",
"operation": "notEmpty",
"singleValue": true
},
"leftValue": "={{ $json.housenumber }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "0131cf4e-983b-4cc5-8305-e4a644f9e700",
"name": "住所2行目に数字が含まれるか確認",
"type": "n8n-nodes-base.if",
"position": [
3420,
980
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "e758c0d9-caf6-40e8-9ceb-cd786e346709",
"operator": {
"type": "boolean",
"operation": "true",
"singleValue": true
},
"leftValue": "={{ $json.AddressLine2.isNumeric() }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "14d67019-a6c2-4ad4-9c0e-383ee3e1f3e9",
"name": "フィルター",
"type": "n8n-nodes-base.filter",
"position": [
1360,
1320
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "13c4f784-fb7a-4a61-b106-eb92dbc8f2d0",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "851d9d42-2b50-4a40-8d46-7d3decf897c2",
"name": "付箋4",
"type": "n8n-nodes-base.stickyNote",
"position": [
1080,
1300
],
"parameters": {
"color": 3,
"height": 239.63602562365423,
"content": "## Include Filter \nYou want to filter out PickUp Shops or Parcel Stations for example in Germany:\n\n\"Postfiliale, Paketshop, Packstation\"\n\nThis can also be set up within Billbee"
},
"typeVersion": 1
},
{
"id": "a07c7816-bcb6-457d-a621-ccfebcc384ad",
"name": "住所2行目の値を番地として設定",
"type": "n8n-nodes-base.set",
"position": [
3600,
900
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "7c21cf08-4ae8-4856-ae2f-0f25053aebde",
"name": "housenumber",
"type": "string",
"value": "={{ $json.AddressLine2 }}"
}
]
},
"includeOtherFields": true
},
"typeVersion": 3.4
},
{
"id": "c22fb34a-252f-4570-b576-089bb3243bfd",
"name": "ピックアップ店舗を除外",
"type": "n8n-nodes-base.filter",
"position": [
3040,
880
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "or",
"conditions": [
{
"id": "b6bf1576-9082-446b-9072-13130bf7d724",
"operator": {
"type": "string",
"operation": "notContains"
},
"leftValue": "={{ $json.Street }}",
"rightValue": "Postfiliale"
},
{
"id": "f7e18eb3-a3df-49df-adb4-d9c807963478",
"operator": {
"type": "string",
"operation": "notContains"
},
"leftValue": "={{ $json.Street }}",
"rightValue": "Packstation"
},
{
"id": "51c548d1-1eed-4caf-b32c-402b8ce73042",
"operator": {
"type": "string",
"operation": "notContains"
},
"leftValue": "={{ $json.Street }}",
"rightValue": "Paketshop"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "b2b3c72a-d3d0-467f-8f60-17f40c7a3650",
"name": "付箋5",
"type": "n8n-nodes-base.stickyNote",
"position": [
3020,
820
],
"parameters": {
"color": 3,
"width": 155.04025478630723,
"height": 185.20127393153615,
"content": "## Open ME!"
},
"typeVersion": 1
},
{
"id": "ea2e9abf-1461-4754-b663-83e771207627",
"name": "住所2行目に数字と文字が含まれるか確認",
"type": "n8n-nodes-base.if",
"position": [
3560,
1080
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "loose"
},
"combinator": "and",
"conditions": [
{
"id": "c82c2273-b34c-42e1-871d-31db72d2ad49",
"operator": {
"type": "boolean",
"operation": "true",
"singleValue": true
},
"leftValue": "={{ $json[\"AddressLine2\"].match(/^(?=.*\\d)(?=.*[A-Za-z]).+$/) !== null }}\n",
"rightValue": ""
}
]
},
"looseTypeValidation": true
},
"typeVersion": 2.2
},
{
"id": "b532b22f-421e-4bd8-8241-ca559e77c3ca",
"name": "Billbeeタグ手動確認を設定",
"type": "n8n-nodes-base.httpRequest",
"position": [
3780,
1200
],
"parameters": {
"url": "=https://api.billbee.io/api/v1/orders/{{ $('Set Address Fields').item.json[\"BillbeeID\"] }}/tags",
"method": "POST",
"options": {},
"jsonBody": "{\n \"Tags\": [\n \"manual_address_check\"\n ]\n}",
"sendBody": true,
"sendHeaders": true,
"specifyBody": "json",
"authentication": "genericCredentialType",
"genericAuthType": "httpBasicAuth",
"headerParameters": {
"parameters": [
{
"name": "X-Billbee-Api-Key",
"value": "={{ $('ConfigNode').item.json['X-Billbee-Api-Key'] }}"
}
]
}
},
"typeVersion": 4.1
},
{
"id": "bdb10514-2fa7-4727-a8e7-aa8394fced6f",
"name": "住所2行目の値を番地（数字+文字）として設定",
"type": "n8n-nodes-base.set",
"position": [
3760,
1020
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "7c21cf08-4ae8-4856-ae2f-0f25053aebde",
"name": "housenumber",
"type": "string",
"value": "={{ $json.AddressLine2 }}"
}
]
},
"includeOtherFields": true
},
"typeVersion": 3.4
},
{
"id": "cf0a516f-f019-40f8-8d09-ff02a034781d",
"name": "付箋6",
"type": "n8n-nodes-base.stickyNote",
"position": [
3000,
760
],
"parameters": {
"color": 5,
"width": 907.6568579769853,
"height": 627.257034553087,
"content": "## House Number Validation"
},
"typeVersion": 1
},
{
"id": "82a16bec-77e9-4717-8111-69f8f068c925",
"name": "付箋7",
"type": "n8n-nodes-base.stickyNote",
"position": [
4040,
700
],
"parameters": {
"color": 4,
"width": 1325.4150814203485,
"height": 354.5727675883748,
"content": "## Address Validation & Correction"
},
"typeVersion": 1
},
{
"id": "07f54a0d-2b13-4996-95a4-4c225402abe1",
"name": "Billbee成功を設定",
"type": "n8n-nodes-base.httpRequest",
"position": [
5080,
720
],
"parameters": {
"url": "=https://api.billbee.io/api/v1/orders/{{ $('Set Address Fields').item.json[\"BillbeeID\"] }}/tags",
"method": "POST",
"options": {},
"jsonBody": "{\n \"Tags\": [\n \"endereco_address_validated\"\n ]\n}",
"sendBody": true,
"sendHeaders": true,
"specifyBody": "json",
"authentication": "genericCredentialType",
"genericAuthType": "httpBasicAuth",
"headerParameters": {
"parameters": [
{
"name": "X-Billbee-Api-Key",
"value": "={{ $('ConfigNode').item.json['X-Billbee-Api-Key'] }}"
}
]
}
},
"typeVersion": 4.1
},
{
"id": "bd2f3340-f389-48e1-a90d-1625b6845556",
"name": "設定ノード",
"type": "n8n-nodes-base.set",
"position": [
1860,
960
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "c4d1415a-636b-4673-bba5-699168af2b2e",
"name": "X-Billbee-Api-Key",
"type": "string",
"value": "INSERT BILLBEE DEVELOPER API KEY"
},
{
"id": "69c630d7-d64c-49be-a594-88b05d44a091",
"name": "X-Auth-Key-Endereco",
"type": "string",
"value": "INSERT ENDERECO API KEY"
},
{
"id": "75977810-a10a-45ea-b536-d4b8f0f59b15",
"name": "orderID",
"type": "string",
"value": "={{ $json.query.Id }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "7619e573-116a-4f87-b6d2-b652ee7a25b7",
"name": "付箋8",
"type": "n8n-nodes-base.stickyNote",
"position": [
1800,
1120
],
"parameters": {
"color": 3,
"height": 251.61012258936577,
"content": "### **Setup**\n\n**Create an Basic Auth for BillbeeUser**\n-E-Mail as Username, Password User API Key\n\nPaste your Billbee Developer Key (X Key) and Endereco API Key\n\n"
},
"typeVersion": 1
},
{
"id": "31c17f6e-0e90-4db1-9048-4b13bd36cc90",
"name": "付箋9",
"type": "n8n-nodes-base.stickyNote",
"position": [
2500,
1100
],
"parameters": {
"color": 3,
"width": 150,
"height": 135.6842625042993,
"content": "### **Setup**\n\nSelect your BillbeeUser Basic Auth \n\n"
},
"typeVersion": 1
},
{
"id": "ca1e1a8b-6107-4e0c-81c4-2a3b715aed11",
"name": "Webhook",
"type": "n8n-nodes-base.webhook",
"position": [
1640,
960
],
"webhookId": "786e8a93-9837-44e6-81ae-a173ce25a14f",
"parameters": {
"path": "786e8a93-9837-44e6-81ae-a173ce25a14f",
"options": {}
},
"typeVersion": 2
}
],
"active": false,
"pinData": {
"Webhook": [
{
"json": {
"body": {},
"query": {
"Id": "300000221273261"
},
"params": {},
"headers": {
"host": "sfx-ecommerce.app.n8n.cloud",
"x-real-ip": "49.12.91.132",
"tracestate": "dd=s:-1",
"traceparent": "00-00000000000000004c0234c4a8ce641b-3f1af42f856c7eb3-00",
"accept-encoding": "gzip",
"x-forwarded-for": "49.12.91.132",
"x-forwarded-host": "sfx-ecommerce.app.n8n.cloud",
"x-forwarded-port": "443",
"x-forwarded-proto": "https",
"x-datadog-trace-id": "5476998116086277147",
"x-forwarded-server": "traefik-78bdf4fd45-vvczp",
"x-datadog-parent-id": "4547215258723057331",
"x-datadog-sampling-priority": "-1"
},
"webhookUrl": "https://sfx-ecommerce.app.n8n.cloud/webhook/786e8a93-9837-44e6-81ae-a173ce25a14f",
"executionMode": "production"
}
}
]
},
"settings": {
"executionOrder": "v1"
},
"versionId": "1f498c7a-468a-48c4-b044-64455eb51aa2",
"connections": {
"b170217c-b2d7-4514-b070-403e29964e4b": {
"main": [
[
{
"node": "c6e389ae-6db2-416b-8f6f-91749fbc860f",
"type": "main",
"index": 0
}
]
]
},
"17ea8895-05cd-4ffd-af31-aace970f8073": {
"main": [
[
{
"node": "a3b6135a-6a0e-4c37-95ef-6e33f14c5e74",
"type": "main",
"index": 0
}
]
]
},
"ca1e1a8b-6107-4e0c-81c4-2a3b715aed11": {
"main": [
[
{
"node": "bd2f3340-f389-48e1-a90d-1625b6845556",
"type": "main",
"index": 0
}
]
]
},
"bd2f3340-f389-48e1-a90d-1625b6845556": {
"main": [
[
{
"node": "b170217c-b2d7-4514-b070-403e29964e4b",
"type": "main",
"index": 0
}
]
]
},
"c6e389ae-6db2-416b-8f6f-91749fbc860f": {
"main": [
[
{
"node": "1b27594b-af74-4c25-bb4f-27550bcd152e",
"type": "main",
"index": 0
}
]
]
},
"43808f6f-815d-419c-9e6f-c12d436108f2": {
"main": [
[
{
"node": "c22fb34a-252f-4570-b576-089bb3243bfd",
"type": "main",
"index": 0
}
]
]
},
"1b27594b-af74-4c25-bb4f-27550bcd152e": {
"main": [
[
{
"node": "43808f6f-815d-419c-9e6f-c12d436108f2",
"type": "main",
"index": 0
}
]
]
},
"c22fb34a-252f-4570-b576-089bb3243bfd": {
"main": [
[
{
"node": "ad409a55-db7f-4699-9d56-98d7a2164afe",
"type": "main",
"index": 0
}
]
]
},
"3e5f3fc5-d3e2-4f4a-978e-795893e016cc": {
"main": [
[
{
"node": "d8d005e4-3b94-49d6-82dc-2919ca69dd2f",
"type": "main",
"index": 0
}
]
]
},
"3b02a11e-719b-41ef-b84f-b1e06d83854a": {
"main": [
[
{
"node": "17ea8895-05cd-4ffd-af31-aace970f8073",
"type": "main",
"index": 0
}
]
]
},
"ad409a55-db7f-4699-9d56-98d7a2164afe": {
"main": [
[
{
"node": "3e5f3fc5-d3e2-4f4a-978e-795893e016cc",
"type": "main",
"index": 0
}
],
[
{
"node": "0131cf4e-983b-4cc5-8305-e4a644f9e700",
"type": "main",
"index": 0
}
]
]
},
"d8d005e4-3b94-49d6-82dc-2919ca69dd2f": {
"main": [
[
{
"node": "3b02a11e-719b-41ef-b84f-b1e06d83854a",
"type": "main",
"index": 0
}
],
[
{
"node": "3ad15e79-e4c8-4adf-90a5-aaf61cfe4825",
"type": "main",
"index": 0
}
]
]
},
"a3b6135a-6a0e-4c37-95ef-6e33f14c5e74": {
"main": [
[
{
"node": "07f54a0d-2b13-4996-95a4-4c225402abe1",
"type": "main",
"index": 0
}
]
]
},
"0131cf4e-983b-4cc5-8305-e4a644f9e700": {
"main": [
[
{
"node": "a07c7816-bcb6-457d-a621-ccfebcc384ad",
"type": "main",
"index": 0
}
],
[
{
"node": "ea2e9abf-1461-4754-b663-83e771207627",
"type": "main",
"index": 0
}
]
]
},
"a07c7816-bcb6-457d-a621-ccfebcc384ad": {
"main": [
[
{
"node": "3e5f3fc5-d3e2-4f4a-978e-795893e016cc",
"type": "main",
"index": 0
}
]
]
},
"ea2e9abf-1461-4754-b663-83e771207627": {
"main": [
[
{
"node": "bdb10514-2fa7-4727-a8e7-aa8394fced6f",
"type": "main",
"index": 0
}
],
[
{
"node": "b532b22f-421e-4bd8-8241-ca559e77c3ca",
"type": "main",
"index": 0
}
]
]
},
"bdb10514-2fa7-4727-a8e7-aa8394fced6f": {
"main": [
[
{
"node": "3e5f3fc5-d3e2-4f4a-978e-795893e016cc",
"type": "main",
"index": 0
}
]
]
}
}
}よくある質問
このワークフローの使い方は？
上記のJSON設定コードをコピーし、n8nインスタンスで新しいワークフローを作成して「JSONからインポート」を選択、設定を貼り付けて認証情報を必要に応じて変更してください。
このワークフローはどんな場面に適していますか？
上級 - 営業
有料ですか？
このワークフローは完全無料です。ただし、ワークフローで使用するサードパーティサービス（OpenAI APIなど）は別途料金が発生する場合があります。
関連ワークフロー
[テンプレート] AIペットショップ v8
AIペットショップアシスタント - GPT-4o、Googleカレンダー、WhatsApp/Instagram/Facebookを統合
If
N8n
Set
+
If
N8n
Set
244 ノードAmanda Benks
営業
基于AIの潜在顧客信息增强（Bright Data MCPとGoogle Sheets）
基于AIの潜在顧客信息增强：使用Bright Data MCPとGoogle Sheets
If
Set
Wait
+
If
Set
Wait
51 ノードCyril Nicko Gaspar
営業
Overpassリードジェネレーションシステム
OpenStreetMap データを使ってビジネスリードを生成して Google Sheets に保存
If
Set
Code
+
If
Set
Code
27 ノードAkram Kadri
営業
AI生成されたPDFファイルの改訂职场自動化方案提出
Google Mapsを使ってリードを生成する
If
Set
Code
+
If
Set
Code
42 ノードAlex Kim
営業
潜在顧客開掘とメールワーキングフロー
Google Maps、SendGrid、AIを使用してB2Bリード獲得とメールマーケティングを自動化
If
Set
Code
+
If
Set
Code
141 ノードEzema Kingsley Chibuzo
リード獲得
自動化プロスペクト生成とパーソナライズされたアウトリーチ：Apollo、AI、Instantly.ai
自動化avic リード生成とパーソナライズドウォームアップ：Apollo、AI、アンドインスタンティエイトpty
If
Set
Code
+
If
Set
Code
166 ノードRuben AI
リードナーチャリング
ワークフロー情報
難易度
上級
ノード数31
カテゴリー1
ノードタイプ8
作成者
Simon
@simonfesI am an E-commerce entrepreneur specializing in spare parts, with a strong passion for automation and AI. I leverage n8n to build complex workflows, integrating tools like SeaTable, Supabase with various E-com platforms. I'm dedicated to continuously improving workflow processes, particularly in the e-commerce sector.
外部リンク
n8n.ioで表示 →
このワークフローを共有