Donwload Google Sheets

[PABLOPEREZ-ENCI]

I would like to download a Google Sheet, I am using BP V6.4

I am using the user interface with Chrome and link of the Google Sheet, but Chrome asks for "user", "password" and a captcha is appearing.

What is the best approach to automate Google Sheets functionalities using Blue Prism without using UI?

Is there a more convenient means to replicate the functionalities provided by Ms Excel VBO in Blue Prism to Google Sheets?

Thanks

------------------------------
Pablo
------------------------------

[vivek.kumar.goel · Accepted solution]

Many Ways:

1 - Ui Method:
 Create a reusable workflow to open the Google sheet in incognito/InPrivate mode of IE and download the sheet .
Once downloaded, use MS EXCEL VBO to do whatever you want.
Once done, reupload the sheet with replace option so that the ID remains same.

2- API Method:

Use the google sheet API to provided by Google
https://developers.google.com/sheets/api

------------------------------
Vivek Goel
RPA Architect
Asia/Singapore
+6594554364
https://www.rpatools.com/
------------------------------

[DivyaB]

How to use API?

------------------------------
Divya B
AC
Capgemini
Asia/Kolkata
------------------------------

[vivek.kumar.goel]

Basic Steps include:

1- Create a key in google developer console for usage of the API (Google sheets in your case).
2- Configure a restful API in Blue Prism as per the guide.
https://portal.blueprism.com/system/files/documents/v6.4%20User%20Guide%20-%20Web%20APIs_2.pdf
3- Use it.

------------------------------
Vivek Goel
RPA Architect
Asia/Singapore
https://www.rpatools.com/
"If you like this post, please press the "Recommend" Button.
------------------------------