How to set up inventory alerts based on average daily sales?

[abhijithp048]

I want a flow where I get an email/slack notification when the "inventory available" for a given SKU is less than "average sales per day (calculated over the last 7 days)" for that particular SKU.

This will help me proactively restock the products before they run out.