I was thinking of kinda the same. You can try Automate, I’ve been using it to create automated backups of a floppy disk image I was using to store savegames of some of my Win95 games (because fdd images are small and can be quickly synced). It’s dead useful, similar to Tasker, but with a flowchart UI to set things up more comfortably.
To get you started quickly, here’s my Automate flow (make sure to change sdcard and Google Drive settings to match yours).
You can duplicate a working flow, so you’ve got one for each game. Instead of monitoring a single fdd image, you might want to monitor the game’s save folder instead, but apart from that, my flow file should do the trick.