Blue Prism University

last person joined: 18 hours ago 

A Community to discuss and learn more about Blue Prism University and certification.

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



Welcome to the Blue Prism University Community

This is a space for our users to discuss and learn more about Blue Prism University and certifications. Click the "Join" button above to be alerted to new activity and events happening in this community!

This is not the appropriate place for product questions. Do you have questions about the Blue Prism Product, Decipher, Digital Exchange, or another Blue Prism offering? Check out our list of Tech Chat Communities to find the right place for your discussion.

Foundation TrainingPearson Vue UpdatesBook an Exam

Course: Introduction to Capture

More Info