JsWorkflows Templates
Template catalog / Inventory and merch
Inventory and merch

Sync inventory from Google Sheets (OAuth)

Updates Shopify inventory from a Google Sheet selected through a Google OAuth connection, with optional product-level auto publish and auto unpublish rules.

Install JsWorkflowsTemplate setup docs

Setup guide

Before you start

This template reads a Google Sheet and updates Shopify inventory for existing products using a Google OAuth connection.

Matching modes

  • Variant SKU mode: best for catalogs with unique SKUs
  • Handle mode: only for single-variant products

Sheet model

  • Row 1 must contain headers
  • Header names matter; column order does not
  • Each row represents one identifier update row
  • Blank inventory cells are skipped
  • A quantity of 0 is treated as a real update and sets that location to zero

Required headers

When Identifier mode is sku:

  • Variant SKU
  • one or more Inventory: Location Name columns

When Identifier mode is handle:

  • Handle
  • one or more Inventory: Location Name columns

Examples:

  • Inventory: Sydney Warehouse
  • Inventory: Melbourne Warehouse

Multi-location inventory

Use one inventory column per Shopify location. Any non-empty integer value in those columns is synced to that location.

If an inventory item is not yet stocked at a target location, the workflow automatically activates it before retrying the quantity update.

Google OAuth setup

This version uses a Google OAuth handle instead of a service account.

Provide:

  • OAUTH_HANDLE
  • SPREADSHEET_ID using the Google picker or an already-accessible spreadsheet ID
  • SHEET_NAME
  • optional REPORT_SHEET_NAME

If you use the picker, the saved spreadsheet reference includes metadata such as the file name and resource key when available.

Error reporting

If Report sheet name is set, the template appends row-level failures to that tab in the same selected spreadsheet.

Create the report tab before running the template. Leave the field blank to disable report logging.

Publishing behavior

Optional auto publish and auto unpublish rules work at the product level. After a successful inventory update, the workflow checks Shopify's live tracked inventory for the affected product and then:

  • publishes the product when any tracked variant has inventory above zero
  • unpublishes the product when all tracked variants are at zero or below

Selected Shopify publications are loaded live in the setup UI and stored by publication ID.

Products with untracked variants are skipped for auto publish and auto unpublish, because tracked inventory alone would not be a reliable visibility signal for them.

Internal pacing

This template automatically chooses internal row batch sizing and chunk staggering based on sheet size, inventory-column complexity, and whether auto publish or auto unpublish is enabled. Shopify throttling is handled internally with deferred retries so the workflow can slow down instead of surfacing throttle failures as row errors.

Important limits

  • Handle mode only supports single-variant products
  • Variant SKU mode is the recommended mode for multi-variant catalogs
  • This template updates inventory only. It does not change price, cost, metafields, or product content

Header mapping overrides

If your supplier or source file uses different column names, you can keep the original file and configure mappings in setup:

  • Identifier source header override lets you point the template at a custom SKU or handle column
  • Inventory header mappings lets you map supplier stock columns to Shopify locations using one line per mapping

Example:

  • Supplier SKU => set in the identifier override field
  • Sydney Qty => Sydney Warehouse
  • Melbourne Stock => Melbourne Warehouse

Setup fields

Google OAuth handle
textRequiredconfig

OAuth handle for the Google connection that can access the selected spreadsheet.

Spreadsheet ID
google_drive_file_pickerRequiredconfig

Select the Google Sheet with the picker or paste an already-accessible spreadsheet ID.

Source sheet name
textRequiredconfig

The tab name to read inventory rows from.

Report sheet name
textOptionalconfig

Optional tab used for row-level error reporting. Leave blank to disable report logging.

Identifier mode
selectRequiredconfig

Use SKU for most catalogs. Use Handle only for single-variant products.

Identifier source header override
textOptionalconfig

Optional source header name to use instead of the default 'Variant SKU' or 'Handle' column.

Inventory header mappings
textareaOptionalconfig

Optional line-by-line mapping when supplier stock columns do not use the 'Inventory: Location Name' format. Use one line per mapping: Source Header => Shopify Location Name

Channels for auto publish/unpublish
shopify_publication_multiselectOptionalconfig

Optional Shopify sales channels used by the auto publish and auto unpublish rules.

Auto publish when in stock
checkboxOptionalconfig

Publish affected products to the selected channels when Shopify's live tracked inventory is above zero after sync.

Auto unpublish when out of stock
checkboxOptionalconfig

Unpublish affected products from the selected channels when all tracked variants are at zero or below after sync.

Related templates

Import products from CSV URLImports or updates products, variants, images, and multi-location inventory from a public CSV URL with optional publication targeting.Import products from Google SheetsImports or updates products, variants, metafields, and multi-location inventory from a Google Sheet with row-level error reporting.Sync inventory from CSV URLUpdates Shopify inventory from a CSV URL using Variant SKU or Handle matching, with optional product-level auto publish and auto unpublish rules.