There's product called RaiDrive (
https://www.raidrive.com/) that allows you to assign a drive letter to your Google Drive, and then you can treat it 'normally' like any other mapped or local drive. There's a basic free version and a more robust paid version
I don't know if Calibre could reliably use it for a library, but I've never been that adventurous