I believe Google Drive uses oAuth2 to get an access token using your client id and secret.
Honestly, I’ve been using the Chilkat library which has a heap of useful connections for vbscript which are fully adaptable for VBA.
www.example-code.com/vbscript/
It is a paid library $295 USD, but you get the library for use in unlimited projects and in multiple (read “every”) language. And figure it would take me ages to sort out these API calls myself in VBA.
Note: I’m in no way affiliated with Chilkat. But just found an awesome new library for working with web API calls.
Sent from my iPhone using Tapatalk