I only do manual backups, but I'm the kind of person who does it multiple times a day anyway - whenever I do a major edit on a work or hobby file - just for my peace of mind :)

And yes, only "airlocked" backups. I manually use FreeFileSync to mirror my files to a local backup folder on another HDD (I have multiple paired folders set up inside that, so FFS doesn't have to check tens of thousands of other files if I only edited a particular project that day), and keep only that synced to Google Drive. So if either the active local copy or Google Drive is corrupted or lost, the file is not automatically lost on the other end. I also found it a neat surprise that Google Drive retains past versions of files, it came handy a few times.