Google Workspace

Hi yuuka,

I do not really understand what you mean by your usecase. Perhaps you can send me further information via the private message function, and we can arrange a call to look into your usecase. I am sorry i do not have more for you, and hope we can continue the conversation another way. 

Also, please accept my appologies for the late reply!

Hi, Karen

The latest version is 1.3.1, which can be downloaded from the official feed. I will update the version here to the latest as well. As for your error, please pose another question with the contents of the exception if you want help!

Hi Flamen,

Indeed the behavior you mention is currently known. Let me explain:

Google does not allow downloading native cloud files, like google docs, sheets, presentation and so forth. The only way to download these is to call an api that exports said file to a downloadable file type. Now, for each type of file you can choose what format to export to. What is common between them is the pdf format, which is available for all file types.

We have not currently implemented the export functionality, and that is why when doing download on a google cloud file it will be converted to the only common type for all files, which is pdf.

We will implement the export functionality as well, but I cannot currently give you a timeline!

Hi Sandeep,

This is a matter of some debate, but following Microsoft's official recommendation (https://docs.microsoft.com/en-us/dotnet/api/system.security.securestring?view=netframework-4.8) one should not use SecureString for new implementations.

You can transform a secure string to string with this one-liner:

string password = new System.Net.NetworkCredential(string.Empty, securePassword).Password;

Hi Nishitha,

I do not understand the question, so please rephrase it in more detail. Thanks!

Hi,

The spreadsheetid is unique for each google sheet document. This means you will have to find the sheet you are looking for.

Use the Find Files and Folders activity to find the ID of the sheet document you want. Press F1 with the activity selected to see how to find files from Google's own official documentation.

Hi William,

This is possible according to https://developers.google.com/gmail/api/guides/delegate_settings

According to the article you must use a service account with domain wide authority enabled. See the article on how to configure it server side: https://developers.google.com/identity/protocols/OAuth2ServiceAccount#delegatingauthority

Hi Cornel,

I can think of either of tho things:

This could be due to the running robot not having access to the feed that contains the UiPath.GSuite package. This is either the official or the Go feed. If the robot does not have access to a nuget repository with access to the dependencies it will not be able to load them and hence throw the error above. Make sure you can open the project on the running robot manually, just to see if dependencies will be fetched.

You could have a corrupted project.json file.

Hope it helps!

Hi Luis,

The object returned from a GetMailMessages activity is a GmailMessage object which inherits from System.Net.MailMessage.

The MessageId and ThreadId members do return the correct MessageId/ThreadId which corresponds to these fields in the original message object.

"id": string,   "threadId": string,

https://developers.google.com/gmail/api/v1/reference/users/messages#resource

Please try to validate this on your end again, as we have tested this and found no problem.

Hope this helps!

Hi,

If you are going to use the Api Key, you can only READ public documents. So it's not very useful for most use cases which require safer login methods for allowing writing data.

I recommend you move to OAuthClientId or Service Account.

Go through the steps in the documentation to generate the credentials.

Hi Deyan,

The UiPath.GSuite package is available on the official feed, which is located at https://www.myget.org/F/workflow

It's dependencies (the google SDK) can all be downloaded from https://api.nuget.org/v3/index.json

So if you have both feeds on the machine you are trying to run. everything will be fine.

Hope it helps!

Hi Tomasz,

It is very easy for me to add an output with the access token to the Scope's output, but i have already had this discussion with our Product Manager and decided we would not do it for security concerns.

I am sorry i cannot help! :(