As I looked for a more efficient tool for dealing with snapshots while patching and updating our OS in the Proxmox machines, I came across cv4pve-autosnap by Corsinvest. Trust me, it is definitely years ahead of any sequential bash script.
Not only does it contain automatic tools for dealing with complex rotation and applying time retention rules, but also it takes into consideration the integrity of data, requesting the file system to freeze using QEMU Guest Agent mere seconds before creating a snapshot. As a result, you will not have any issues with database corruption during the recovery of your information in the event of a disaster.
Thus, we decided to try it in our organization and must admit that we were rather pleased with the results, so I would advise giving it a go.
Here is the repo if you want to check it out: https://github.com/Corsinvest/cv4pve-autosnap