Send Shopify Product Inventory Updates to Google Sheets

This step runs automatically in the background and captures inventory level changes across your entire Shopify catalog. When triggered, it provides the updated variant ID and new inventory quantity that will be used to update the corresponding row in your spreadsheet. No configuration is needed since MESA connects directly to your Shopify store's inventory system and detects changes in real-time. The trigger passes the variant information to the next step for product lookup.

You'll select which Google Sheets spreadsheet contains your product data - ideally one created by running the "Send Shopify Products to Google Sheets" template first. The step searches column G (Variant ID) to match the variant from the inventory change trigger. Once it finds the matching row, it retrieves all the product information including the current row number, which is needed for the update step. If no matching row is found, the workflow won't proceed to prevent creating duplicate or incorrect entries.

You'll select the same Google Sheets spreadsheet used in the previous step to maintain consistency. The step automatically updates column J (Variant Inventory Quantity) with the new stock level while preserving all other product information in the row. The update happens immediately after the inventory change in Shopify, so your spreadsheet always reflects current stock levels. This ensures your external reporting, purchasing decisions, and inventory tracking stay accurate without manual data entry.