Forum Discussion
Yes the checkbox is enabled.
When you click Authorize you are redirected to a different browser and on that you should’ve been prompted the drive access.
Also Make sure you have drive API Access enabled too on the App.
- marenas5 years agoContributor
Yes, I also enabled the drive API access and authorize the Google account when I click authorize. see below snapshots:
- aleung3 years agoContributor III
Were you able to make this work? If so, can you share what you learn?
- marenas3 years agoContributor
Hi!
Apologize for the delayed response.
Yes, I was able to make this work.
First, set up a Google Service account (it is an AD account with a mailbox attached to it), other team helped us with this part.
Next, I created the Account in SnapLogic of type “Spreadsheet OAuth2 Account”
When you click, “Authorize”, you will be prompted to sign in using the Google Service account.
In Designer, I use the snap “Worksheet Reader” and use the account “Spreadsheet OAuth2 Account”. In the document/spreadsheet that you are going to read data from, please make sure to share that with your Google Service Account.
I hope this helps.