Blue Prism Product

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?

    Thanks


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


  • 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
    https://developers.google.com/sheets/api

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



  • 3.  RE: Donwload Google Sheets

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

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



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