Real-time,structured inputs to BOTs using Google spreadsheets


#1

What is the use case

We often come across situations where processes require real time inputs from one or more data sources leading to manual dependencies. Conventionally such scenarios are dealt with by attended BOTs or a relational database. However an easier way to deal with would be to have a google spreadsheet tracker which acts as a live database which can be updated in real time.

How do you see a solution for the use case?

A connector for google spread sheet and set of preloaded custom activities such as read cell,write cell,read range, write range can serve the purpose. We can build such activity using Google spreadsheets API.

Scope: __Custom Activity Data Connector

  • Custom Activity
  • Reusable Component
  • Template
  • Automation Framework
  • Application Connector
  • Data Connector
  • RPA Documentation
  • Machine learning model
  • Dashboard

#2

I would like to share my approach, however, UiPath activities would be more than welcome.

Me personally, I use R software to manipulate (download to xls or to edit googlesheet or to only read value from googlesheet cell and more), there is package googlesheets. I create my custom script, UiPath is then writing function with parameters to R GUI.


ftp://cran.r-project.org/pub/R/web/packages/googlesheets/googlesheets.pdf
https://cran.r-project.org/web/packages/googlesheets/vignettes/basic-usage.html
https://www.rdocumentation.org/packages/googlesheets/versions/0.2.0

I hope this helps.