AutomationMart
Home/Browse/Import products from Google Sheets to Shopify with multi-variant support
n8n

Import products from Google Sheets to Shopify with multi-variant support

n8nn8n16 modulesv1.0
ShopifyGoogle Sheets

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
Import products from Google Sheets to Shopify with multi-variant support workflow diagram

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

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 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

Tags: Logistics, Supply Chain, OTIF, KPI Tracking, Performance Management, AI Analysis, Notion Context Hi! I'm Samir, Supply Chain Engineer, Data Scientist based in Paris, and founder of LogiGreen. > Let's use AI with n8n to automate supply chain performance tracking! Tracking On-Time In-Full (OTIF) delivery performance is critical for retail logistics, but manually compiling data, computing KPIs, and writing analysis reports is time-consuming and error-prone. []( This workflow automates the

Free

Add Intercom users from new Google Sheets rows

Every time a new row is added to your Google Sheets spreadsheet, Make will automatically create a new user in Intercom. The template uses this [examplle spreadsheet](https://bit.ly/2JsO3Sm).

Free

Add subscribers to Campaign Monitor from a Google Sheets spreadsheet

Every time a new row is added to a selected Google Sheets spreadsheet, Make will automatically add a new subscriber to your Campaign Monitor list. The template uses this [example spreadsheet](https://goo.gl/BUAwJs).

Free

Cold outreach automation: Scrape local leads with Dumpling AI & call via Vapi

Who is this for? This template is for sales teams, agencies, or local service providers who want to quickly generate cold outreach lists and automatically call local businesses with a Vapi AI assistant. It’s perfect for automating cold calls from scraped local listings with no manual dialing or research. --- What problem is this workflow solving? Finding leads and initiating outreach calls can be time-consuming. This workflow automates the process: it scrapes business listings from Google Maps u

Free

Filter rows in Google Sheets and create invoices in Xero for specific contacts

Automatically filter rows in Google Sheets and generate Xero invoices for specific contacts, streamlining your invoicing process with precise data management.

Free

Extract invoice data from scanned PDFs to Google Sheets with Sarvam and Gemini

This template is designed for operations, finance, and accounting teams that need to automatically process scanned invoices and extract structured data without manual entry. It is ideal for businesses handling vendor invoices, reimbursement forms, or bulk document intake. What this workflow does This workflow uses Sarvam AI Vision model to perform OCR on scanned invoices and extract raw text. The extracted content is then processed using an LLM to identify key invoice fields such as: Vendor nam

Free

Report and clean up stale GitHub branches with Slack notifications

Quick Overview This workflow runs weekly (or manually) to scan GitHub repositories for merged-but-not-deleted and stale branches, then posts a cleanup report to Slack and can optionally auto-delete a capped number of branches. How it works 1. Runs on a weekly schedule or when you manually execute the workflow. 2. Loads configuration for the GitHub repo owner, repository list, stale age threshold, protected branch patterns, Slack channel, and deletion limits. 3. For each configured repository, fe

Free

Detect misinformation and manipulation risks with GPT-4o agents and Google Sheets

How It Works This workflow automates misinformation and information manipulation detection using a coordinated multi-agent AI architecture. It is designed for trust and safety teams, media analysts, researchers, and platform moderators who need scalable, structured threat assessment. The pipeline begins when a trigger initiates content analysis. A central Misinformation Detection supervisor agent coordinates three specialised sub-agents: a Narrative Pattern Detector that identifies recurring dis

Free

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.

Log in to review
Free
No ratings yet

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.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free