
This workflow is essential for dropshippers, e-commerce store owners, and anyone looking to quickly import product catalogs from specific websites into their Shopify store.
This Workflow uses a community contribution and is designed and tested for self-hosted n8n instances only.
The workflow reads a list of product page URLs from a Google Sheet.
Your sheet, with its columns for Product Name and Product Link, acts as a database for your workflow.
The Loop Over Items node processes products one URL at a time.
Two BrowserAct nodes run sequentially to scrape all product details, including the Name, price, description, sizes, and image links.
A custom Code node transforms the raw scraped data (where fields like sizes might be a single string) into a structured JSON format with clean lists for sizes and images.
The Shopify node creates the base product entry using the main details.
The workflow then uses a series of nodes (Set Option and Add Option via HTTP Request) to dynamically add product options (e.g., "Shoe Size") to the new product.
The workflow intelligently uses HTTP Request nodes to perform two crucial bulk tasks:
A final Slack notification confirms the batch has been processed.