I wrote a linux shell script that works with rclone to upload the file to google drive and then delete the file from the local storage. It does not auto-delete, though. This is fine though, as even at relatively large backups (4 mb), it can hold 250 days using only 1 gb, leaving plenty of space for Gmail and your google drive files. The shell script should be kept in a directory called Hubitat_Backup and should be run through sudo crontab.
wget http://HubIP/hub/backupDB?fileName=latest
sudo cp /home/pi/Hubitat_Backup/'backupDB?fileName=latest' /home/pi/Hubitat_Backup/$(date +%m-%d-%Y.lzf) 2> /dev/null
sudo cp /home/pi/Hubitat_Backup/'backupDB?fileName=latest.1' /home/pi/Hubitat_Backup/$(date +%m-%d-%Y.lzf) 2> /dev/null
sudo rm /home/pi/Hubitat_Backup/*backupDB?fileName=latest*
sudo rclone copy /home/pi/Hubitat_Backup/*.lzf Google_Drive:Hubitat_Backups/
sudo rclone delete Google_Drive:Hubitat_Backups --min-age 30d
sleep 1s
sudo rm /home/pi/Hubitat_Backup/*.lzf
Make sure to change "pi" to your machine's home directory
