cancel
Showing results for 
Search instead for 
Did you mean: 

Google Sheets API Practicality

KirstenA
Level 3

Hello.  I am evaluating the Google Sheets API, and have managed to use the Blue Prism Object to validate that I can interact with Google successfully.  I have a few questions that will help identify whether it makes sense to adopt this tool, however.

1. If my google user policy indicates that a user must authenticate weekly, does that mean that I have to also prepare automations to complete the chrome browser confirm authentication steps?  Domain wide auth is not an option, as it is a substantial security risk.

2. If the manual authentication is not complete, the code stage will stall out infinitely.  Can I throw an exception on timeout without re-writing the code stages?

3. Can a single google account work across multiple Blue Prism VMs, or does each bot require it's own account?

1 REPLY 1

I guess these details you can get from the Google Sheets detailed API documentation.

If you are using API you don't need a browser and UI for the authentication, right? From the API key itself, you can validate and make the API calls.