Is there a way to create a flow for when Amazon Seller Central is out of stock to Google Sheet?

Hi @ctsimon 

The best solution would be to decentralize your inventory tracking. 

As @Troy Tessalone mentioned, there is a trigger available that fires when a new order is received. Lets imagine that you had a Google Sheet that you had every item you were selling on Amazon, as well as its qty and sku. 

You could then have an automation that looked at the order, found the sku in the Google sheet, and removed the appropriate qty from the spreadsheet, triggering a notification when the quantity got below a certain number. 

Ive built something like this for a shopify store, would be happy to help more just drop me a line here or at aaron@appency.com

Cheers!

@ctsimon 

@Troy Tessalone has a good solution with the Airtable views/automations. 

If you are not an AirTable guy however, Google Sheets will absolutely work for this. 

Zapier has a tool called Formatter which you can use to manipulate numbers. What you would want here was a Spreadsheet-Style Formula like such: 

This gives you the new inventory quantity which you can then replace the old quantity with in your spreadsheet. You would then want a Filter to Only Continue If the new inventory amount is whatever you want your notification point to be (so if you wanted to be notified when your inventor reached 3 items you would do Inventory | (Text) Exactaly Matches | 3

Here is mine where I get notified when we completely run out of an item using (Number) Less Than | 1 and then being notified in Slack.