Google Workspace

Hi Debashish,

The user field is used in the storage of the Token Response object. You can write the name of the user or a unique identifier for a particular user who is going to log in. For example, a single set of Credential Id/Credential secret can be used by multiple users of the same organisation. If you want a robot to remember both users (say their names are John A and Martin B) such that the consent screen is not displayed, set two unique strings in the user field and switch between them as needed. The strings can reflect their names (like 'johna' or 'martinb') or can simply be '1' and '2', as long as you remember that 1 is John and 2 is Martin!

Regarding the activity stopping after you have clicked the consent screen, we've never encountered this so i need more info to help.

Hi Shaun,

First of all, sorry for the late reply! I have tested the Read Cell activity as well as asked our QA team to test it, and we cannot replicate the behaviour you are getting.

In our test, we read a cell that was the result of a formula using other cells (one example is A1:A16 have values and A17 = SUM(A1:A16)). When we read cell on A17 it correctly returns the value calculated by the SUM formula.

I have no idea how i can help further, since we are unable to replicate the issue, but if you still have not been able to solve it drop me an email and we can take this to a private channel!

Best regards, Mihai

The 'Range' and the 'SheetName properties taken together form the A1 notation, which is also used by Microsoft Excel. So the answer is that yes, you have the same functionalities as in the Excel activities.

Read the A1 notation heading to understand more, it's very flexible (you need to scroll to A1 notation):

https://developers.google.com/sheets/api/guides/concepts

Hi Natalia,

This is the official page for the search parameters: https://developers.google.com/drive/api/v3/search-files

The name parameters in the search do work, so my suspicion is that you did not use the recommended '' to enclose the values of the parameters. So, to search for all the files matching two name patterns, you can do name contains 'hello' and name contains 'goodbye'

You can combine the parameters in complex ways:

'1234567' in parents and name contains 'hello'

Hi William,

The documentation for each activity is available if you press F1 while having said activity selected.

Here is a link from the about page, where you can learn about setting up your account on the server side:

https://activities.uipath.com/docs/about-google-gsuite-activities

Hope that helps!

Hi James,

The activities inside the scope function asynchronously and what is probably happening is that the attachment file is still locked for some time since the release is async too.

A solution is to create a workflow with a try catch block that catches io exceptions, and if the file is locked you can wait some time and then retry the same workflow again. You can even make the retry count variable.

I am going to look at the code just to make sure it's ok, but the above solution should work perfectly!

Duplicate question

Hi Gaurav,

The next update with focus on sheets, aiming to bring it more in line with the features we have in the UiPath.Excel.Activities package. This means formulas, range operations, copy operations, row and column operations.

Hi Valentin,

This is actually normal behaviour. Think of the service account as a role more than as a user. In any case, even if it were a user, it would not be "your" user. If you use the Find Files and Folders activity you will see it has his own drive.

So if you do decide to use a service account you will have to share files/folder with it to grant it access to whatever you want to modify.

More information and helpful links explaining account types here: https://integrations.uipath.com/docs/google-suite-about

Hi Anurag,

Here is the link to the search events documentation: https://integrations.uipath.com/docs/search-events

As you can see, if you enter nothing in the CalendarID input field, your own calendar (anurag.srivastava@examplecompany.org) will be used. If you want to use another calendar input it in that field (robots@examplecompany.org)

Then you can read the event metadata and run a start job on the robot matching the criteria you imposed on the event details.

Hope i have understood the question correctly, good luck!

Hi Fatih,

For the full answer, see the forum thread you opened.

In short, you cannot use Gmail with a service account. Use OAuth2 Client Id Authentication and it will work!

Hi Fatih,

The Service account is a role, and as such will appear to have only one file in it's drive, getting started.pdf

If you think about it, think makes sense, since the service account is not the OAuth2 user you personally use to work on files.

Now, this only means that, even though the service account is part of the organisation, the files are not shared with it.

The solution is to use the permissions activities and shared the file with write access to the service account.