Step 2: Connect Google Sheets

Pull product rows from your spreadsheet to drive the import.

1. Add Fetch Shopify Locations after Assign Shop URL.
2. In Fetch Shopify Locations, set Endpoint to ={{ $('Assign Shop URL').item.json.myshop }} and keep Authentication as headerAuth.
3. Credential Required: Connect your httpHeaderAuth credentials for Fetch Shopify Locations.
4. Add Retrieve Sheet Rows and set Document to Shopify Store Details and Sheet to Products.
5. Credential Required: Connect your googleSheetsOAuth2Api credentials for Retrieve Sheet Rows.
6. Connect Fetch Shopify Locations → Retrieve Sheet Rows.

Step 3: Set Up Processing Logic

Transform your sheet rows into structured objects for single or variant products.

1. Add Process Product Variants and paste the provided JavaScript exactly as-is to group products and build variant metadata.
2. Connect Retrieve Sheet Rows → Process Product Variants.
3. Add Branch by Variant Type to route items based on the type field.
4. In Branch by Variant Type, ensure the rule uses ={{ $json.type }} equals variant for the Variant output and ={{ $json.type }} equals single for the Single output.
5. Connect Process Product Variants → Branch by Variant Type.

Step 4: Configure Shopify Product Creation

Create products in Shopify for variant and single items, then prepare variant payloads for bulk creation.

1. Connect the Variant output of Branch by Variant Type to Create Shopify Item.
2. In Create Shopify Item, set Endpoint to ={{ $('Assign Shop URL').first().json.myshop }} and keep the provided GraphQL Query and Variables (including {{ $json.productName }}, {{ $json.productImage }}, and {{JSON.stringify($json.optionsGraph)}}).
3. Credential Required: Connect your httpHeaderAuth credentials for Create Shopify Item (this same credential is reused across all Shopify GraphQL nodes).
4. Connect Create Shopify Item → Prepare Variant Payloads.
5. Add Prepare Variant Payloads and keep the provided JavaScript so it maps option values by size using Branch by Variant Type data.
6. Connect the Single output of Branch by Variant Type to Create Single Item, with Endpoint set to ={{ $('Assign Shop URL').first().json.myshop }} and the provided GraphQL variables (including {{ $json.productName.replaceAll(" ", "-") }}).
7. Credential Required: Connect your httpHeaderAuth credentials for Create Single Item.

Step 5: Configure Variant Batching, Updates, and Inventory

Split variants, create them in bulk, and then update price and inventory for both variant and single products.

1. Add Split Variant Items and set Field to Split Out to variants and Fields to Include to productId, productTitle, mainfirstVariant, mediaID.
2. Connect Prepare Variant Payloads → Split Variant Items → Create Variant Batch.
3. In Create Variant Batch, set Endpoint to ={{ $('Assign Shop URL').first().json.myshop }} and keep the variables mapping including {{ $json.productId }}, {{ $json.variants.price }}, and {{ $json.variants.optionValues[0].optionId }}.
4. Credential Required: Connect your httpHeaderAuth credentials for Create Variant Batch.
5. Connect Create Variant Batch → Map Variant Fields and keep the assignments, especially ={{ $('Split Variant Items').item.json.variants.inventoryItem.inventory }} and the fallback ID mapping for data.productVariantsBulkCreate.productVariants[0].id.
6. Connect Map Variant Fields → Update Variant Details → Adjust Inventory Levels and keep all GraphQL variables using ={{ $('Assign Shop URL').first().json.myshop }} and the location ID from ={{ $('Fetch Shopify Locations').first().json.data.locations.edges[0].node.id }}.
7. Connect Create Single Item → Update Single Variant → Set Single Inventory and keep the inventory set input (including ={{ $('Branch by Variant Type').item.json.inventory }}).

Step 6: Test and Activate Your Workflow

Validate the full flow end-to-end and then enable it for ongoing use.

1. Click Execute Workflow and confirm Manual Run Trigger starts the execution.
2. Check the output of Retrieve Sheet Rows to ensure product data is loaded from Shopify Store Details → Products.
3. Verify the switch routing in Branch by Variant Type sends items to Create Shopify Item or Create Single Item appropriately.
4. Confirm Shopify responses include product IDs and variant IDs in Create Shopify Item, Create Variant Batch, and Create Single Item.
5. Once successful, toggle the workflow Active to use it in production.