workflows.fit
Back to n8n workflows
n8n templateFreeBy Muhammad Asadullah

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, a...

Data & StorageProductivityDevelopmentCore NodesManual TriggerGoogle SheetsGraphqlSplit Out
Loading interactive preview...

Template notes

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