I have been reading a number of posts across the Forum on how to use Google sheets and Google drive in UiPath and for these, there are dedicated activities that have been created which makes using them relatively simple to use, however, the functions available in them are limited.
I would really benefit from understanding how I could use, for example: https://developers.google.com/apis-explorer/#search/sheets/m/sheets/v4/sheets.spreadsheets.values.clear
In the context of UiPath how would I call this? Via the HTTP Request activity or is it done via importing the Google APIs Client Library and then invoke them somehow? I have heard some developers use Python to call these API methods but I don’t know if there is a simple straight forward way to do this?
Your help and experience would be greatly appreciated and I am hoping there is a best practise approach to this or one that is commonly recognised as the ‘right’ way of doing it?