Email/text-msg Alerting Based on a Transaction (Google Sheets)

I like what you’ve done here, @albano.mike, and I can see how Tiller’s integration with tools like Apps Script allows you do go further customizing automated workflows to suit your needs. I also like how you have repurposed Autocat as the real-time transaction flagger— clever!

One minor callout… you scan the range Transactions!D:D for the “Alert” category. This won’t work in all users’ sheets as some have added or moved columns. I’d recommend either calling out in the instructions that that call in the script should be customized to match the user’s Transactions sheet or adding a few lines of code to first find the Category column (e.g. fetch and find a match on Transactions!1:1, then use that index to fetch the correct column).

I’d love to offer you a reward with your contribution but script-based solutions are currently not eligible for our Builder Rewards Program.

Thanks so much for sharing this solution. It’s powerful but elegant in its simplicity.