8
n8n 中文网amn8n.com

地址验证

高级

这是一个Sales领域的自动化工作流,包含 31 个节点。主要使用 If, Set, Wait, Filter, Webhook 等节点。 自动修正Billbee订单中的错误收货地址

前置要求
  • HTTP Webhook 端点(n8n 会自动生成)
  • 可能需要目标 API 的认证凭证

分类

工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入,即可使用此工作流
{
  "id": "VaU41OXvni95OlAL",
  "meta": {
    "instanceId": "1bc0f4fa5e7d17ac362404cbb49337e51e5061e019cfa24022a8667c1f1ce287",
    "templateCredsSetupCompleted": true
  },
  "name": "地址验证",
  "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": "## 获取并准备订单数据"
      },
      "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": "# **地址验证工作流程**"
      },
      "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 文档"
      },
      "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": "### Billbee 设置"
      },
      "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": "## 包含过滤器"
      },
      "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": "## 打开我!"
      },
      "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": "## 门牌号验证"
      },
      "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": "## 地址验证与校正"
      },
      "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": "### **设置**"
      },
      "typeVersion": 1
    },
    {
      "id": "31c17f6e-0e90-4db1-9048-4b13bd36cc90",
      "name": "### 替换 Airtable 连接",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2500,
        1100
      ],
      "parameters": {
        "color": 3,
        "width": 150,
        "height": 135.6842625042993,
        "content": "### **设置**"
      },
      "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": {
    "Wait": {
      "main": [
        [
          {
            "node": "get order data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Wait1": {
      "main": [
        [
          {
            "node": "set new delivery address to billbee",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Webhook": {
      "main": [
        [
          {
            "node": "ConfigNode",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "ConfigNode": {
      "main": [
        [
          {
            "node": "Wait",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "get order data": {
      "main": [
        [
          {
            "node": "Split Out Order Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Set Address Fields": {
      "main": [
        [
          {
            "node": "Filter Out PickUpShops",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split Out Order Data": {
      "main": [
        [
          {
            "node": "Set Address Fields",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Filter Out PickUpShops": {
      "main": [
        [
          {
            "node": "check if housenumer is not empty",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Check Address endereco api": {
      "main": [
        [
          {
            "node": "check if new address is not empty",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split Out Corrected Address": {
      "main": [
        [
          {
            "node": "Wait1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "check if housenumer is not empty": {
      "main": [
        [
          {
            "node": "Check Address endereco api",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "check if addressline 2 contains number",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "check if new address is not empty": {
      "main": [
        [
          {
            "node": "Split Out Corrected Address",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "set billbee tag",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "set new delivery address to billbee": {
      "main": [
        [
          {
            "node": "set billbee success",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "check if addressline 2 contains number": {
      "main": [
        [
          {
            "node": "set value of addressline2 as housenumber",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "check if addressline 2 contains number and letter",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "set value of addressline2 as housenumber": {
      "main": [
        [
          {
            "node": "Check Address endereco api",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "check if addressline 2 contains number and letter": {
      "main": [
        [
          {
            "node": "set value of addressline2 as housenumber number+letter",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "set billbee tag manual check",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "set value of addressline2 as housenumber number+letter": {
      "main": [
        [
          {
            "node": "Check Address endereco api",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流?

复制上方的 JSON 配置代码,在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」,粘贴配置后根据需要修改凭证设置即可。

这个工作流适合什么场景?

高级 - 销售

需要付费吗?

本工作流完全免费,您可以直接导入使用。但请注意,工作流中使用的第三方服务(如 OpenAI API)可能需要您自行付费。

工作流信息
难度等级
高级
节点数量31
分类1
节点类型8
难度说明

适合高级用户,包含 16+ 个节点的复杂工作流

作者

I 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 查看

分享此工作流