https://community.blueprism.com/t5/Digital-Exchange/Google-Sheets-API-Practicality/m-p/117583#M4071 <P>I guess these details you can get from the Google Sheets detailed API documentation.</P><P>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.</P> Fri, 13 Dec 2024 11:53:28 GMT Tejaskumar_Darji 2024-12-13T11:53:28Z https://community.blueprism.com/t5/Digital-Exchange/Google-Sheets-API-Practicality/m-p/117269#M4054 <P>Hello.&nbsp; 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.&nbsp; I have a few questions that will help identify whether it makes sense to adopt this tool, however.</P><P>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?&nbsp; Domain wide auth is not an option, as it is a substantial security risk.</P><P>2. If the manual authentication is not complete, the code stage will stall out infinitely.&nbsp; Can I throw an exception on timeout without re-writing the code stages?</P><P>3. Can a single google account work across multiple Blue Prism VMs, or does each bot require it's own account?</P> Mon, 02 Dec 2024 13:37:35 GMT https://community.blueprism.com/t5/Digital-Exchange/Google-Sheets-API-Practicality/m-p/117269#M4054 KirstenA 2024-12-02T13:37:35Z https://community.blueprism.com/t5/Digital-Exchange/Google-Sheets-API-Practicality/m-p/117583#M4071 <P>I guess these details you can get from the Google Sheets detailed API documentation.</P><P>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.</P> Fri, 13 Dec 2024 11:53:28 GMT https://community.blueprism.com/t5/Digital-Exchange/Google-Sheets-API-Practicality/m-p/117583#M4071 Tejaskumar_Darji 2024-12-13T11:53:28Z