For rsync:
It is only one way and would require running in both directions. It’s my understanding that Google drive cannot be accessed from Finder. Mountain duck is a service that lets you essentially mount cloud services as an external drive.
Other option:
I remembered looking at Transmit by Panic a couple months ago and just relooked. I found this which seems to be exactly what you’re looking for.