was hoping for a software solution but looks like i have to write a bunch of scripts.This should help you to backup Google Drive: https://blog.ruanbekker.com/blog/2020/05/08/server-backups-to-google-drive-using-the-drive-cli-tool/
nope, shell only.
In that case Rclone will be the ideal solution for you to send the backups to Google drive. Check out it here: https://rclone.org/drive/