I wanted to alert myself and spouse automatically on budget progress. This cuts out the need for frequent checking of progress.
I was actually searching for a way to create stock alerts on an entire watchlist based on price targets. I mucked about with scripts but went the easy way using the free service from zapier.com.
Setting up an alert
On the monthly budget spreadsheet, create a new column A. In A1, entered the formula ‘=if(D8>0,"",“Over Budget”)’. D8 contains the value remaining to spend in the budget.
In google sheet settings, under calculation, change setting to recalculate every hour.
Open a free account at zapier.com and create a zap. For the trigger, select Google Sheets. For Trigger event, select New or Updated Spreadsheet Row. Follow the simple steps linking the monthly budget worksheet, and select column A as the Trigger Column. Follow the steps to send an email. An email will be sent when the value in A1 changes to ‘Over Budget’. I might play about further to create warnings as I approach 100% of budget or set alerts on category levels.