从Google Sheets导入多规格产品到Shopify
高级
这是一个自动化工作流，包含 21 个节点。主要使用 Set, Code, Switch, Graphql, SplitOut 等节点。 从Google Sheets导入多规格产品到Shopify
前置要求
- •Google Sheets API 凭证
分类
-
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"meta": {
"instanceId": "b6be3264d10563f53f60f119665bef14019561878be2f73c07ebd4200e9255cf",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "ba37e8c9-0372-443a-92cc-55d7893547cc",
"name": "当点击\"执行工作流\"时",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-720,
320
],
"parameters": {},
"typeVersion": 1
},
{
"id": "454305c0-5593-4340-9224-dee5c937acdb",
"name": "获取表格中的行",
"type": "n8n-nodes-base.googleSheets",
"position": [
0,
320
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "list",
"value": 2048403983,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1y7HlsC35Rn_fRtJ7GvJ38F0Aw9sycJ4New80lTOR0hc/edit#gid=2048403983",
"cachedResultName": "Products"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1y7HlsC35Rn_fRtJ7GvJ38F0Aw9sycJ4New80lTOR0hc",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1y7HlsC35Rn_fRtJ7GvJ38F0Aw9sycJ4New80lTOR0hc/edit?usp=drivesdk",
"cachedResultName": "Shopify Store Details"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "nOpKwVGZRUlHqyd8",
"name": "Google Sheets account"
}
},
"typeVersion": 4.7
},
{
"id": "b6b0846a-1b94-438b-b518-7ed51b3bdc6a",
"name": "Shopify，获取位置",
"type": "n8n-nodes-base.graphql",
"position": [
-240,
320
],
"parameters": {
"query": "query {\n locations(first:1, reverse:true) {\n edges {\n node {\n id\n name\n address {\n address1\n address2\n city\n country\n zip\n province\n }\n }\n }\n }\n}",
"endpoint": "={{ $('set shop url').item.json.myshop }}",
"authentication": "headerAuth"
},
"credentials": {
"httpHeaderAuth": {
"id": "90WivU6wv8VrB8sn",
"name": "Header Auth account shopify"
}
},
"executeOnce": true,
"typeVersion": 1.1
},
{
"id": "b7a3b2c1-0f79-4233-8731-1d5631dccd93",
"name": "Shopify，创建产品",
"type": "n8n-nodes-base.graphql",
"position": [
784,
64
],
"parameters": {
"query": "=mutation productCreate($product: ProductCreateInput!, $media: [CreateMediaInput!]) {\n productCreate(product: $product, media: $media) {\n product {\n id\n title\n handle\n options {\n id\n name\n position\n optionValues {\n id\n name\n }\n }\n variants(first:10) {\n edges {\n node {\n id\n sku\n displayName\n inventoryItem {\n id\n sku\n tracked\n requiresShipping\n }\n }\n }\n }\nmedia(first: 10) {\n edges {\n node {\n alt\n mediaContentType\n status\n id\n preview {\n image {\n url\n }\n status\n }\n }\n }\n }\n }\n userErrors {\n field\n message\n }\n }\n}",
"endpoint": "={{ $('set shop url').first().json.myshop }}",
"variables": "={\n \"product\": {\n \"title\": \"{{ $json.productName }}\",\n \"vendor\": \"vendor.\",\n \"productType\": \"type\",\n \"status\": \"ACTIVE\",\n \"handle\": \"{{ $json.productName.toLowerCase().replaceAll(' ', '-') }}\",\n \"productOptions\": \n{{JSON.stringify($json.optionsGraph) }}\n },\n \"media\": [\n {\n \"alt\": \"{{ $json.productName }}\",\n \"mediaContentType\": \"IMAGE\",\n \"originalSource\": \"{{ $json.productImage }}\"\n }\n ]\n}",
"authentication": "headerAuth"
},
"credentials": {
"httpHeaderAuth": {
"id": "90WivU6wv8VrB8sn",
"name": "Header Auth account shopify"
}
},
"typeVersion": 1.1
},
{
"id": "a1171896-5b8f-4bb8-8d8f-bfc208d86f0b",
"name": "拆分输出1",
"type": "n8n-nodes-base.splitOut",
"position": [
1280,
64
],
"parameters": {
"include": "selectedOtherFields",
"options": {},
"fieldToSplitOut": "variants",
"fieldsToInclude": "productId, productTitle, mainfirstVariant, mediaID"
},
"typeVersion": 1
},
{
"id": "4a93dc5f-19a4-4c14-b48f-0de54e24f226",
"name": "设置变体",
"type": "n8n-nodes-base.graphql",
"position": [
1504,
64
],
"parameters": {
"query": "mutation ProductVariantsCreate($productId: ID!, $variants: [ProductVariantsBulkInput!]!) {\n productVariantsBulkCreate(productId: $productId, variants: $variants) {\n productVariants {\n id\n sku\n title\n price\n compareAtPrice\ninventoryItem {\n id\n sku\n tracked\n requiresShipping\n }\n \n selectedOptions {\n name\n value\n }\n }\n userErrors { \n\n field\n message\n }\n }\n }",
"endpoint": "={{ $('set shop url').first().json.myshop }}",
"variables": "={\n \"productId\": \"{{ $json.productId }}\",\n \"variants\": [\n {\n \"price\": {{ $json.variants.price }},\n \"optionValues\": [\n {\n \"name\": \"{{ $json.variants.inventoryItem.size }}\",\n \n \"optionId\": \"{{ $json.variants.optionValues[0].optionId }}\"\n }\n ]\n }\n ]\n}",
"authentication": "headerAuth"
},
"credentials": {
"httpHeaderAuth": {
"id": "90WivU6wv8VrB8sn",
"name": "Header Auth account shopify"
}
},
"typeVersion": 1.1
},
{
"id": "364a6a32-401c-4cc5-9f7c-7d985097d522",
"name": "更新变体",
"type": "n8n-nodes-base.graphql",
"position": [
1936,
64
],
"parameters": {
"query": "mutation productVariantsBulkUpdate($productId: ID!, $variants: [ProductVariantsBulkInput!]!) {\n productVariantsBulkUpdate(productId: $productId, variants: $variants) {\n product {\n id\n handle\n }\n productVariants {\n id\n sku\n title\n price\n compareAtPrice\ninventoryItem {\n id\n sku\n tracked\n requiresShipping\n }\n }\n userErrors {\n field\n message\n }\n }\n}",
"endpoint": "={{ $('set shop url').first().json.myshop }}",
"variables": "={\n \"productId\": \"{{ $json.productId }}\",\n \"variants\": {\n \"id\" : \"{{ $json.data.productVariantsBulkCreate.productVariants[0].id }}\",\n \"price\" : \"{{ $('is variant?').item.json.basePrice }}\",\n \"inventoryItem\": {\n \"sku\": \"{{ $json.variants.inventoryItem.sku }}\",\n \"tracked\": true\n }\n }\n}",
"authentication": "headerAuth"
},
"credentials": {
"httpHeaderAuth": {
"id": "90WivU6wv8VrB8sn",
"name": "Header Auth account shopify"
}
},
"typeVersion": 1.1
},
{
"id": "22739e81-498d-4608-b59a-bec8b39935cf",
"name": "设置库存",
"type": "n8n-nodes-base.graphql",
"position": [
2160,
64
],
"parameters": {
"query": "mutation inventorySetOnHandQuantities($input: InventorySetOnHandQuantitiesInput!) {\n inventorySetOnHandQuantities(input: $input) {\n userErrors {\n field\n message\n }\n }\n}",
"endpoint": "={{ $('set shop url').first().json.myshop }}",
"variables": "={\n \"input\" : {\n \"reason\": \"correction\",\n \"setQuantities\" :[{\n \"inventoryItemId\":\"{{ $json.data.productVariantsBulkUpdate.productVariants[0].inventoryItem.id }}\",\n \"locationId\": \"{{ $('Shopify, GetLocations').first().json.data.locations.edges[0].node.id }}\",\n \"quantity\" : {{ $('set variants data').item.json.variants.inventoryItem.inventory }}\n }]\n }\n}",
"authentication": "headerAuth"
},
"credentials": {
"httpHeaderAuth": {
"id": "90WivU6wv8VrB8sn",
"name": "Header Auth account shopify"
}
},
"typeVersion": 1.1
},
{
"id": "397d171a-5cb1-45b8-8f47-cced0dc1e90a",
"name": "设置变体1",
"type": "n8n-nodes-base.graphql",
"position": [
1040,
512
],
"parameters": {
"query": "mutation productVariantsBulkUpdate($productId: ID!, $variants: [ProductVariantsBulkInput!]!) {\n productVariantsBulkUpdate(productId: $productId, variants: $variants) {\n product {\n id\n handle\n }\n productVariants {\n id\n sku\n title\n price\n compareAtPrice\n }\n userErrors {\n field\n message\n }\n }\n}",
"endpoint": "={{ $('set shop url').first().json.myshop }}",
"variables": "={\n \"productId\": \"{{ $json.data.productCreate.product.id }}\",\n \"variants\": {\n \"id\" : \"{{ $json.data.productCreate.product.variants.edges[0].node.id }}\",\n \"price\" : \"{{ $('is variant?').item.json.price }}\",\n \"inventoryItem\": {\n \"sku\": \"{{ $('is variant?').item.json.fullSKU }}\",\n \"tracked\": true\n }\n }\n}",
"authentication": "headerAuth"
},
"credentials": {
"httpHeaderAuth": {
"id": "90WivU6wv8VrB8sn",
"name": "Header Auth account shopify"
}
},
"typeVersion": 1.1
},
{
"id": "2a69bd47-ca48-4699-b5eb-f1ec16753fca",
"name": "创建产品2",
"type": "n8n-nodes-base.graphql",
"position": [
784,
512
],
"parameters": {
"query": "mutation productCreate($product: ProductCreateInput!, $media: [CreateMediaInput!]) {\n productCreate(product: $product, media: $media) {\n product {\n id\n title\n descriptionHtml\n vendor\n productType\n status\n handle\n variants(first:10) {\n edges {\n node {\n id\n sku\n displayName\n inventoryItem {\n id\n sku\n tracked\n requiresShipping\n }\n }\n }\n }\n media(first: 10) {\n edges {\n node {\n alt\n mediaContentType\n status\n id\n preview {\n image {\n url\n }\n status\n }\n }\n }\n }\n options {\n id\n name\n position\n optionValues {\n id\n name\n hasVariants\n }\n }\n }\n userErrors {\n field\n message\n }\n }\n}",
"endpoint": "={{ $('set shop url').first().json.myshop }}",
"variables": "={\n \"product\": {\n \"title\": \" {{ $json.productName }} \",\n \"vendor\" : \"vendor.\",\n \"productType\": \"type\",\n \"status\": \"ACTIVE\",\n \"handle\": \"{{ $json.productName.replaceAll(\" \", \"-\") }}\"\n },\n \"media\" : [{\n \"alt\" : \"{{ $json.productName }}\",\n \"mediaContentType\" : \"IMAGE\",\n \"originalSource\" : \"{{ $json.productImage }}\"\n }]\n}",
"authentication": "headerAuth"
},
"credentials": {
"httpHeaderAuth": {
"id": "90WivU6wv8VrB8sn",
"name": "Header Auth account shopify"
}
},
"typeVersion": 1.1
},
{
"id": "61e04df6-43f7-4a40-988f-860bd334b16c",
"name": "创建设置库存",
"type": "n8n-nodes-base.graphql",
"position": [
1280,
512
],
"parameters": {
"query": "mutation inventorySetOnHandQuantities($input: InventorySetOnHandQuantitiesInput!) {\n inventorySetOnHandQuantities(input: $input) {\n userErrors {\n field\n message\n }\n }\n}",
"endpoint": "={{ $('set shop url').first().json.myshop }}",
"variables": "={\n \"input\" : {\n \"reason\": \"correction\",\n \"setQuantities\" :[{\n \"inventoryItemId\":\"{{ $('CreateProduct2').item.json.data.productCreate.product.variants.edges[0].node.inventoryItem.id }}\",\n \"locationId\": \"{{ $('Shopify, GetLocations').first().json.data.locations.edges[0].node.id }}\",\n \"quantity\" : {{ $('is variant?').item.json.inventory }}\n }]\n }\n}",
"authentication": "headerAuth"
},
"credentials": {
"httpHeaderAuth": {
"id": "90WivU6wv8VrB8sn",
"name": "Header Auth account shopify"
}
},
"typeVersion": 1.1
},
{
"id": "ef9bb27c-ee31-4a4a-8574-ba03ce6cb368",
"name": "单变体和多变体产品",
"type": "n8n-nodes-base.code",
"position": [
240,
320
],
"parameters": {
"jsCode": "// n8n Code Node - Product Variant Processor\n// This processes products and groups them by variants\nconst items = $input.all();\n\n// Helper function to extract base SKU and variant suffix\nfunction parseVariantSKU(sku) {\n const skuStr = String(sku);\n const parts = skuStr.split('-');\n \n if (parts.length > 1) {\n const baseSKU = parts[0];\n const variantSuffix = parts.slice(1).join('-');\n return { baseSKU, variantSuffix, isVariant: true };\n }\n \n return { baseSKU: skuStr, variantSuffix: '', isVariant: false };\n}\n\n// Group products by Product Name\nconst productGroups = {};\n\nitems.forEach(item => {\n const data = item.json;\n const productName = data['Product Name'];\n \n if (!productGroups[productName]) {\n productGroups[productName] = [];\n }\n \n productGroups[productName].push(data);\n});\n\n// Build output array\nconst output = [];\n\nObject.keys(productGroups).forEach(productName => {\n const variants = productGroups[productName];\n const hasVariants = variants.length > 1 || (variants.length === 1 && variants[0].Size !== '');\n \n if (hasVariants) {\n // Product with variants - prepare all variant data\n const totalInventory = variants.reduce((sum, v) => sum + v['On hand Inventory'], 0);\n const basePrice = variants[0].Price;\n const baseSKU = parseVariantSKU(variants[0].SKU).baseSKU;\n \n // Build optionsGraph dynamically based on variant count\n const optionsGraph = [\n {\n name: \"Size\",\n values: variants.map(v => {\n const parsed = parseVariantSKU(v.SKU);\n return { name: v.Size || parsed.variantSuffix };\n })\n }\n ];\n \n output.push({\n json: {\n type: 'variant',\n productName: productName,\n baseSKU: baseSKU,\n basePrice: basePrice,\n totalInventory: totalInventory,\n variantCount: variants.length,\n productImage: variants[0]['Product Image'],\n // GraphQL options format\n optionsGraph: optionsGraph,\n // Format variants for Shopify productCreate mutation\n variantsForCreate: variants.map(v => {\n const parsed = parseVariantSKU(v.SKU);\n return {\n optionValues: [{ optionName: \"Size\", name: v.Size || parsed.variantSuffix }],\n price: String(v.Price),\n inventoryItem: {\n sku: String(v.SKU),\n tracked: true\n },\n inventoryQuantities: {\n availableQuantity: v['On hand Inventory'],\n locationId: \"LOCATION_ID_PLACEHOLDER\" // Will be replaced\n }\n };\n }),\n // Keep individual variant data for inventory updates\n variants: variants.map(v => {\n const parsed = parseVariantSKU(v.SKU);\n return {\n productName: productName,\n fullSKU: String(v.SKU),\n variantTitle: v.Size || parsed.variantSuffix,\n size: v.Size,\n inventory: v['On hand Inventory'],\n image: variants[0]['Product Image'],\n price: v.Price\n };\n })\n }\n });\n } else {\n // Single product (no variants)\n const product = variants[0];\n const parsed = parseVariantSKU(product.SKU);\n \n output.push({\n json: {\n type: 'single',\n productName: productName,\n baseSKU: parsed.baseSKU,\n fullSKU: String(product.SKU),\n price: product.Price,\n inventory: product['On hand Inventory'],\n productImage: product['Product Image']\n }\n });\n }\n});\n\nreturn output;"
},
"typeVersion": 2
},
{
"id": "6f41fc6d-f06e-4ab3-a2af-cf0983690edb",
"name": "是否为变体？",
"type": "n8n-nodes-base.switch",
"position": [
416,
320
],
"parameters": {
"rules": {
"values": [
{
"outputKey": "Variant",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "843be2ff-a953-4ecc-a547-261adfcf3678",
"operator": {
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.type }}",
"rightValue": "variant"
}
]
},
"renameOutput": true
},
{
"outputKey": "Single",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "7e1926e9-bc68-4cee-a697-5fad1564f903",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.type }}",
"rightValue": "single"
}
]
},
"renameOutput": true
}
]
},
"options": {}
},
"typeVersion": 3.3
},
{
"id": "6b4b776c-08f3-4442-af5a-393b575ae14f",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1728,
-592
],
"parameters": {
"color": 3,
"width": 960,
"height": 1280,
"content": ""
},
"typeVersion": 1
},
{
"id": "4d167268-e51e-4451-8850-73258c233d25",
"name": "设置店铺URL",
"type": "n8n-nodes-base.set",
"position": [
-480,
320
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "3b280df6-01c4-4db0-a53c-4e6579f3ba36",
"name": "myshop",
"type": "string",
"value": "https://[yourshop].myshopify.com/admin/api/2025-04/graphql.json"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "43c3ad5c-2a17-4d87-8d08-d8e4412429d4",
"name": "便签 1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-544,
176
],
"parameters": {
"width": 256,
"height": 336,
"content": "## 添加您的店铺子域名"
},
"typeVersion": 1
},
{
"id": "6d1fe3be-cec8-4517-9759-6aa774c1d3fb",
"name": "设置变体数据",
"type": "n8n-nodes-base.set",
"position": [
1712,
64
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "cf7e0057-939e-4b3c-9654-ef05c2ece564",
"name": "variants.optionValues[0].optionId",
"type": "string",
"value": "={{ $('Split Out1').item.json.variants.optionValues[0].optionId }}"
},
{
"id": "75d5c47f-2614-416a-91fe-540ef44b5ea2",
"name": "variants.price",
"type": "string",
"value": "={{ $('Split Out1').item.json.variants.price }}"
},
{
"id": "0215f465-592a-4724-9412-8147abce1f83",
"name": "variants.inventoryItem.sku",
"type": "string",
"value": "={{ $('Split Out1').item.json.variants.inventoryItem.sku }}"
},
{
"id": "25e5b917-267b-4073-a1e1-5b3bf7bdc34d",
"name": "variants.inventoryItem.inventory",
"type": "number",
"value": "={{ $('Split Out1').item.json.variants.inventoryItem.inventory }}"
},
{
"id": "55109d6c-1599-4414-95ec-47d2aa631284",
"name": "variants.inventoryItem.size",
"type": "string",
"value": "={{ $('Split Out1').item.json.variants.inventoryItem.size }}"
},
{
"id": "53a71947-ca2c-4c19-9dfc-f16c9284f703",
"name": "variants.inventoryItem.image",
"type": "string",
"value": "={{ $('Split Out1').item.json.variants.inventoryItem.image }}"
},
{
"id": "f6a87447-64f2-4a46-a901-da105b8d679a",
"name": "data.productVariantsBulkCreate.productVariants[0].id",
"type": "string",
"value": "={{ $json.data.productVariantsBulkCreate.productVariants[0]?.id ? $json.data.productVariantsBulkCreate.productVariants[0].id : $('Split Out1').item.json.mainfirstVariant }}"
},
{
"id": "22d4abec-4a92-45a9-9473-bc6a1fa7324a",
"name": "productId",
"type": "string",
"value": "={{ $('Split Out1').item.json.productId }}"
},
{
"id": "3cb2cda3-613b-483c-89a1-f316ca0e1050",
"name": "productTitle",
"type": "string",
"value": "={{ $('Split Out1').item.json.productTitle }}"
},
{
"id": "0566352e-70b1-4c20-ad74-560400066cde",
"name": "mediaID",
"type": "string",
"value": "={{ $('Split Out1').item.json.mediaID }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "e4b35802-52dc-472e-82a4-b1669270636c",
"name": "便签 2",
"type": "n8n-nodes-base.stickyNote",
"position": [
704,
-80
],
"parameters": {
"color": 4,
"width": 256,
"height": 784,
"content": "### 使用固定的'type'和'vendor'，或更新JSON变量以传递这些变量"
},
"typeVersion": 1
},
{
"id": "3645bfc0-26b1-405d-8c15-acc984db508a",
"name": "便签 3",
"type": "n8n-nodes-base.stickyNote",
"position": [
1200,
-80
],
"parameters": {
"color": 4,
"width": 256,
"height": 336,
"content": "### 此拆分节点将变体拆分为单独项目，以便在后续步骤中创建和更新"
},
"typeVersion": 1
},
{
"id": "58961d0d-74e5-4bfb-882d-e34ac397aea4",
"name": "调整变体",
"type": "n8n-nodes-base.code",
"position": [
1024,
64
],
"parameters": {
"jsCode": "// Get ALL items from the previous step (all created products)\nconst items = $input.all();\n\n// Get the original variants data from Switch node (all variant products)\nconst switchItems = $('is variant?').all();\n// Process each product\nconst output = items.map((item, index) => {\n // Get the created product data\n const productData = item.json.data.productCreate.product;\n const productId = productData.id;\n const mainVariant = item.json.data.productCreate.product.variants.edges[0].node.id\n const mediaId = item.json.data.productCreate.product.media.edges[0].node.id\n\n // Get the Size option - it should exist now\n const sizeOption = productData.options.find(opt => opt.name === \"Size\");\n\n if (!sizeOption) {\n throw new Error(`Size option not found in created product: ${productData.title}`);\n }\n\n // Get the corresponding original variant data for this product\n const variantsData = switchItems[index].json.variants;\n\n // Build variants array for productVariantsBulkCreate\n // Match each variant with its corresponding optionValue ID\n const variantsForCreate = variantsData.map(variant => {\n // Find the matching option value ID for this size\n const optionValue = sizeOption.optionValues.find(ov => ov.name === variant.size);\n \n if (!optionValue) {\n throw new Error(`Option value not found for size: ${variant.size}`);\n }\n \n return {\n optionValues: [\n {\n optionId: sizeOption.id,\n id: optionValue.id\n }\n ],\n price: String(variant.price),\n inventoryItem: {\n sku: variant.fullSKU,\n inventory: variant.inventory,\n size: variant.size,\n image: variant.image,\n tracked: true\n }\n };\n });\n\n return {\n json: {\n productId: productId,\n productTitle: productData.title,\n mainfirstVariant: mainVariant,\n mediaID: mediaId,\n \n variants: variantsForCreate,\n originalVariantsData: variantsData\n }\n };\n});\n\nreturn output;"
},
"typeVersion": 2
},
{
"id": "144915d0-e6d6-4861-b454-a3eb19d9a137",
"name": "便签 4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-96,
176
],
"parameters": {
"width": 256,
"height": 336,
"content": "## 连接您的表格（产品数据源）"
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"SetVariant": {
"main": [
[
{
"node": "set variants data",
"type": "main",
"index": 0
}
]
]
},
"Split Out1": {
"main": [
[
{
"node": "SetVariant",
"type": "main",
"index": 0
}
]
]
},
"SetVariant1": {
"main": [
[
{
"node": "Create SetInventory",
"type": "main",
"index": 0
}
]
]
},
"is variant?": {
"main": [
[
{
"node": "Shopify, CreateProduct",
"type": "main",
"index": 0
}
],
[
{
"node": "CreateProduct2",
"type": "main",
"index": 0
}
]
]
},
"SetInventory": {
"main": [
[]
]
},
"set shop url": {
"main": [
[
{
"node": "Shopify, GetLocations",
"type": "main",
"index": 0
}
]
]
},
"CreateProduct2": {
"main": [
[
{
"node": "SetVariant1",
"type": "main",
"index": 0
}
]
]
},
"Update Variants": {
"main": [
[
{
"node": "SetInventory",
"type": "main",
"index": 0
}
]
]
},
"adjust variants": {
"main": [
[
{
"node": "Split Out1",
"type": "main",
"index": 0
}
]
]
},
"set variants data": {
"main": [
[
{
"node": "Update Variants",
"type": "main",
"index": 0
}
]
]
},
"Get row(s) in sheet": {
"main": [
[
{
"node": "single and multivariant products",
"type": "main",
"index": 0
}
]
]
},
"Shopify, GetLocations": {
"main": [
[
{
"node": "Get row(s) in sheet",
"type": "main",
"index": 0
}
]
]
},
"Shopify, CreateProduct": {
"main": [
[
{
"node": "adjust variants",
"type": "main",
"index": 0
}
]
]
},
"single and multivariant products": {
"main": [
[
{
"node": "is variant?",
"type": "main",
"index": 0
}
]
]
},
"When clicking ‘Execute workflow’": {
"main": [
[
{
"node": "set shop url",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
Facebook页面评论管理机器人：回复、删除、封禁和通知
AI驱动的Facebook评论管理：自动回复、删除、封禁和通知
If
Set
Code
+18
59 节点SpaGreen Creative
社交媒体
API架构提取器
API架构提取器
If
Set
Code
+22
88 节点Polina Medvedieva
工程
潜在客户开发与邮件工作流
使用Google Maps、SendGrid和AI自动化B2B潜在客户开发与邮件营销
If
Set
Code
+21
141 节点Ezema Kingsley Chibuzo
潜在客户开发
将Google Maps评论同步到Google表格
使用SerpApi的Google Maps评论到Google表格同步
If
Set
Code
+7
22 节点SerpApi
市场调研
（Duc）深度研究市场模板
集成PerplexityAI研究和OpenAI内容的多层级WordPress博客生成器
If
Set
Xml
+28
132 节点Daniel Ng
人工智能
使用 Gemini AI 转录和摘要的 YouTube 频道监控并同步至 Google Sheets
使用 Gemini AI 转录和摘要的 YouTube 频道监控并同步至 Google Sheets
If
Set
Code
+10
33 节点Muhammad Asadullah
内容创作
工作流信息
难度等级
高级
节点数量21
分类-
节点类型8
作者
Muhammad Asadullah
@asadtechI am a Data Scientist, and Generative AI Developer with expertise in building AI applications, chatbots, and automation systems. Skilled in Python, R, and no-code/low-code platforms like n8n and Make, I combine strong technical knowledge in machine learning and NLP with hands-on experience in power systems, transformers, and solar design.
外部链接
在 n8n.io 查看 →
分享此工作流