How did you automate this? Did you use some sort of API or just set it up through the bank's website?
The text message alert is set up on the online banking site - I set it up to send a text message whenever there's a debit >$1. There are a few banks (Chase is one) that even offer real-time alerts where you get texted as soon as the transaction happens, but most will send the alerts at some time of the day. It's a shame that more banks don't implement and advertise that feature to prevent fraud. To me it's comforting to get a text as soon as the card gets swiped.