Import Products from Google Sheets to Shopify with Multi-Variant Support

Description

Short Description (for listing)
Import products from Google Sheets to Shopify with automatic handling of single products and multi-variant products (sizes, colors, etc.). Includes SKU management, inventory tracking, and image uploads via GraphQL API.

Category
E-commerce
Productivity
Data Import/Export

Full Description

Overview
This workflow automates the process of importing products from a Google Sheet into your Shopify store. It intelligently detects and handles both simple products and products with multiple variants (like different sizes or colors), creating them with proper SKU management, pricing, inventory levels, and images.

Key Features
✅ Dual Product Support: Handles single products and multi-variant products automatically
✅ Smart SKU Parsing: Automatically groups variants by parsing SKU format (e.g., 12345-SM, 12345-MD)
✅ Inventory Management: Sets stock levels for each variant at your default location
✅ Image Upload: Attaches product images from URLs
✅ GraphQL API: Uses Shopify's modern GraphQL API for reliable product creation
✅ Batch Processing: Process multiple products in one workflow run

Use Cases
Initial store setup with bulk product import
Regular inventory updates from spreadsheet
Migrating products from another platform
Managing seasonal product catalogs
Synchronizing products with external systems

Requirements
Shopify store with Admin API access
Google Sheets API credentials
n8n version 1.0+
Basic understanding of GraphQL (helpful but not required)

What You'll Need to Configure
Shopify Admin API token
Your Shopify store URL (in 'set store url' node)
Google Sheets connection
(Optional) Vendor name and product type defaults

Input Format
Your Google Sheet should contain columns:
Product Name
SKU (format: BASESKU-VARIANT for variants)
Size (or other variant option)
Price
On hand Inventory
Product Image (URL)

Products with the same name are automatically grouped as variants.

How It Works
Reads product data from your Google Sheet
Groups products by name and detects if they have variants
Switches to appropriate creation path (single or variant)
Creates product in Shopify with options and variants
Updates each variant with SKU and pricing
Sets inventory levels at your location
Uploads product images

Technical Details
Uses Shopify GraphQL Admin API (2025-04)
Handles up to 100 variants per product
Processes variants individually for accurate data mapping
Includes error handling for missing data
Supports one inventory location per run

Common Modifications
Change vendor name and product type
Add more variant options (color, material, etc.)
Customize product status (draft vs active)
Modify inventory location selection
Add product descriptions

Perfect For
Shopify store owners managing large catalogs
E-commerce managers doing bulk imports
Agencies setting up client stores
Developers building automated product workflows

Difficulty: Intermediate
Estimated Setup Time: 15-30 minutes
Nodes Used: 16
External Services: Shopify, Google Sheets