Skip to main content

I have a stock report created daily by EZOfficeInventory that shows current stock quantities in one column, and the low stock threshold in another. If needed, I can have a new Google Sheet, Google Doc or Airtable records created.

 

Is there a way to automate the removal of the rows where current stock is greater than or equal to it’s low stock threshold?

The goal is to send our shop manager a list of the items we are running low on to make sure that we do not run out of stock, particularly in the high volume items.

Hi @mannyv86 

Good question.

I’d recommend using Airtable.

Then you can configure an Airtable Automation.