Connector for Google spreadsheets

activities
connection

#1

What is the use case

There are few projects where the user does not use Microsoft Excel instead they use Google Spreadsheet only. It is very difficult to automate tasks which involve interaction with google spreadsheet.

How do you see a solution for the use case?

There should be a connector or package of activities which can perform similar actions which are available for Microsoft Excel.

For Example:
Get Table Range
Append Range
Execute Macro
Read Cell
Read Range
Write Cell
Write Range
Read Cell formula

Scope: ______________

  • Custom Activity
  • Reusable Component
  • Application Connector
  • Data Connector

#2

Like this?


#3

Yes, something like this. Although I am not able to configure it, hence dindnt know how it functions, but i am expecting similiar functionality in activity pannel.


#4

That’s a nice idea. I really need that.


#5

Why aren’t you able to configure it?


#6

Not sure, Maybe it’s because of some kind of dependencies. Even though the error is resolved, This will be like a patchwork, I strongly feel that there should be a concrete and stable solution for this, and similar package should come by default with the studio.


#7

Could you restart Studio and try again?

Use https://gallery.uipath.com/api/v2 as source.


#8

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.