Automation · Intermediate · about 17 minutes

Your first automation — a scheduled report that runs itself

Every Monday you export sales, open a spreadsheet, check stock against reorder points, and message the exceptions. Twelve minutes, every week, and you skip it whenever Monday is busy — which is exactly when you most need it.

You need

Sheet 'Stock Monitor', tab 'Current'. Headers row 1, data from row 2.

Tool

Google Apps Script

You get

1. THE SCRIPT (abbreviated here; the full script is produced ready to paste) The script opens the 'Current' tab, reads columns A to F from row 2, and for each row computes two checks: is stock below the reorder point, and are days of cover below 21.

Time saved

12 minutes weekly to zero, plus it runs on the weeks you would have skipped — which are the weeks it matters most.