製品

Studio

Studio Web

StudioX

Automation Ops

Document Understanding

検索

サインイン

製品

Document Understanding

検索

Google Workspace

はじめてのオートメーションをわずか数分で作成できます。Studio Web を試す →

Google Workspace

作成者: UiPath

アクティビティ

72.4k

Antonio Guijarro Blanco

5 years 前に投稿

Hello Miahi,

Is it possible to add a new row in SpreadSheet? I have tried reading the sheet, adding a new row at first position in the DT, clearing the sheet and finally writting the new DT in the same sheet, but the problem is that I lose all the formulas... Is it be possible with any of your activities?

Thank you :)

Mihai Dunareanu

5 years ago 前に投稿

Hi Antonio,

It is possible using the 'Add Delete Rows' activity.

Piotr Jagiellowicz

5 years 前に投稿

Hi,

I am running Gsuite as Background Process. I am pulling MessageId of an available GmailMessage. Works fine (send to Queue as identyficator) , but I can't find a way to use this MessageId to filter it later on in Get Mail Message.

I tried to use Google's docs, but I found that this MessageId only works as an Id search in HTTPS request, which would add next layer of complexity.

I believe the Activity should provide Message-ID, which can be pulled from Original Source of the mail.

Can you please look at it? Or maybe I am missing something obvious

Mihai Dunareanu

5 years ago 前に投稿

Hi Pitor,

You can use the rfc822msgid tag to search for messages with a given id. Read more here: https://support.google.com/mail/answer/7190?hl=en

Roman Spantgar

5 years 前に投稿

Hi Mihai,

Are there any plans to include the admin side of GSuite? Things like management of devices, domain/user settings, etc.

Staying on topic: are there plans to support shared drives? (user management, settings, etc.)

Mihai Dunareanu

5 years ago 前に投稿

Hi Roman,

There are no plan currently, but you can influce this decision with the product managers through the forum or the productboard.

Matthieu Rotaru

5 years 前に投稿

Hello Mihai,

I'm trying to use the activities for Google AppsScript, but, they never appear on my studio (version 2019.4.4). Do you know what could be the issue ?

Thank you !

Mihai Dunareanu

5 years ago 前に投稿

Hi Matthieu,

This is really strange/should not be happening. I am unable to replicate the issue, nor has it been reported elsewhere, so i am not sure how to help you. If this persists, make a forum post so we can discuss this further.

Bogdan Savescu

5 years 前に投稿

Hi Mihai,

We have 2 processes where we are using this package to read, move and send mails.

We are using OAuth (ClientID + ClientSecret) as authorization method.

The encountered issue is that, once in a while (one or two weeks), our processes are blocked while are waiting for a response from Get Mail Messages activity.

Both processes have this configuration:

ContinueOnError - False

LabelFilter - Inbox

MaxResults - 10000 (our processes will move processed mails in other labels so this value (10000) is higher then we need; in inbox we have around 200-300 mails)

SearchExpression: "to:" + in_strEmail + " has:attachment"

We are currently using 1.4.2 version of this package.

There is a chance that an upgrade to 1.5.0/1.5.1 to solve our issue?

If not, can you please give us more details about this problem? There is an internal timeout for getting mails from gmail?

Thanks in advance,

Bogdan

Mihai Dunareanu

5 years ago 前に投稿

Hi Bogdan,

I am not entirely sure what would cause this issue. Upgrading to 1.5.0/1.5.1 would not help in regards to this error.

There is no implicit timeout on this activity, as the http client should throw should an error occour. Also, there is no telling how much time it would take to download all of the emails considering variable bandwidth and so forth, so setting a timeout is not reeally reasonable.

The get operation stops either when the count has been reached or when there are no more emails matching your search criteria.

That said, i find the approach you are taking kind of strange. I mean, you are basically getting all of the emails in a single go, which is not really reasonable.

For example, if each email is 4 mb and there are actually 10 000 of them then memory wise you end up using 40gb of memory.

In my oppinion you should deffinetly reconfigure your process. It's quite easy for example to fetch 100/200/500 emails per process run and just run the process one or more times.

Similarly, if you want to run the process once, you can simply call a workflow that does what i wrote above x times, achieving the same effect.

That being said, the process should not hang no matter the circumstances, and this is the first time i have heard about this error. Without further information, however, i can't really help.

Kevin Schenk

5 years 前に投稿

Hello Mihai!,

Once again thank you for all of your work on this project, i have a question.

Is there a way to insert conditional formatting on a range in a sheet? If not, are there plans for this feature?

Mihai Dunareanu

5 years ago 前に投稿

Hi Kevin,

I am not sure adding support for conditional formatting through an activity is the right way to go, simply because of the large number of options one would have to present in the activity designer.

This does not mean we won't do it, it's just not high in our list right now.

On the other hand, there is an easy way for you to do this. Version 1.5.0 added support for AppScripts, which are basically the equivalent of Excel macros. You can create a script, attach it to the document you will want to run the script on, and then running said script. Here is some documentation on how to do what you want using app scripts:

https://developers.google.com/apps-script/reference/spreadsheet/conditional-format-rule-builder

Raj Parsana

5 years 前に投稿

Hello Mihai,

How to move mails from folder to folder??

Mihai Dunareanu

5 years ago 前に投稿

Hi Raj,

Folders are called labels in gmail, so you can use the Change Labels activity to move things, and even mark them read/unread or send them to trash.

Balaraman TCS (Bala)

5 years 前に投稿

Is there a way to check the attendee's is free or busy for specific time slot? I do not see search event activity will help here.

Assuming the Gmail is used as Enterprise mail system. Service account provided access to read all calendars.

Would see this is a good option to create the activity to check the attendees slot free or busy.

Regards,

Balram

Mihai Dunareanu

5 years ago 前に投稿

Hi! This activity is on the roadmap!

Tomasz Kolodziejczyk

5 years 前に投稿

Hi Mihai,

thanks for the latest versions and for including ClearRange !

Another issue we are running into regularly with Google Sheets is reaching the Row limit of the Sheet. In Google Sheets tabs are created with 1000 rows by default. We use ReadColumn to find the last non-empty row and then we use WriteRange to add data at the end of the Sheet. However, when the row limit is reached the API throws an error instead of adding lines at the end of the file.

Do you have any ideas on how to best handle this case ? Is there any way we can add a number of empty rows with a single API call from UiPath (AddRow may not be viable due to the API quotas)?

Thanks in advance and keep up the great work !

Tomasz

Mihai Dunareanu

5 years ago 前に投稿

Hi Tomasz,

The add new sheet activity has an option of specifing a varying number of rows and columns.

However, your suggestion is good for use cases where you don't create the sheet, so it's probably a good addition in the next release.

Søren Præst

5 years 前に投稿

Hej Mihai

I have a problem:) I have two different processes, one that only use google sheet, and one that use both drive and google sheet, but the problem. When I run the first then a authentication Token Window popup, and then I authenticate, but when I run the other process I have to authenticate again. With other words I have to authenticate all the time.

What can I do?

Mihai Dunareanu

5 years ago 前に投稿

Hi Søren,

The easiest thing to do is to enable both scopes (drives and sheets) in both processes. This means you will only authenticate once for both of them.

Another option is to set a different value in the User field for one or both processes. Setting a value here means a token response file is saved for client_id/user combination. You will authenticate twice, but only the first time!

The user field is meant to allow using multiple google accounts on the same computer, so taking this route means a little cheating, but it does acomplish your purpose!

Domingo Valdés

5 years 前に投稿

Hi Mihai, Is it available to work in spanish?

Mihai Dunareanu

5 years ago 前に投稿

Hi Domingo,

It is available in all languages Studio is localized in, which inludes spanish!

Tomasz KOLODZIEJCZYK

5 years 前に投稿

Hello Mihai, we are using your GSuite package in all of our robots, thanks so much!

I was wondering whether it would be possible to get an activity for Google Sheets to clear cell content without actually deleting the cells ? The use case is to clear cell values while keeping the format / data validation rules etc.

In the API this would correspond to the spreadsheets.values.clear method.

Thanks in advance,

Tomasz

Mihai Dunareanu

5 years ago 前に投稿

Sounds reasonable. I've created an issue for it, next release you will have it!