PICKED FROM N8N.IO · ONLINE STORE

This workflow reads product rows from a Google Sheet and creates them in Shopify. For each row it checks whether a product with that handle already exists, creates new ones, turns on inventory tracking, and sets the quantity at your default location. Existing products are skipped.

Template by Richard Uren · 4.3k views on n8n.io · listed there as “Bulk create Shopify products with inventory management from Google Sheets”

THE WORKFLOW10 NODES
MStart Workflow▦Google Sheet,Fetch ProductsGShopify,ProductQuery⑂If product existsGShopify,CreateProductSLoop Over ItemsGShopify,GetLocationsGShopify, EnableInventoryTrackingGShopify, SetInventoryLevel–Finished
DIFFICULTY
Intermediate
NODES
10
USES AI
No
PUBLISHED
July 2025

001 / WHAT HAPPENS

  1. 01

    A manual trigger starts the run and Google Sheets returns the product rows.

  2. 02

    The workflow loops over each row in the sheet, one product at a time.

  3. 03

    A Shopify query checks whether a product with the same handle already exists.

  4. 04

    If not, it creates the product and looks up your store's default location.

  5. 05

    It switches on inventory tracking and sets the stock quantity at that location.

WHO IT SUITS

Suits a Shopify store loading a new range or test products from a spreadsheet instead of typing each one in.

CONNECTS

  • Google Sheets
  • Shopify

002 / BEFORE YOU USE IT HERE

  • !Your sheet needs the exact column names listed in the template (title, slug, price, sku, stock_on_hand and so on). Mismatches will create blank or failed products.
  • !Shopify prices come through as entered. Check whether your prices include GST and that the store currency is AUD.
  • !It only creates products and never updates existing ones. Try it on a development store first, because live products appear on your shop.

WORTH KNOWING

Templates on n8n.io are written for a global audience. Set the workflow timezone to your city, and test with a handful of real items before switching it on.

Need n8n and the AI hosted in Australia? →

004 / QUESTIONS

Anything else is quicker to answer on a call. Thirty minutes, free, with the people who would build it.

Yes. Every template on this list is free on n8n.io. You need an n8n account (n8n Cloud or self-hosted) and accounts for the apps it connects to, some of which charge for API use.

We adapt templates to your systems, add approval steps where customers are involved, host n8n in Australia when the data calls for it and hand it over documented.

Book a free call→