Qualifying and handling incoming sales leads manually takes hours of tedious, repetitive work. Every time a potential client submits an inquiry, you have to manually read their budget, assign priority, post updates to team channels, log details into spreadsheets row by row, and draft custom proposal emails from scratch.

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.