I have posted this query in most forums I know, but have not received an answer or even guidance as to whether this is possible. I have only used VBA before so am pretty lost. My apologies if this is basic (and a bit silly).
Is it possible to automate the login to Google?
I have an Access database that users want to upload documents to.
We have Google Drive on our domain, but not with synced folders.
My idea is to give the database a Google account and everything be uploaded to a folder on its drive.
I have a URL to log the user out of Google.
When uploading, the user will have a setup option
With setup, I want the Database account to login to Google
Then display the chrome extension store.
When user okays setup as complete, Chrome will close.
I have had a look at documentation and videos of OAuth2 with Google+ but when I tried a demo, was unsuccessful.
Any comments or advice most welcome.