Blue Prism University

Expand all | Collapse all

Donwload Google Sheets

Jump to Best Answer
  • 1.  Donwload Google Sheets

    Posted 11-20-2019 21:00

    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?



  • 2.  RE: Donwload Google Sheets
    Best Answer

    Posted 11-21-2019 03:34
    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

    Vivek Goel
    RPA Architect

  • 3.  RE: Donwload Google Sheets

    Posted 12-11-2019 10:38
    How to use API?

    Divya B

  • 4.  RE: Donwload Google Sheets

    Posted 12-12-2019 01:55
    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.
    3- Use it.

    Vivek Goel
    RPA Architect
    "If you like this post, please press the "Recommend" Button.