This involves organizing business information in a spreadsheet

Masahallah

This project tackles a real small-business pain point: inventory silently running out because no one's tracking stock in real time.

Order processing (webhook-triggered): Incoming orders (supporting multiple items per order) are received via webhook, split into individual line items, and logged — each order simply appends a new entry to an order log rather than directly overwriting stock numbers.

Live stock calculation: Current stock for each item is computed on the fly, using a formula that subtracts all logged order quantities from the starting count.

Daily stock monitoring (schedule-triggered): A separate scheduled trigger runs once a day, checks every item's live stock against its own custom reorder threshold, and sends a Slack alert for anything running low — so restocking happens before customers ever notice a shortage.

The daily trigger that checks each item's live stock against its own reorder threshold and then pushes a Slack alert seems like a practical way to stay ahead of stockouts.