Sign In
Create your first automation in just a few minutes.Try Studio Web →
Google GSuite
by YouTube
7
Activity
2.6k
hi,Mihai
I using a component you made. google gsuite
I want to get Gmail in Studio X, but i can't use. because it doesn't Correspondence it.
Is there any other way?or i waiting your update?
Yes there is a correspendance to it, in the package Mail version 1.9.1-preview you have the ability to use a Gmail account card!
I want to use App Scripts activities from GSuite. I have been able to use all the activities, but I am facing problem with run script activity. I am not able to execute the script from UiPath Studio.
Steps followed
- Created a Project - Using Create Script Project Activity
- Uploaded the Script file “*.gs” - using Upload Script File Activity
- Deployed the script - using Create Deployment activity
- Run the Script - using Run Script Activity
Steps 1 to 3 are running fine and i have also checked in my google projects, the projects are being created. but only the last step is always giving me an error. I can run the same uploaded script manually from the google project page (https://script.google.com/) here's the link to the forum topic that i have started
Hi botBotGo,
The answer is the same as i have given you previously. Look at https://developers.google.com/apps-script/api/how-tos/execute and "Ensure that the script and the calling application share a common Cloud Platform (GCP) project".
Unfortunately this is a manual step, which we are not able to automate.
hello Mihai,
I am presently facing issue with using the Google App script activities. All the activities seem to be running but i am some how not able to use the run script.
I always get an error
Run script: Google.Apis.Requests.RequestError
Requested entity was not found. [404]
Errors [
Message[Requested entity was not found.] Location[ - ] Reason[notFound] Domain[global]
]
I am able to run the the script manually from google platform but not through UiPath.
Hi botBotGo,
The issue you are facing is due to the fact that running a script requires some manual steps that cannot be automated (in any way shape or form).
More precisely, we are talking about point 3 on this article ("Ensure that the script and the calling application share a common Cloud Platform (GCP) project")
https://developers.google.com/apps-script/api/how-tos/execute
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 :)
Hi Antonio,
It is possible using the 'Add Delete Rows' activity.
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
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
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.)
Hi Roman,
There are no plan currently, but you can influce this decision with the product managers through the forum or the productboard.
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 !
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.
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
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.
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?
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
Hello Mihai,
How to move mails from folder to folder??
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.
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
Hi! This activity is on the roadmap!
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
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.
Technical
Version
1.5.1Updated
November 24, 2023Works with
Studio: 22.10.2+
Certification
Silver Certified
Application
Support
Link: https://www.uipath.com/company/contact-us/contact-technical-supportUiPath Standard Support, see your Service Agreement
Resources
