topic RE: Donwload Google Sheets in Product Forum

Donwload Google Sheets

PABLOPEREZ-ENCI — Wed, 20 Nov 2019 21:00:00 GMT

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
------------------------------

RE: Donwload Google Sheets

vivek.kumar.goel — Thu, 21 Nov 2019 03:34:00 GMT

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/
------------------------------

RE: Donwload Google Sheets

DivyaB — Wed, 11 Dec 2019 10:38:00 GMT

How to use API?

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

RE: Donwload Google Sheets

vivek.kumar.goel — Thu, 12 Dec 2019 01:55:00 GMT

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.
------------------------------