Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

I’ve been going around and around on this for a while, but can’t seem to figure it out.

 

I have a Google Sheet that updates regularly. Whenever it does so, I want Zapier to:

  1. Load a Google Sheet that has columns for SKUs and Inventory Text values, (In stock, limited, ETA x days, etc).
  2. Match the Sheet SKUs to products in Shopify that have the same SKUs
  3. If the Google Sheet has the value “In Stock”, “Less than 25”, or “Less than 10”:
    1. The Shopify “Track Inventory” value should be set to false.
  4. If the Google Sheet has a value of anything else in the fields:
    1. The Shopify “Track Inventory” value should be set to true.
    2. The Shopify “Inventory Available” value should be set to 0.

​​​​​​​
I’ve tried a bunch of different options, but can’t seem to get it to work and the forums don’t seem to have an answer either.

Thanks in advance for any suggestions!

Hi ​@BtonM 

An option you may want to consider is hiring help from a Certified Zapier Expert: https://zapier.com/experts

The type of logic you’ve indicated may require more advanced approaches:

Thanks for the response, ​@Troy Tessalone . I was hoping to do this via a no-code option. If I have to make API calls, I’ll probably just develop a Shopify app and reduce the complexity of using an outside workflow tool. Bummer that Zapier’s Google Sheets plug-in can’t do basic IF THEN statements.

Terms & Conditions