Shopify 订单数据
高级
这是一个CRM领域的自动化工作流，包含 16 个节点。主要使用 Set, Code, Webhook, Airtable, SplitInBatches 等节点。 自动将 Shopify 订单数据传输到结构化的 Airtable 记录
前置要求
- •HTTP Webhook 端点（n8n 会自动生成）
- •Airtable API Key
分类
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "KDiL56rl4YovAr9v",
"meta": {
"instanceId": "ac3395400729d0f53e6b8e43c425ec1af04a99e154bcd808417b3b72fa9dec1f",
"templateCredsSetupCompleted": true
},
"name": "Shopify 订单数据",
"tags": [],
"nodes": [
{
"id": "78d221dc-8297-4181-8a9e-e97c04fc97c3",
"name": "代码",
"type": "n8n-nodes-base.code",
"position": [
-100,
460
],
"parameters": {
"jsCode": "// 1. Extract and normalize order data\nconst payload = items[0].json;\nconst order = payload.order || payload.body || payload;\nconst lineItems = Array.isArray(order.line_items) ? order.line_items : [];\nconst customer = order.customer || {};\nconst shippingAddress = order.shipping_address || {};\nconst billingAddress = order.billing_address || {};\n\n// 2. Get financial totals (order-level)\nconst subtotal = order.subtotal_price || order.current_subtotal_price_set?.amount || '0.00';\nconst shippingTotal = parseFloat(order.shipping_lines?.[0]?.price || order.current_shipping_price_set?.amount || 0);\nconst taxTotal = parseFloat(order.total_tax || '0.00');\nconst discountsTotal = order.total_discounts || '0.00';\nconst grandTotal = parseFloat(order.total_price || order.current_total_price_set?.amount || '0.00');\nconst currency = order.currency || 'USD';\n\n// 3. Calculate total line item value\nconst totalLineItemValue = lineItems.reduce((sum, item) => {\n return sum + (parseFloat(item.price || 0) * item.quantity);\n}, 0);\n\n// 4. Find only taxable items\nconst taxableItems = lineItems.filter(item => item.tax_lines && item.tax_lines.length > 0);\nconst taxableTotal = taxableItems.reduce((sum, item) => {\n return sum + (parseFloat(item.price || 0) * item.quantity);\n}, 0);\n\n// 5. Clean formatted billing address (in 1 column)\nconst billingFullAddress = [\n billingAddress.name || `${customer.first_name || \"\"} ${customer.last_name || \"\"}`.trim(),\n billingAddress.phone,\n order.email || customer.email,\n billingAddress.address1,\n billingAddress.city,\n billingAddress.province,\n billingAddress.zip,\n billingAddress.country\n].filter(Boolean).join(\", \");\n\n// 6. Build order-level base data\nconst orderBase = {\n \"Order ID\": order.id || \"\",\n \"Order Name\": order.name || \"\",\n \"Order Number\": order.order_number || \"\",\n \"Order Created At\": order.created_at || \"\",\n \"Order Status URL\": order.order_status_url || \"\",\n \"Financial Status\": order.financial_status || \"\",\n \"Payment Gateway\": order.gateway || \"\",\n \"Currency\": currency,\n \"Subtotal\": subtotal,\n \"Grand Total\": grandTotal.toFixed(2),\n \"Total Tax\": taxTotal.toFixed(2),\n \"Shipping Total\": shippingTotal.toFixed(2),\n \"Discount Total\": discountsTotal,\n\n \"Customer Email\": order.email || customer.email || \"\",\n \"Customer Name\": `${customer.first_name || \"\"} ${customer.last_name || \"\"}`.trim(),\n \"Customer Phone\": customer.phone || \"\",\n \"Shipping City\": shippingAddress.city || \"\",\n \"Shipping Country\": shippingAddress.country || \"\",\n \"Shipping Phone\": shippingAddress.phone || \"\",\n \"Billing Address\": billingFullAddress\n};\n\n// 7. Final output: one row per variant\nconst output = lineItems.map(item => {\n const lineTotal = parseFloat(item.price || 0) * item.quantity;\n const orderWeight = totalLineItemValue > 0 ? lineTotal / totalLineItemValue : 0;\n\n const isTaxable = item.tax_lines && item.tax_lines.length > 0;\n const taxWeight = isTaxable && taxableTotal > 0 ? lineTotal / taxableTotal : 0;\n\n const [color = \"\", size = \"\", material = \"\"] = (item.variant_title || \"\").split(\" / \").concat([\"\", \"\", \"\"]).slice(0, 3);\n\n return {\n json: {\n ...orderBase,\n\n // Product Info\n \"Product Name\": item.title || \"\",\n \"Variant Title\": item.variant_title || \"\",\n \"Color\": color,\n \"Size\": size,\n \"Material\": material,\n \"Quantity\": item.quantity || 0,\n \"Unit Price\": parseFloat(item.price || 0).toFixed(2),\n \"Line Total\": lineTotal.toFixed(2),\n \"Product ID\": item.product_id || \"\",\n \"Variant ID\": item.variant_id || \"\",\n \"SKU\": item.sku || \"\",\n \"Vendor\": item.vendor || \"\",\n \"Requires Shipping\": item.requires_shipping ? \"Yes\" : \"No\",\n \"Confirmation Number\": order.confirmation_number || \"\",\n \"Admin GraphQL API ID\": item.admin_graphql_api_id || \"\",\n\n // Allocated values\n \"Allocated Tax\": (taxTotal * taxWeight).toFixed(2),\n \"Allocated Shipping\": (shippingTotal * orderWeight).toFixed(2),\n \"Item % of Order\": (orderWeight * 100).toFixed(2) + \"%\",\n\n // Clarity\n \"Is Taxable\": isTaxable ? \"Yes\" : \"No\"\n }\n };\n});\n\nreturn output;"
},
"typeVersion": 2
},
{
"id": "b5ccebd2-e080-4e7f-a7d0-48dac47ffeff",
"name": "创建订单",
"type": "n8n-nodes-base.webhook",
"position": [
-740,
460
],
"webhookId": "b9ff3875-9fc3-4eb6-89cf-f2e4ccabdd53",
"parameters": {
"path": "createorder",
"options": {},
"httpMethod": "POST"
},
"typeVersion": 2
},
{
"id": "73e33596-7fe5-4573-8081-5e4557b7a332",
"name": "遍历项目",
"type": "n8n-nodes-base.splitInBatches",
"position": [
380,
460
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "74f0ef0a-06da-4ce1-83ee-718b22327bdd",
"name": "表格",
"type": "n8n-nodes-base.set",
"position": [
720,
700
],
"parameters": {
"options": {
"dotNotation": true
},
"assignments": {
"assignments": [
{
"id": "71623f2e-aa21-49e1-a785-ccfc9614f423",
"name": "=S No",
"type": "string",
"value": ""
},
{
"id": "2613143d-766c-4b4f-9aa0-a7fb37d69057",
"name": "Order ID",
"type": "string",
"value": "={{ $json[\"Order ID\"] }}"
},
{
"id": "960b7c7f-646d-499a-ae5f-bfc4ca6acfee",
"name": "Order Number",
"type": "string",
"value": "={{ $json[\"Order Number\"] }}"
},
{
"id": "4458ae90-f35a-4928-ba87-ea48c869a801",
"name": "Order Created At",
"type": "string",
"value": "={{ $json[\"Order Created At\"] }}"
},
{
"id": "c0bc05e5-c450-4732-bba5-1692322e0a34",
"name": "Order Status URL",
"type": "string",
"value": "={{ $json[\"Order Status URL\"] }}"
},
{
"id": "5777e1fa-034a-479a-985b-de9b9c48cefa",
"name": "Customer Name",
"type": "string",
"value": "={{ $json[\"Customer Name\"] }}"
},
{
"id": "c0ff0664-045e-4468-b5be-3135fc7ee246",
"name": "Customer Email",
"type": "string",
"value": "={{ $json[\"Customer Email\"] }}"
},
{
"id": "cfc0d46c-6f00-4ac3-9c84-6ad6ae872d18",
"name": "Customer Phone",
"type": "string",
"value": "={{ $json[\"Customer Phone\"] }}"
},
{
"id": "22e96322-bd4e-444a-9dca-1e9c6a95d08f",
"name": "Product Name",
"type": "string",
"value": "={{ $json[\"Product Name\"] }}"
},
{
"id": "106f0cf6-e82f-40c3-b86e-6e114541752f",
"name": "Variant Title",
"type": "string",
"value": "={{ $json[\"Variant Title\"] }}"
},
{
"id": "aa960a31-51bd-49a4-9d46-b806b11ec66c",
"name": "Color",
"type": "string",
"value": "={{ $json.Color }}"
},
{
"id": "3d5161e8-7cf6-45df-a3ef-31111ebb951a",
"name": "Size",
"type": "string",
"value": "={{ $json.Size }}"
},
{
"id": "8518647c-6c7e-464b-8a52-532a1cb3814d",
"name": "Material",
"type": "string",
"value": "={{ $json.Material }}"
},
{
"id": "ae901273-2c28-46ec-96fe-97a5c52163df",
"name": "SKU",
"type": "string",
"value": "={{ $json.SKU }}"
},
{
"id": "5af804c1-c135-4dac-9bbf-2e6796d31332",
"name": "Quantity",
"type": "string",
"value": "={{ $json.Quantity }}"
},
{
"id": "f8d4d4a9-eb7b-4fb2-9a12-5edf5560cae6",
"name": "Unit Price",
"type": "string",
"value": "={{ $json[\"Unit Price\"] }}"
},
{
"id": "b5a568a2-2f7b-4867-b025-5103777a5e5f",
"name": "Line Total (Price * Quantity)",
"type": "string",
"value": "={{ $json[\"Line Total\"] }}"
},
{
"id": "9d1670c8-f646-4c5a-92bb-8aa145dbc99c",
"name": "Product ID",
"type": "string",
"value": "={{ $json[\"Product ID\"] }}"
},
{
"id": "1f93d125-b9d2-4efe-b150-19bd8be7d52c",
"name": "Variant ID",
"type": "string",
"value": "={{ $json[\"Variant ID\"] }}"
},
{
"id": "b5cde5e9-7cc0-46e9-965b-fa41d1d65cfb",
"name": "Line Tax",
"type": "string",
"value": "={{ $json[\"Allocated Tax\"] }}"
},
{
"id": "f0e02ce7-4220-4f00-8d01-c39b288d5db6",
"name": "Line Shipping Charges",
"type": "string",
"value": "={{ $json[\"Allocated Shipping\"] }}"
},
{
"id": "8814ea80-03ad-4854-b087-e388d875efc9",
"name": "Vendor",
"type": "string",
"value": "={{ $json.Vendor }}"
},
{
"id": "0047cbce-5ec5-4ded-a9cb-9a6053cfa119",
"name": "Requires Shipping",
"type": "string",
"value": "={{ $json[\"Requires Shipping\"] }}"
},
{
"id": "5d15ab9b-64f7-48b1-a12e-ff3972d691cf",
"name": "Billing Address",
"type": "string",
"value": "={{ $json[\"Billing Address\"] }}"
},
{
"id": "a2cdeef2-683b-4cb7-88df-5c0590ec5d2f",
"name": "Shipping City",
"type": "string",
"value": "={{ $json[\"Shipping City\"] }}"
},
{
"id": "3dca84bb-5f9f-4729-b74c-b8cb4adcf9b7",
"name": "Shipping Country",
"type": "string",
"value": "={{ $json[\"Shipping Country\"] }}"
},
{
"id": "92c12a61-31db-4510-98af-5b8bd61551cd",
"name": "Order Name",
"type": "string",
"value": "={{ $json[\"Order Name\"] }}"
},
{
"id": "a874d9fa-60d8-4486-940e-878e6a49d98a",
"name": "Financial Status",
"type": "string",
"value": "={{ $json[\"Financial Status\"] }}"
},
{
"id": "64f6c2e9-c64e-4e7c-abef-538757f145c9",
"name": "Payment Gateway",
"type": "string",
"value": "={{ $json[\"Payment Gateway\"] }}"
},
{
"id": "79ee1385-1915-4e1e-b148-22c125840c92",
"name": "Currency",
"type": "string",
"value": "={{ $json.Currency }}"
},
{
"id": "0101c2fc-5b21-4551-b12f-795c000d6bbf",
"name": "Order Products Total / Subtotal",
"type": "string",
"value": "={{ $json.Subtotal }}"
},
{
"id": "49f76039-ffec-4009-9c04-07cefe562fe6",
"name": "Order Overall Total Tax",
"type": "string",
"value": "={{ $json[\"Total Tax\"] }}"
},
{
"id": "f54aec9e-065f-407b-a2db-0df8d73bfc86",
"name": "Discount Total",
"type": "string",
"value": "={{ $json[\"Discount Total\"] }}"
},
{
"id": "5321b2ee-a609-4c52-8bdc-8ec71fe32432",
"name": "Order Shipping Overall Total",
"type": "string",
"value": "={{ $json[\"Shipping Total\"] }}"
},
{
"id": "48ee43ec-bfcf-4117-86a4-37d0114ce481",
"name": "Grand Total",
"type": "string",
"value": "={{ $json[\"Grand Total\"] }}"
},
{
"id": "7a7cc264-c854-4d25-bd47-54e0d15c3e48",
"name": "Customer Order Confirmation Code",
"type": "string",
"value": "={{ $json[\"Confirmation Number\"] }}"
},
{
"id": "f851c5a7-c057-408f-b390-ff4bc69a172f",
"name": "Item % of Order",
"type": "string",
"value": "={{ $json[\"Item % of Order\"] }}"
},
{
"id": "1d2e65c7-a370-4bdb-917f-5973ace42c4e",
"name": "Is Taxable",
"type": "string",
"value": "={{ $json[\"Is Taxable\"] }}"
},
{
"id": "1f0025c2-080f-4baf-8ec6-5e4bb28b4692",
"name": "Shipping Phone",
"type": "string",
"value": "={{ $json[\"Shipping Phone\"] }}"
},
{
"id": "43527d4b-b115-4b12-b611-6838ee39aa3c",
"name": "Admin GraphQL API ID",
"type": "string",
"value": "={{ $json[\"Admin GraphQL API ID\"] }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "da068325-94a1-47ab-a538-b4411bc187d1",
"name": "订单表格",
"type": "n8n-nodes-base.airtable",
"position": [
1080,
700
],
"parameters": {
"base": {
"__rl": true,
"mode": "list",
"value": "appgGEef4Mw8vFS78",
"cachedResultUrl": "https://airtable.com/appgGEef4Mw8vFS78",
"cachedResultName": "IPM"
},
"sort": {
"property": [
{
"field": "S No"
}
]
},
"table": {
"__rl": true,
"mode": "list",
"value": "tbl2B5IiIhRwkVz1I",
"cachedResultUrl": "https://airtable.com/appgGEef4Mw8vFS78/tbl2B5IiIhRwkVz1I",
"cachedResultName": "Order Sheet"
},
"options": {},
"operation": "search",
"filterByFormula": "1"
},
"credentials": {
"airtableTokenApi": {
"id": "nnFmmaqX4RQPC4tx",
"name": "Airtable Personal Access Token account"
}
},
"typeVersion": 2.1
},
{
"id": "f8482c76-a80d-46db-b2e5-4bb89e03f536",
"name": "代码23",
"type": "n8n-nodes-base.code",
"position": [
1640,
700
],
"parameters": {
"jsCode": "const rows = $input.all();\nconst lastRow = rows[rows.length - 1];\nreturn [lastRow];\n"
},
"typeVersion": 2
},
{
"id": "5ee6a75d-b528-4c5f-bbe7-bc3a11400e9f",
"name": "编辑字段",
"type": "n8n-nodes-base.set",
"position": [
2020,
700
],
"parameters": {
"options": {
"dotNotation": true
},
"assignments": {
"assignments": [
{
"id": "46465961-4bb9-4f27-96d6-efdd83d4e538",
"name": "S No",
"type": "string",
"value": "={{ $json['S No'] }}"
},
{
"id": "0a13fe64-d786-4a9e-bfdb-8f0082a20c5c",
"name": "Order ID",
"type": "string",
"value": "={{ $('Sheet ').item.json['Order ID'] }}"
},
{
"id": "dadbf9cc-c15e-4c9b-8945-584f896e1e64",
"name": "Order Name",
"type": "string",
"value": "={{ $('Sheet ').item.json['Order Name'] }}"
},
{
"id": "6fd1f97c-3adb-4aa5-af83-7a3a07d7d3c9",
"name": "Order Number",
"type": "string",
"value": "={{ $('Sheet ').item.json['Order Number'] }}"
},
{
"id": "88537f3a-1f27-4da7-8afe-6b6fcbba0f1c",
"name": "Order Created At",
"type": "string",
"value": "={{ $('Sheet ').item.json['Order Created At'] }}"
},
{
"id": "08999973-b970-4e0f-872b-38927ac47058",
"name": "Order Status URL",
"type": "string",
"value": "={{ $('Sheet ').item.json['Order Status URL'] }}"
},
{
"id": "c31fb846-515d-4cb0-a307-421bece04857",
"name": "Customer Name",
"type": "string",
"value": "={{ $('Sheet ').item.json['Customer Name'] }}"
},
{
"id": "e29f43ae-b0d7-441c-9d5b-85f719b3cc0d",
"name": "Customer Email",
"type": "string",
"value": "={{ $('Sheet ').item.json['Customer Email'] }}"
},
{
"id": "3e9dda78-7d7a-4436-9bf6-bb0d11bf65ba",
"name": "Customer Phone Number",
"type": "string",
"value": "={{ $('Sheet ').item.json['Customer Phone'] }}"
},
{
"id": "8ff30025-c234-4e93-b50c-293cbf6b071a",
"name": "Product Name",
"type": "string",
"value": "={{ $('Sheet ').item.json['Product Name'] }}"
},
{
"id": "074ed98d-f025-47c8-9ad7-85538d9f7bad",
"name": "Variant Title",
"type": "string",
"value": "={{ $('Sheet ').item.json['Variant Title'] }}"
},
{
"id": "2c348d20-7f17-41fd-b6eb-6b56577fc84c",
"name": "Color",
"type": "string",
"value": "={{ $('Sheet ').item.json.Color }}"
},
{
"id": "38bbca83-b643-40e5-a89a-5858471f53ea",
"name": "Size",
"type": "string",
"value": "={{ $('Sheet ').item.json.Size }}"
},
{
"id": "68e618e6-bd25-40a3-afb3-ee43af127198",
"name": "Material",
"type": "string",
"value": "={{ $('Sheet ').item.json.Material }}"
},
{
"id": "135ce05c-77b5-494c-a315-83e70ee688a6",
"name": "SKU",
"type": "string",
"value": "={{ $('Sheet ').item.json.SKU }}"
},
{
"id": "11fc378a-5bd4-4166-b582-49af87c697ea",
"name": "Quantity",
"type": "string",
"value": "={{ $('Sheet ').item.json.Quantity }}"
},
{
"id": "7c26836e-d4f5-4d08-b85a-0bd633755fb5",
"name": "Unit Price",
"type": "string",
"value": "={{ $('Sheet ').item.json['Unit Price'] }}"
},
{
"id": "b0124180-e50d-4a95-a7d2-2a73d8a0784f",
"name": "Line Total (Price * Quantity)",
"type": "string",
"value": "={{ $('Sheet ').item.json['Line Total (Price * Quantity)'] }}"
},
{
"id": "33aba9e1-1d21-4839-b14e-f573f3f5e0c4",
"name": "Product ID",
"type": "string",
"value": "={{ $('Sheet ').item.json['Product ID'] }}"
},
{
"id": "e2adf5ee-d54e-4d20-b270-eb1cc8045675",
"name": "Variant ID",
"type": "string",
"value": "={{ $('Sheet ').item.json['Variant ID'] }}"
},
{
"id": "728a3455-b8b1-4761-86ff-95653e091d9e",
"name": "Line Tax",
"type": "string",
"value": "={{ $('Sheet ').item.json['Line Tax'] }}"
},
{
"id": "c4e3ef93-4040-426f-9767-6222ae244028",
"name": "Line Shipping Charges",
"type": "string",
"value": "={{ $('Sheet ').item.json['Line Shipping Charges'] }}"
},
{
"id": "19e9426a-ca95-4809-b9b8-94b224b07483",
"name": "Vendor",
"type": "string",
"value": "={{ $('Sheet ').item.json.Vendor }}"
},
{
"id": "ac8b1ff8-922e-4020-8e95-7f9e66e5b3d3",
"name": "Requires Shipping",
"type": "string",
"value": "={{ $('Sheet ').item.json['Requires Shipping'] }}"
},
{
"id": "8c7bbdcf-b309-41c8-a489-b230248edb9d",
"name": "Billing Address",
"type": "string",
"value": "={{ $('Sheet ').item.json['Billing Address'] }}"
},
{
"id": "004e21f2-d57e-4dff-af8c-1030e363be5d",
"name": "Shipping City",
"type": "string",
"value": "={{ $('Sheet ').item.json['Shipping City'] }}"
},
{
"id": "4c3d679f-620a-4a4f-8478-b8c516390a5a",
"name": "Shipping Country",
"type": "string",
"value": "={{ $('Sheet ').item.json['Shipping Country'] }}"
},
{
"id": "05356209-5c49-493c-9b5c-0428aeced748",
"name": "Financial Status",
"type": "string",
"value": "={{ $('Sheet ').item.json['Financial Status'] }}"
},
{
"id": "1b96ccd2-ef51-4212-8ff2-e600222853eb",
"name": "Payment Gateway",
"type": "string",
"value": "={{ $('Sheet ').item.json['Payment Gateway'] }}"
},
{
"id": "6f96316d-2061-42aa-a54b-d21a97d8870b",
"name": "Currency",
"type": "string",
"value": "={{ $('Sheet ').item.json.Currency }}"
},
{
"id": "7a60d041-aff9-49d3-8698-318c24df6c13",
"name": "Order Products Total / Subtotal",
"type": "string",
"value": "={{ $('Sheet ').item.json['Order Products Total / Subtotal'] }}"
},
{
"id": "c85083a4-25bb-44da-a9f7-63b117726a34",
"name": "Order Overall Total Tax",
"type": "string",
"value": "={{ $('Sheet ').item.json['Order Overall Total Tax'] }}"
},
{
"id": "eefdb7e4-d772-4adc-b7af-ada9013fd516",
"name": "Discount Total",
"type": "string",
"value": "={{ $('Sheet ').item.json['Discount Total'] }}"
},
{
"id": "e020e52f-a88a-40de-b2f3-81c05853d5fb",
"name": "Order Shipping Overall Total",
"type": "string",
"value": "={{ $('Sheet ').item.json['Order Shipping Overall Total'] }}"
},
{
"id": "c3810749-f07f-49d4-8355-5730e5d20477",
"name": "Grand Total",
"type": "string",
"value": "={{ $('Sheet ').item.json['Grand Total'] }}"
},
{
"id": "e3ff915f-2b1b-4083-b4fb-dbfb95a93e89",
"name": "Customer Order Confirmation Code",
"type": "string",
"value": "={{ $('Sheet ').item.json['Customer Order Confirmation Code'] }}"
},
{
"id": "1b7a0224-45da-46cc-b217-5fe25a8815f7",
"name": "Item % of Order",
"type": "string",
"value": "={{ $('Sheet ').item.json['Item % of Order'] }}"
},
{
"id": "836c87f4-5030-4c5f-b02b-e3bd7f5a3b8e",
"name": "Is Taxable",
"type": "string",
"value": "={{ $('Sheet ').item.json['Is Taxable'] }}"
},
{
"id": "87367482-cb39-4509-9976-99c7d3b86e60",
"name": "Shipping Phone",
"type": "string",
"value": "={{ $('Sheet ').item.json['Shipping Phone'] }}"
},
{
"id": "d7d8ecf1-8415-4204-bb9d-b74a89b782ff",
"name": "Admin GraphQL API ID",
"type": "string",
"value": "={{ $('Sheet ').item.json['Admin GraphQL API ID'] }}"
},
{
"id": "b425ae49-ffbf-45f0-8ff2-648875b2feba",
"name": "Order Status ",
"type": "string",
"value": "Pending "
}
]
}
},
"typeVersion": 3.4
},
{
"id": "053766a1-beb4-4eab-972f-7bdcfdcc562d",
"name": "生成序列号1",
"type": "n8n-nodes-base.code",
"position": [
2540,
700
],
"parameters": {
"jsCode": "// Corrected Shopify Order Data Processor with Auto-Increment\n// Input: Receives data from previous node containing row_number and S No\n// Output: Increments both IDs while preserving all other data\n\n// 1. Get the input data from previous node\nconst inputData = items[0].json;\n\n// 2. Extract current row number and S No (handling string or number types)\nconst currentRowNumber = parseInt(inputData.row_number) || 0;\nconst currentSNo = parseInt(inputData[\"S No\"]) || 0;\n\n// 3. Increment both values\nconst newRowNumber = currentRowNumber + 1;\nconst newSNo = currentSNo + 1;\n\n// 4. Create new data object with incremented values\nconst outputData = {\n ...inputData, // Preserve all existing data\n \n // Update the incrementing fields (maintaining original field names)\n row_number: newRowNumber.toString(), // Keep as string if original was string\n \"S No\": newSNo.toString(), // Keep field name with space\n \n // Add processing metadata (optional)\n _processed: {\n previous_row: currentRowNumber,\n previous_sno: currentSNo,\n processed_at: new Date().toISOString()\n }\n};\n\n// 5. Return the updated data\nreturn [{\n json: outputData\n}];"
},
"typeVersion": 2
},
{
"id": "6d6b3cff-7abd-4f9b-9aa6-be9ebd32d6a6",
"name": "客户表格",
"type": "n8n-nodes-base.airtable",
"position": [
3320,
700
],
"parameters": {
"base": {
"__rl": true,
"mode": "list",
"value": "appgGEef4Mw8vFS78",
"cachedResultUrl": "https://airtable.com/appgGEef4Mw8vFS78",
"cachedResultName": "IPM"
},
"table": {
"__rl": true,
"mode": "list",
"value": "tbl2B5IiIhRwkVz1I",
"cachedResultUrl": "https://airtable.com/appgGEef4Mw8vFS78/tbl2B5IiIhRwkVz1I",
"cachedResultName": "Order Sheet"
},
"columns": {
"value": {
"SKU": "={{ $json.SKU }}",
"S No": "={{ $json['S No'] }}",
"Size": "={{ $json.Size }}",
"Color": "={{ $json.Color }}",
"Vendor": "={{ $json.Vendor }}",
"Currency": "={{ $json.Currency }}",
"Line Tax": "={{ $json['Line Tax'] }}",
"Material": "={{ $json.Material }}",
"Order ID": "={{ $json['Order ID'] }}",
"Quantity": "={{ $json.Quantity }}",
"Is Taxable": "={{ $json[\"Is Taxable\"] }}",
"Product ID": "={{ $json['Product ID'] }}",
"Unit Price": "={{ $json['Unit Price'] }}",
"Variant ID": "={{ $json['Variant ID'] }}",
"Grand Total": "={{ $json[\"Grand Total\"] }}",
"Order Number": "={{ $json['Order Number'] }}",
"Order Status": "={{ $json[\"Order Status \"] }}",
"Product Name": "={{ $json['Product Name'] }}",
"Customer Name": "={{ $json['Customer Name'] }}",
"Shipping City": "={{ $json[\"Shipping City\"] }}",
"Variant Title": "={{ $json['Variant Title'] }}",
"Customer Email": "={{ $json['Customer Email'] }}",
"Customer Phone": "={{ $json['Customer Phone Number'] }}",
"Discount Total": "={{ $json[\"Discount Total\"] }}",
"Shipping Phone": "={{ $json[\"Shipping Phone\"] }}",
"Billing Address": "={{ $json[\"Billing Address\"] }}",
"Item % of Order": "={{ $json[\"Item % of Order\"] }}",
"Payment Gateway": "={{ $json[\"Payment Gateway\"] }}",
"Financial Status": "={{ $json[\"Financial Status\"] }}",
"Order Created At": "={{ $json['Order Created At'] }}",
"Order Status URL": "={{ $json[\"Order Status URL\"] }}",
"Requires Shipping": "={{ $json['Requires Shipping'] }}",
"Admin GraphQL API ID": "={{ $json[\"Admin GraphQL API ID\"] }}",
"Line Shipping Charges": "={{ $json['Line Shipping Charges'] }}",
"Order Overall Total Tax": "={{ $json[\"Order Overall Total Tax\"] }}",
"Order Shipping Overall Total": "={{ $json[\"Order Shipping Overall Total\"] }}",
"Line Total (Price * Quantity)": "={{ $json['Line Total (Price * Quantity)'] }}",
"Order Products Total / Subtotal": "={{ $json[\"Order Products Total / Subtotal\"] }}",
"Customer Order Confirmation Code": "={{ $json[\"Customer Order Confirmation Code\"] }}"
},
"schema": [
{
"id": "id",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "id",
"defaultMatch": true
},
{
"id": "S No",
"type": "number",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "S No",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Order ID",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Order ID",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Order Number",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Order Number",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Order Created At",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Order Created At",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Customer Name",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Customer Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Customer Phone",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Customer Phone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Customer Email",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Customer Email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Product Name",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Product Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Variant Title",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Variant Title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Color",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Color",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Size",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Size",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Material",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Material",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "SKU",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "SKU",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Quantity",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Quantity",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Unit Price",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Unit Price",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Line Total (Price * Quantity)",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Line Total (Price * Quantity)",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Product ID",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Product ID",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Variant ID",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Variant ID",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Line Tax",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Line Tax",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Line Shipping Charges",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Line Shipping Charges",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Vendor",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Vendor",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Requires Shipping",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Requires Shipping",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Shipping City",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Shipping City",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Order Status",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Order Status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Billing Address",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Billing Address",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Order Status URL",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Order Status URL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Financial Status",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Financial Status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Payment Gateway",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Payment Gateway",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Currency",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Currency",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Order Products Total / Subtotal",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Order Products Total / Subtotal",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Order Overall Total Tax",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Order Overall Total Tax",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Is Taxable",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Is Taxable",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Discount Total",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Discount Total",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Order Shipping Overall Total",
"type": "number",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Order Shipping Overall Total",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Grand Total",
"type": "number",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Grand Total",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Customer Order Confirmation Code",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Customer Order Confirmation Code",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Item % of Order",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Item % of Order",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Shipping Phone",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Shipping Phone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Admin GraphQL API ID",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Admin GraphQL API ID",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Record ID",
"type": "string",
"display": true,
"removed": false,
"readOnly": true,
"required": false,
"displayName": "Record ID",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Order ID"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "upsert"
},
"credentials": {
"airtableTokenApi": {
"id": "nnFmmaqX4RQPC4tx",
"name": "Airtable Personal Access Token account"
}
},
"typeVersion": 2.1
},
{
"id": "e296f347-80d9-4e94-8e47-08c94b373575",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-840,
340
],
"parameters": {
"width": 340,
"height": 320,
"content": "## 当客户创建订单时触发的 Webhook 触发器"
},
"typeVersion": 1
},
{
"id": "5b3893ab-74b9-4a3d-b3f4-a92e7ca948ff",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-300,
-720
],
"parameters": {
"color": 4,
"width": 480,
"height": 1360,
"content": "## 代码提取订单信息"
},
"typeVersion": 1
},
{
"id": "4620fdcd-3a69-4040-9c3e-74c4a0994ce9",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
960,
360
],
"parameters": {
"color": 5,
"width": 320,
"height": 500,
"content": "# Airtable 客户表格"
},
"typeVersion": 1
},
{
"id": "0607336c-5d55-4329-85ad-6e53050691e8",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
1460,
200
],
"parameters": {
"color": 4,
"width": 460,
"height": 660,
"content": "## 仅返回最后一行"
},
"typeVersion": 1
},
{
"id": "f3e14e2b-1900-4af0-b597-e952ef802798",
"name": "### 需要帮助？",
"type": "n8n-nodes-base.stickyNote",
"position": [
2340,
120
],
"parameters": {
"color": 4,
"width": 540,
"height": 800,
"content": "# 从前一个节点自动递增 \"S No\""
},
"typeVersion": 1
},
{
"id": "5d934d8e-573d-44ef-aace-b968bde029f6",
"name": "## 试试看！",
"type": "n8n-nodes-base.stickyNote",
"position": [
3120,
400
],
"parameters": {
"color": 5,
"width": 460,
"height": 500,
"content": "# Airtable 表格"
},
"typeVersion": 1
},
{
"id": "671effcd-0f28-4eff-a49a-78779a712db7",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2420,
-720
],
"parameters": {
"color": 3,
"width": 1120,
"height": 2920,
"content": "## 此自动化流程构建于 n8n（一个无代码/低代码自动化平台）。每当客户在您的 Shopify 商店下单时，它会自动将订单数据更新到系统中。"
},
"typeVersion": 1
}
],
"active": false,
"pinData": {
"create order": [
{
"json": {
"body": {
"id": 820982911946154500,
"name": "#9999",
"note": null,
"tags": "tag1, tag2",
"test": true,
"email": "jon@example.com",
"phone": null,
"token": "123456abcd",
"app_id": null,
"number": 234,
"refunds": [],
"returns": [],
"user_id": null,
"currency": "INR",
"customer": {
"id": 115310627314723950,
"note": null,
"email": "john@example.com",
"phone": null,
"state": "disabled",
"currency": "INR",
"last_name": "Smith",
"created_at": null,
"first_name": "John",
"tax_exempt": false,
"updated_at": null,
"tax_exemptions": [],
"verified_email": true,
"default_address": {
"id": 715243470612851200,
"zip": "K2H7A8",
"city": "Ottawa",
"name": "John Smith",
"phone": "123-123-1234",
"company": null,
"country": "Canada",
"default": true,
"address1": "123 Elm St.",
"address2": null,
"province": "Ontario",
"last_name": "Smith",
"first_name": "John",
"customer_id": 115310627314723950,
"country_code": "CA",
"country_name": "Canada",
"province_code": "ON"
},
"admin_graphql_api_id": "gid://shopify/Customer/115310627314723954",
"multipass_identifier": null
},
"closed_at": null,
"confirmed": false,
"device_id": null,
"po_number": null,
"reference": null,
"tax_lines": [],
"total_tax": "0.00",
"browser_ip": null,
"cart_token": null,
"created_at": "2025-06-24T18:40:12+05:30",
"line_items": [
{
"id": 866550311766439000,
"sku": "",
"name": "Unisex Brushed‑Fleece Hoodie",
"grams": 0,
"price": "859.00",
"title": "Unisex Brushed‑Fleece Hoodie",
"duties": [],
"vendor": null,
"taxable": true,
"quantity": 1,
"gift_card": false,
"price_set": {
"shop_money": {
"amount": "859.00",
"currency_code": "INR"
},
"presentment_money": {
"amount": "859.00",
"currency_code": "INR"
}
},
"tax_lines": [],
"product_id": 9784057299230,
"properties": [],
"variant_id": 49871285190942,
"variant_title": null,
"product_exists": true,
"total_discount": "0.00",
"current_quantity": 1,
"attributed_staffs": [
{
"id": "gid://shopify/StaffMember/902541635",
"quantity": 1
}
],
"requires_shipping": true,
"fulfillment_status": null,
"total_discount_set": {
"shop_money": {
"amount": "0.00",
"currency_code": "INR"
},
"presentment_money": {
"amount": "0.00",
"currency_code": "INR"
}
},
"fulfillment_service": "manual",
"admin_graphql_api_id": "gid://shopify/LineItem/866550311766439020",
"discount_allocations": [],
"fulfillable_quantity": 1,
"sales_line_item_group_id": null,
"variant_inventory_management": "shopify"
},
{
"id": 141249953214522980,
"sku": "",
"name": "Eco‑Friendly Organic Cotton T‑Shirt",
"grams": 0,
"price": "450.00",
"title": "Eco‑Friendly Organic Cotton T‑Shirt",
"duties": [],
"vendor": null,
"taxable": true,
"quantity": 1,
"gift_card": false,
"price_set": {
"shop_money": {
"amount": "450.00",
"currency_code": "INR"
},
"presentment_money": {
"amount": "450.00",
"currency_code": "INR"
}
},
"tax_lines": [],
"product_id": 9784059330846,
"properties": [],
"variant_id": 49871297904926,
"variant_title": null,
"product_exists": true,
"total_discount": "0.00",
"current_quantity": 1,
"attributed_staffs": [],
"requires_shipping": true,
"fulfillment_status": null,
"total_discount_set": {
"shop_money": {
"amount": "0.00",
"currency_code": "INR"
},
"presentment_money": {
"amount": "0.00",
"currency_code": "INR"
}
},
"fulfillment_service": "manual",
"admin_graphql_api_id": "gid://shopify/LineItem/141249953214522974",
"discount_allocations": [],
"fulfillable_quantity": 1,
"sales_line_item_group_id": 142831562,
"variant_inventory_management": "shopify"
},
{
"id": 257004973105704600,
"sku": "",
"name": "RibPro Meridian Rib‑Knit Long‑Sleeve Tee",
"grams": 0,
"price": "899.00",
"title": "RibPro Meridian Rib‑Knit Long‑Sleeve Tee",
"duties": [],
"vendor": null,
"taxable": true,
"quantity": 1,
"gift_card": false,
"price_set": {
"shop_money": {
"amount": "899.00",
"currency_code": "INR"
},
"presentment_money": {
"amount": "899.00",
"currency_code": "INR"
}
},
"tax_lines": [],
"product_id": 9784061002014,
"properties": [],
"variant_id": 49871311110430,
"variant_title": null,
"product_exists": true,
"total_discount": "0.00",
"current_quantity": 1,
"attributed_staffs": [],
"requires_shipping": true,
"fulfillment_status": null,
"total_discount_set": {
"shop_money": {
"amount": "0.00",
"currency_code": "INR"
},
"presentment_money": {
"amount": "0.00",
"currency_code": "INR"
}
},
"fulfillment_service": "manual",
"admin_graphql_api_id": "gid://shopify/LineItem/257004973105704598",
"discount_allocations": [],
"fulfillable_quantity": 1,
"sales_line_item_group_id": 142831562,
"variant_inventory_management": "shopify"
}
],
"source_url": null,
"tax_exempt": false,
"updated_at": "2025-06-24T18:40:12+05:30",
"checkout_id": null,
"location_id": null,
"source_name": "web",
"total_price": "2198.00",
"cancelled_at": "2025-06-24T18:40:12+05:30",
"fulfillments": [],
"landing_site": null,
"order_number": 1234,
"processed_at": "2025-06-24T18:40:12+05:30",
"total_weight": 0,
"cancel_reason": "customer",
"contact_email": "jon@example.com",
"payment_terms": null,
"total_tax_set": {
"shop_money": {
"amount": "0.00",
"currency_code": "INR"
},
"presentment_money": {
"amount": "0.00",
"currency_code": "INR"
}
},
"checkout_token": null,
"client_details": null,
"discount_codes": [],
"referring_site": null,
"shipping_lines": [
{
"id": 271878346596884000,
"code": null,
"phone": null,
"price": "10.00",
"title": "Generic Shipping",
"source": "shopify",
"price_set": {
"shop_money": {
"amount": "10.00",
"currency_code": "INR"
},
"presentment_money": {
"amount": "10.00",
"currency_code": "INR"
}
},
"tax_lines": [],
"is_removed": false,
"discounted_price": "0.00",
"carrier_identifier": null,
"discount_allocations": [],
"discounted_price_set": {
"shop_money": {
"amount": "0.00",
"currency_code": "INR"
},
"presentment_money": {
"amount": "0.00",
"currency_code": "INR"
}
},
"current_discounted_price_set": {
"shop_money": {
"amount": "0.00",
"currency_code": "INR"
},
"presentment_money": {
"amount": "0.00",
"currency_code": "INR"
}
},
"requested_fulfillment_service_id": null
}
],
"subtotal_price": "2198.00",
"taxes_included": false,
"billing_address": {
"zip": "40003",
"city": "Shippington",
"name": "Steve Shipper",
"phone": "555-555-SHIP",
"company": "Shipping Company",
"country": "United States",
"address1": "123 Shipping Street",
"address2": null,
"latitude": null,
"province": "Kentucky",
"last_name": "Shipper",
"longitude": null,
"first_name": "Steve",
"country_code": "US",
"province_code": "KY"
},
"customer_locale": "en",
"duties_included": false,
"estimated_taxes": false,
"note_attributes": [],
"total_discounts": "20.00",
"total_price_set": {
"shop_money": {
"amount": "2198.00",
"currency_code": "INR"
},
"presentment_money": {
"amount": "2198.00",
"currency_code": "INR"
}
},
"financial_status": "voided",
"landing_site_ref": null,
"order_status_url": "https://usrnj8-ft.myshopify.com/93796040990/orders/123456abcd/authenticate?key=abcdefg",
"shipping_address": {
"zip": "40003",
"city": "Shippington",
"name": "Steve Shipper",
"phone": "555-555-SHIP",
"company": "Shipping Company",
"country": "United States",
"address1": "123 Shipping Street",
"address2": null,
"latitude": null,
"province": "Kentucky",
"last_name": "Shipper",
"longitude": null,
"first_name": "Steve",
"country_code": "US",
"province_code": "KY"
},
"current_total_tax": "0.00",
"source_identifier": null,
"total_outstanding": "2208.00",
"fulfillment_status": null,
"subtotal_price_set": {
"shop_money": {
"amount": "2198.00",
"currency_code": "INR"
},
"presentment_money": {
"amount": "2198.00",
"currency_code": "INR"
}
},
"total_tip_received": "0.00",
"confirmation_number": null,
"current_total_price": "2208.00",
"total_discounts_set": {
"shop_money": {
"amount": "20.00",
"currency_code": "INR"
},
"presentment_money": {
"amount": "20.00",
"currency_code": "INR"
}
},
"admin_graphql_api_id": "gid://shopify/Order/820982911946154508",
"presentment_currency": "INR",
"current_total_tax_set": {
"shop_money": {
"amount": "0.00",
"currency_code": "INR"
},
"presentment_money": {
"amount": "0.00",
"currency_code": "INR"
}
},
"discount_applications": [],
"payment_gateway_names": [
"visa",
"bogus"
],
"current_subtotal_price": "2208.00",
"total_line_items_price": "2208.00",
"buyer_accepts_marketing": true,
"current_total_discounts": "0.00",
"current_total_price_set": {
"shop_money": {
"amount": "2208.00",
"currency_code": "INR"
},
"presentment_money": {
"amount": "2208.00",
"currency_code": "INR"
}
},
"current_total_duties_set": null,
"total_shipping_price_set": {
"shop_money": {
"amount": "10.00",
"currency_code": "INR"
},
"presentment_money": {
"amount": "10.00",
"currency_code": "INR"
}
},
"merchant_of_record_app_id": null,
"original_total_duties_set": null,
"current_shipping_price_set": {
"shop_money": {
"amount": "0.00",
"currency_code": "INR"
},
"presentment_money": {
"amount": "0.00",
"currency_code": "INR"
}
},
"current_subtotal_price_set": {
"shop_money": {
"amount": "2208.00",
"currency_code": "INR"
},
"presentment_money": {
"amount": "2208.00",
"currency_code": "INR"
}
},
"total_line_items_price_set": {
"shop_money": {
"amount": "2208.00",
"currency_code": "INR"
},
"presentment_money": {
"amount": "2208.00",
"currency_code": "INR"
}
},
"current_total_discounts_set": {
"shop_money": {
"amount": "0.00",
"currency_code": "INR"
},
"presentment_money": {
"amount": "0.00",
"currency_code": "INR"
}
},
"merchant_business_entity_id": "27044839710",
"current_total_additional_fees_set": null,
"original_total_additional_fees_set": null,
"total_cash_rounding_refund_adjustment_set": {
"shop_money": {
"amount": "0.00",
"currency_code": "INR"
},
"presentment_money": {
"amount": "0.00",
"currency_code": "INR"
}
},
"total_cash_rounding_payment_adjustment_set": {
"shop_money": {
"amount": "0.00",
"currency_code": "INR"
},
"presentment_money": {
"amount": "0.00",
"currency_code": "INR"
}
}
},
"query": {},
"params": {},
"headers": {
"host": "ashu7859.app.n8n.cloud",
"accept": "*/*",
"cf-ray": "954c76cd61e71068-ORD",
"cdn-loop": "cloudflare; loops=1; subreqs=1",
"cf-ew-via": "15",
"cf-worker": "n8n.cloud",
"x-real-ip": "34.41.225.136",
"cf-visitor": "{\"scheme\":\"https\"}",
"user-agent": "Shopify-Captain-Hook",
"cf-ipcountry": "US",
"content-type": "application/json",
"x-is-trusted": "yes",
"content-length": "8971",
"x-shopify-test": "true",
"accept-encoding": "gzip, br",
"x-forwarded-for": "34.41.225.136, 172.71.1.138",
"x-shopify-topic": "orders/create",
"cf-connecting-ip": "34.41.225.136",
"x-forwarded-host": "ashu7859.app.n8n.cloud",
"x-forwarded-port": "443",
"x-forwarded-proto": "https",
"x-forwarded-server": "traefik-prod-users-gwc-55-69f456d475-rlss9",
"x-shopify-event-id": "abf3294f-af27-47f3-86ef-3cce8355e61f",
"x-shopify-webhook-id": "d4d27cd8-7671-4484-8cc5-a3a74d433ce6",
"x-shopify-api-version": "2025-04",
"x-shopify-hmac-sha256": "oSUFYglkcz5JlGtDV0lG8mpEufJ4y+X0Nmi/EH52U+k=",
"x-shopify-shop-domain": "usrnj8-ft.myshopify.com",
"x-shopify-triggered-at": "2025-06-24T13:10:12.769523556Z"
},
"webhookUrl": "https://ashu7859.app.n8n.cloud/webhook/createorder",
"executionMode": "production"
}
}
]
},
"settings": {
"executionOrder": "v1"
},
"versionId": "c971738f-6bca-413a-8da6-c122f132dd03",
"connections": {
"Code": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Code23": {
"main": [
[
{
"node": "Edit Fields",
"type": "main",
"index": 0
}
]
]
},
"Sheet ": {
"main": [
[
{
"node": "Order Sheeet",
"type": "main",
"index": 0
}
]
]
},
"Edit Fields": {
"main": [
[
{
"node": "Generating S No1",
"type": "main",
"index": 0
}
]
]
},
"Order Sheeet": {
"main": [
[
{
"node": "Code23",
"type": "main",
"index": 0
}
]
]
},
"create order": {
"main": [
[
{
"node": "Code",
"type": "main",
"index": 0
}
]
]
},
"CustomerSheet": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items": {
"main": [
[],
[
{
"node": "Sheet ",
"type": "main",
"index": 0
}
]
]
},
"Generating S No1": {
"main": [
[
{
"node": "CustomerSheet",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 客户关系管理
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
Shopify 客户数据追加/更新
将 Shopify 客户订单数据同步到 Airtable 并自动更新
If
Set
Code
+4
25 节点Mohammed Abid
客户关系管理
通过AI分析HubSpot和Google Sheets数据预测客户流失
通过AI分析HubSpot和Google Sheets数据预测客户流失
Set
Code
Merge
+17
27 节点PollupAI
客户关系管理
基于动态提示与Airtable的AI数据提取
通过动态提示与Airtable实现AI数据提取
Set
Code
Filter
+11
51 节点Jimleuk
人工智能
自动化潜在客户生成与个性化外联：Apollo、AI和Instantly.ai
自动化潜在客户生成与个性化外联：Apollo、AI和Instantly.ai
If
Set
Code
+15
166 节点Ruben AI
客户培育
使用Airtable、OpenAI和Unipile的自动化LinkedIn潜在客户生成与私信触达
使用Airtable、OpenAI和Unipile的自动化LinkedIn潜在客户生成与私信触达
If
Set
Code
+15
143 节点Ruben AI
客户培育
反馈保存和报告生成
使用Azure OpenAI和Google Sheets分析销售交易结果并生成报告
Set
Code
Email Send
+6
28 节点Rahul Joshi
客户关系管理
