Google Spreadsheet Activities


#42

I will inform when a major release will come out.


#43

@Covrada


#44

Hi guys,

I know people had some struggles in the past with the installation of Google Spreadsheet Activities but I think with the new release of our platform things got better.

The easiest way to install them in 18.2 is the following:

  1. Make sure Studio’s robot is connected to an Orchestrator (v18.2)
  2. Add https://gallery.uipath.com/api/v2 as a source in Package Manager
  3. Install the package

Please let me know if you encounter troubles with this.

All the best,
Bogdan


#45

Small update. In CE the community feed is added by default starting with 18.2.


#46

Is this fixed??


#47

The dependency DLLs bug? Yes. Please see above posts.


#48

Is the issue with the range not being able to read as “”?

Warm Regards,

Pravinraj Vincent


#49

@pravinraj.vincent, that one is not yet fixed.


#50

Okay. Thank you.

Warm Regards,

Pravinraj Vincent


#51

The issue is with the includeheaders.
Instead of getting the range number parts from the input, you might need to get the row numbers and column numbers from the response values.


#52

Hello UiPath specialists.

After upgrading CE2.2, I could Install Google Spreadsheet Activities, and set up Google drive.
Then I could read Google Spreadsheet by read range successfully.
However, another problem occurered that Deserialize JSON activity doesn’t work.
After deinstall “UiPathTeam. GoogleSpeadSheet. Activities”, it works with no problem.

Do i have to wait the formal management packages of Google Speadsheet?

hsakai (3 months beginner)


#53

Hi Bogdan,

When i try to install the package i have this message.

Failed%20Install

In the "AppData\Local\NuGet\Cache, there is this file “Google.Apis.1.10.0.nupkg” .
Even, i delete this file and try to re-install, i have the same message and the same file download.

Can you help me ?
Many thanks


#54

How to set a Range of Read Activity in GoogleSpreadsheet?

I mean to read all the data normally we set it to blank or “A1”. But here we have to set the range in a format of “A1:C3”.
Is there any way to get all the data without defining a specific range?


#55

Hi I am getting the same kind of error. I have downloaded the p12 key,password but still no fix


#56

I downloaded p12, updated its path,entered the used ID of the service account and the password ( the passkey given to authenticate p12), entered the sheet id and i am getting the below error,.

Main has thrown an exception

Source: Google sheet application scope

Message: Could not load type ‘Initializer’ from assembly ‘Google.Apis.Auth, Version=1.13.1.0, Culture=neutral, PublicKeyToken=4b01fa6e34db77ab’.

Exception Type: TypeLoadException

System.TypeLoadException: Could not load type ‘Initializer’ from assembly ‘Google.Apis.Auth, Version=1.13.1.0, Culture=neutral, PublicKeyToken=4b01fa6e34db77ab’.
at GoogleSpreadsheet.Activities.GoogleSheetApplicationScope.Execute(NativeActivityContext context)
at System.Activities.NativeActivity.InternalExecute(ActivityInstance instance, ActivityExecutor executor, BookmarkManager bookmarkManager)
at System.Activities.ActivityInstance.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager)
at System.Activities.Runtime.ActivityExecutor.ExecuteActivityWorkItem.ExecuteBody(ActivityExecutor executor, BookmarkManager bookmarkManager, Location resultLocation)


#59

My Google Drive Scope works fine with listing files in a given folder. However, I want to delete all of the files in this folder after processing, Each time I hit the delete file activity I receive:

An error has occured

Source: Newtonsoft.Json

Message: ISerializable type ‘Google.GoogleApiException’ does not have a valid constructor. To correctly implement ISerializable a constructor that takes SerializationInfo and StreamingContext parameters should be present. Path ‘Error’, line 1, position 1499.

Exception Type: JsonSerializationException

Newtonsoft.Json.JsonSerializationException: ISerializable type ‘Google.GoogleApiException’ does not have a valid constructor. To correctly implement ISerializable a constructor that takes SerializationInfo and StreamingContext parameters should be present. Path ‘Error’, line 1, position 1499.
_ at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.CreateISerializable(JsonReader reader, JsonISerializableContract contract, JsonProperty member, String id)_
_ at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.CreateObject(JsonReader reader, Type objectType, JsonContract contract, JsonProperty member, JsonContainerContract containerContract, JsonProperty containerMember, Object existingValue)_
_ at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.CreateValueInternal(JsonReader reader, Type objectType, JsonContract contract, JsonProperty member, JsonContainerContract containerContract, JsonProperty containerMember, Object existingValue)_
_ at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.SetPropertyValue(JsonProperty property, JsonConverter propertyConverter, JsonContainerContract containerContract, JsonProperty containerProperty, JsonReader reader, Object target)_
_ at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.PopulateObject(Object newObject, JsonReader reader, JsonObjectContract contract, JsonProperty member, String id)_
_ at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.CreateObject(JsonReader reader, Type objectType, JsonContract contract, JsonProperty member, JsonContainerContract containerContract, JsonProperty containerMember, Object existingValue)_
_ at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.CreateValueInternal(JsonReader reader, Type objectType, JsonContract contract, JsonProperty member, JsonContainerContract containerContract, JsonProperty containerMember, Object existingValue)_
_ at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.Deserialize(JsonReader reader, Type objectType, Boolean checkAdditionalContent)_
_ at Newtonsoft.Json.JsonSerializer.DeserializeInternal(JsonReader reader, Type objectType)_
_ at Newtonsoft.Json.JsonConvert.DeserializeObject(String value, Type type, JsonSerializerSettings settings)_
_ at Newtonsoft.Json.JsonConvert.DeserializeObject[T](String value, JsonSerializerSettings settings)_
_ at UiPath.Shared.JsonParser.DeserializeObject[T](String jsonValue)_
_ at UiPath.Models.UiPathDuplexProxy.<>c__DisplayClass18_0.b__0()_
_ at System.Threading.Tasks.Task.InnerInvoke()_
_ at System.Threading.Tasks.Task.Execute()_


#61

hi, I try to run Google Spreadsheeet Activities, and error like this.


Main has thrown an exception

Source: Google sheet application scope

Message: 要求されたオブジェクトが見つかりません。

Exception Type: CryptographicException

System.Security.Cryptography.CryptographicException: 要求されたオブジェクトが見つかりません。

at System.Security.Cryptography.CryptographicException.ThrowCryptographicException(Int32 hr)
at System.Security.Cryptography.X509Certificates.X509Utils._QueryCertFileType(String fileName)
at System.Security.Cryptography.X509Certificates.X509Certificate.LoadCertificateFromFile(String fileName, Object password, X509KeyStorageFlags keyStorageFlags)
at System.Security.Cryptography.X509Certificates.X509Certificate2…ctor(String fileName, String password, X509KeyStorageFlags keyStorageFlags)
at GoogleSpreadsheet.Activities.GoogleSheetApplicationScope.Execute(NativeActivityContext context)
at System.Activities.NativeActivity.InternalExecute(ActivityInstance instance, ActivityExecutor executor, BookmarkManager bookmarkManager)
at System.Activities.ActivityInstance.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager)
at System.Activities.Runtime.ActivityExecutor.ExecuteActivityWorkItem.ExecuteBody(ActivityExecutor executor, BookmarkManager bookmarkManager, Location resultLocation)

Keypath set that OAuth2.0 clientID JSON file by Developper console.
https://console.developers.google.com/flows/enableapi?apiid=sheets.googleapis.com

Is this keypath method misunderstanding?

Could everyone advice me?
Many thanks


#62

Hi Sir,

Can i use my personal gmail account or Do i need to have Google Service account to use.

Thanks
Anil Kumar


#63

Hi Ui Specialists,

Just want to ask, where can I see the End-User Agreement License(or the like) of this particular API. I need to pre-approve this before I can install. Also, can someone walk me through its capabilities. :slight_smile:

Thanks,
Homer


#64

Hi @homerivera,

For now we have this bellow doc page which applies to our artifacts that are in the UiPath GO platform, including the one this topic refers to.

https://go.uipath.com/terms-and-conditions

Thank you,
Bogdan Popescu