android sms

Pretty sure there are no SMS backup apps that are triggered by send/receive of messages.
The best "auto" backup you will probably find is time based, like once per day or once per week.