Facing annoying error while reading form excel from Google Drive

Help
1

Hello Guys,

I am newbie in the field of automation and with this new experience I chooses UIPath studio.
So here my task is Read xls from Google drive for that I took some help from https://forum.uipath.com/t/google-spreadsheet-activities/14473 blog.

Following are my step that I took till now…

  1. Created Service account in my google drive
  2. Created one key in the format of .p12 and downloaded
  3. Mentioned this key path, password, Service account email and excel sheet id in UIPath in Google Sheet application scope.
  4. Drop the readRange activity in again Google Sheet application scope
  5. in readRange activity mentioned range like “A1:G5”
  6. than run (Excel sheet has an public access)

After run it gives me the following error. Not sure what this error.
Could some help me to solve this problem and suggest me any blog/tutorial to achieve the same task.

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

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 1268.
** 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()**

2

I’m having the same issue. Did you resolve this? Thanks!