Import products from Google Sheets to Shopify with multi-variant support
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 simp
At a glance
Import products from Google Sheets to Shopify with multi-variant support is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Shopify, Google Sheets. It's free to download. Follow the 5-step import below to go live in minutes.
- Platform
- n8n
- Connects
- Shopify, Google Sheets
- Modules
- 16
- Price
- Free
- Version
- v1.0

About this workflow
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 1. Shopify store with Admin API access 2. Google Sheets API credentials 3. n8n version 1.0+ 4. 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 1. Reads product data from your Google Sheet 2. Groups products by name and detects if they have variants 3. Switches to appropriate creation path (single or variant) 4. Creates product in Shopify with options and variants 5. Updates each variant with SKU and pricing 6. Sets inventory levels at your location 7. 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
How to import this n8n workflow
- 1
Download the workflow JSON file after purchase.
- 2
Open n8n → click the menu → Import from File.
- 3
Select the downloaded JSON and import.
- 4
Set up credentials for each node that requires them.
- 5
Click Execute Workflow to test, then activate.
Setup guide
Setup guide included
Purchase to unlock the full step-by-step guide
Related N8n workflows
Generate weekly supply chain OTIF reports and AI analysis with Notion and GPT-4o
Add Intercom users from new Google Sheets rows
Add subscribers to Campaign Monitor from a Google Sheets spreadsheet
Cold outreach automation: Scrape local leads with Dumpling AI & call via Vapi
Filter rows in Google Sheets and create invoices in Xero for specific contacts
Extract invoice data from scanned PDFs to Google Sheets with Sarvam and Gemini
Report and clean up stale GitHub branches with Slack notifications
Detect misinformation and manipulation risks with GPT-4o agents and Google Sheets
Reviews
No reviews yet
Be the first to buy and share your experience.
Leave a review
Sign in to share your experience with this workflow.
Create a free account to purchase workflows.
- JSON blueprint — instant download
- Setup guide PDF included
- 5 downloads · valid 30 days
- Works with n8n
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.
- Configure live on Google Meet / Zoom
- Free follow-up if workflow has defects
- Platform expert assigned to you