Send Shopify Product Inventory Updates to Google Sheets

4 min setup

No coding required

Runs automatically

Keep your product inventory organized outside Shopify by sending stock levels, SKUs, and product details directly to Google Sheets. Perfect for sharing inventory data with team members, creating custom reports, or maintaining backup records. This workflow sends your current inventory whenever products are updated, so your spreadsheet stays current without manual data entry.

How it works

3 steps to start receiving real-time inventory updates in your Google Sheets

Inventory Level Updated

App connector: [Shopify](/content/apps/shopify/integrate "View Shopify integration page"/index.html)• Time to complete: 0 minutes (Auto-configured)

Why this matters: This trigger monitors your Shopify store continuously and activates the workflow whenever any product variant's inventory quantity changes, whether from sales, restocking, or manual adjustments.

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.

Query Rows

App connector: [Google Sheets](/content/apps/googlesheets/integrate "View Google Sheets integration page"/index.html)• Time to complete: 2 minutes

Why this matters: This step searches your existing Google Sheets spreadsheet to find the correct row for the product variant that just had an inventory change, ensuring updates go to the right place.

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.

Update Row

App connector: [Google Sheets](/content/apps/googlesheets/integrate "View Google Sheets integration page"/index.html)• Time to complete: 1 minute

Why this matters: This step writes the new inventory quantity to the correct row in your spreadsheet, replacing the outdated inventory count with the current stock level from your Shopify store.

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.

Frequently asked questions

What happens if I have products that aren't in my Google Sheets yet?

The workflow will skip inventory updates for products not found in your spreadsheet. Run the "Send Shopify Products to Google Sheets" template first to populate your sheet with all current products, then activate this inventory tracking workflow.

Can this workflow handle inventory changes from multiple sales channels?

Yes, since it monitors Shopify's master inventory system, it captures stock changes regardless of where the sale occurred - whether through your online store, POS system, or third-party marketplaces connected to Shopify.

Will this work if I manually adjust inventory quantities in Shopify?

Absolutely. The trigger responds to any inventory level change in Shopify, including manual adjustments, bulk imports, or automated restocking, ensuring your Google Sheets always reflects the most current stock levels.

Make this template your own!

Customize this workflow even further:

• Set inventory thresholds
• Add conditional logic to flag products when inventory drops below specific levels, automatically highlighting low-stock items in your spreadsheet.
• Track inventory value changes
• Calculate and log the dollar impact of inventory adjustments by multiplying quantity changes with product prices for financial reporting.
• Connect multiple spreadsheets
• Route different product types or locations to separate Google Sheets, keeping apparel inventory separate from electronics or tracking by warehouse location.
• Send low stock alerts
• Trigger email or Slack notifications when specific products reach reorder points, ensuring you never run out of bestsellers.

You're in good company

Avg. App Store rating 4.9/5

Merchant reviews 157

Avg. time saved per week 3.5 hrs

"MESA has been a game changer for us. And, if you ever get stuck, their support team is always super helpful." - PetFriendly

"It's like Zapier but exactly designed for Shopify. I have been able to complete all the workflows that I've needed." - Zailys

"The MESA team has been amazing at helping us set up our automations. We would highly recommend this app!" - Rothy's