We were founded in 2005 in a tiny apartment in Bucharest, Romania as DeskOver.

Fittingly, it was a customer who, in 2012, first saw the immense possibilities for us in the fledgling RPA market. Our desktop automation product launched in 2013. In 2015, we introduced our enterprise platform along with our new name.

Today, UiPath is the fastest-growing enterprise software company in history with scores of offices, thousands of employees, partnerships with the world’s best consulting and BPO firms, a 500,000-strong developer community, and 5MM+ robots at work in over 5,000 global enterprises.

Our mission is to deliver the leading Robotic Process Automation platform to our clients for an automation first mindset.

We build software robots that automate repetitive processes. Our software robots take on the tedious, mind-numbing work and free people to do the more stimulating, creative work worth doing.

But no matter how much we’ve grown, one thing hasn’t changed. We’re still building a company we love to work for

Supercharge your productivity with a robot that can collaborate on documents, spreadsheets, access stored files, and read emails all within Google Cloud.This activity set is now on the official feed within UiPath Studio and is fully supported for Enterprise users. It contains 53 components:

GSuite Application Scope (API Key, Service Account, OAuth)

Click here for documentation on the activities.

This set of activities will help you interact with Google Calendar, Docs, Drive, Sheets, Gmail and Apps Script

Google Cloud内に含まれるドキュメント、スプレッドシート、保存されたファイルへのアクセス、メールの読み取りすべてにおいて連携できるロボットで生産性を大幅に向上させます。

このアクティビティは現在、UiPath Studio内の公式フィードにあり、エンタープライズユーザー向けに完全にサポートされています。
以下、48個のコンポーネントが含まれます。

Google カレンダー
- 参加者を追加
- 予定を作成
- 予定を削除
- 予定を変更
- 予定を検索*Google ドキュメント*
- ドキュメントのバッチ更新スコープ
- ドキュメントを作成
- ドキュメントを取得
- テキストインデックスを取得
- テキストを挿入
- すべてのテキストを読み込み *** NEW ***
- テキストを置換

Google ドライブ
- ファイルやフォルダーを探す
- ファイルをコピー
- ファイルを削除
- ファイルを移動
- フォルダーを作成
- ファイルをダウンロード
- ファイルをアップロード
- ファイル情報を取得
- ファイルアクセス許可を作成
- ファイルアクセス許可を削除
- ファイルアクセス許可を取得
- ファイルアクセス許可を更新

Gmail
- メールメッセージを取得
- メールメッセージを送信
- ラベルを変更*Google スプレッドシート*
- 行を追加または削除
- 列を追加または削除
- 行を追加
- 範囲をオートフィル
- 値のバッチ更新スコープ
- 範囲をコピー/貼り付け
- シートをコピー
- 新しいスプレッドシートを作成
- 新しいシートを追加
- 範囲を削除
- シートを削除
- セルの色を取得
- シートを取得
- セルを読み込み
- 列を読み込み
- 行を読み込み
- 範囲を読み込み
- シート名を変更
- セルに書き込み
- 範囲に書き込み

Authentication
- GSuite アプリケーションスコープ (API Key, Service Account, OAuth)

Supported Languages
- 中国語（簡体字）
- 英語
- フランス語
- ドイツ語
- 日本語
- 韓国語
- ポルトガル語（ブラジル語）


 ロシア語アクティビティについて詳しくはこちらをお読みください。

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

このアクティビティ一式は、Googleカレンダー、ドキュメント、ドライブ、スプレッドシート、Gmailとのやり取りに役立ちます。

Senior Software Engineer

how to move gmail message from one folder to other  using this package

Will Google Docs functionalities be added in future reiterations of this package? If so, please consider including a feature that allows users to repeat table headers across pages (talking about a really lengthy table). This feature would be similar to that allowed in Microsoft Word ("repeat header row on the top of each page").

Hi, This activity is absolutely brilliant. One request I would like to make is the inclusion of Google Sheets Clear Method. This would put the cherry on top for me!

Hi,Mihai! This package is so helpful for me! Could you please open your source code? I want to learn more about it!! 

How to delete file from one folder using this package.

Hi! There seems to be some sort of a bug with using cyrillic alphabet in the send mail message activity. If I try to email "Привет!" (hello in russian) to anyone they will get "ÐŸÐ&nbsp;Ð˜Ð’Ð•Ð¢!" instead. Any ideas how to fix that?

Would like to understand if there are any known incompatibility issues.

I try to send email with my service account/JSON but I get the error :Google.GoogleApiException: Google.Apis.Requests.RequestErrorBad Request [400]Errors [	Message[Bad Request] Location[ - ] Reason[failedPrecondition] Domain[global]]I've followed this <a href="https://integrations.uipath.com/docs/gsuite-application-scope#section-enabling-apis" target="_blank">https://integrations.uipath.com/docs/gsuite-application-scope#section-enabling-apis</a> but it doesn't work.Can you help with Google settings to check ?Thanks

Hello, Thank you for your amazing activity. It has helped me many times. I was wondering if you had plans to add support for Clearing All Data from Google Sheet and Deleting A Google Sheet?

Hi, I use UiPath Studio 2018.1.3 So I can't find this activity. Is it just for 2018.3.... ?Can I review Google Sheets with my Studio ?Thank you and best regards,Mahmoud

I want to rename GoogleDrive's SpreadSheet file name.Can I rename GoogleDrive's SpreadSheet file using Google GSuite activity?Should I run "GoogleDrive Apis Files: update" using Http Request activity?<a href="https://developers.google.com/drive/api/v3/reference/files/update" target="_blank">https://developers.google.com/drive/api/v3/reference/files/update</a>

Once a GSuite account has accepted the Oauth 2 connection, is it possible to trigger this again to connect to a different GSuite account? - I cant see any way to do this with OAuth.

Hi, I need your help, I can not in any way start processes with this package installed by orchestrator, unless Uipath studio is installed on that same machine, on all the other unattend I always find the usual error at startup , how can I do?Thank you

Hello, I am trying to read/edit a google sheet that is shared with the robot but I am having an issue. Is this feature supported? And if yes, maybe my service account key role is not correct. Can you tell me what role should I give to the robot to do this?

Hello again, I got the google sheet working. Thank you for your reply. But now, I'm having an issue with the Gmail send activity. I am using the service account role as well for the service key but I am encountering unauthorized client error. Here is the screenshot: <a href="https://forum.uipath.com/t/gsuite-gmail-activity-unauthorized-client-error/119408" target="_blank">https://forum.uipath.com/t/gsuite-gmail-activity-unauthorized-client-error/119408</a>

How can i fetch google calendar in Uipath so that i can schedule my robots accordingly

Hello all,I am trying to create folders in my own Drive. I manage to do so by using the Open Browser activity + pointing out where the robot must click and what it has to type in. In order to do that faster, I installed the GSuite Activity, generated a JSON authentication file from my own account (ServiceAccountKey), and I'm using the Create Folder Activity from this library. Every thing seems to work fine except that nothing is actually on my Drive account.What am I missing out?

Hi Mihai,This looks like a solid package . My question is about roadmap. Are you working on future versions and if so what kind of features can we expect? Just to get a sense of it. regards,Gaurav

Hello Mihai,great activity really simplifies my gmail sending. Have a possible strange bug that I wanted to ask you about. I have an application that generates an email and attaches a file. After I send the email I move the file to a sent location. 9 times out of 10 this works flawlessly, but sometimes I get an IOException saying the files is locked and can't be moved. I've put delays in after the send and it still fails. Any ideas? Thanks.

Hello everyoneI am trying to understand and to use the Google suite activities with UIPATH, (specially for reading mails with our company mailing system). I have some issues with the different parameters to put. I wonder if somewhere, there are some documentation about what to install first on the mail server side (API...).What are the different steps to use this activity !!!Thanks a lot for any help or advise you can provide.RegardsWilliam MATAR

While using "Search for Files and Folders" I get the output if I only search by "mime-type" but I obviously have +1 file in the folder and am not able to concatenate different parameters in q (anyway, the name-related ones don't work).If it's not possible for some reason, the other option would be to use the output array. Then the question is how to identify the "fields" to create the condition to retrieve the fileId for the specified file_name?Thanks in advance for your help

Hi,is there a possibility to use Read Range activity for Spreadsheets, as in standart Excel activity - specifically the range property; in Excel it gives you possibility to write only starting cell position (e.g. "A4"). Here to my mind, it behaves as Read Cell activity, while using such format of range.Thanks for help,Rudolf

Great activity pack, thank you. I am using the Read Cell actvity which works really well for static cell values.&nbsp;As soon as the cell is based off of a formula or lookup, nothing gets returned using the Read Cell activity.For example:<ul><li>If a cell is the SUM of a certain number of cells the Read Cell activity returns 0.</li><li>If a cell is set = another cell, the Red Cell activity returns nothing.&nbsp;</li></ul>Any ideas on the above?

Hi Mihai, Can u please attach a sample xaml code file for me to understand it better. I am trying to access gmail using Oauth. Have generated the client id and client secret . Still unable to run. It is opening browser, then each step i have to click one by one to provide access to my mail. And then it is stopping. What to provide in the user option in the oauth client id?

Hi Mihai,thanks a lot for this awesome package! I am also trying to access other Google APIs from UiPath using the HTTP Request activity but I'm struggling to get the OAuth2 token. Your GSuite activity scope handles this part perfectly. Is there any way we could obtain the token as an exit variable from the GSuite scope activity?Thanks in advance for your help and keep up the great work!Tomasz

Thanks! 1.2.0 works fine so farI can only see Direct Download option for this package. How can I enable Studio feed like with the UiPath Labs packages? <a href="https://go.uipath.com/component/connector-for-servicenow" target="_blank">https://go.uipath.com/component/connector-for-servicenow</a>Note: when installing 1.2.0 version on Studio 2019.4.2 we had an error for Docs API (myget gallery enabled)NU1101: Unable to find package Google.Apis.Docs.v1. No packages exist with this id in source(s):&nbsp;Resolved by getting a newer version from nuget.org as per Google documentation.

How to get spreadsheet ID? Hi Everyone,Can any one help me with steps to configure automation of google sheets?I have followed the steps mentioned on documentation(API Key, enabling Google sheets API).I want to read one google sheet but I am not sure how to get spread sheet Id as to get spreadsheet ID, I have to use Files and folders Activity inside GoogleDrive packages. And this part is giving me error.Please help if someone knows how to use these activities.Thanks,Mohan

How do I get the Message ID from an email?The message obtained via the activity Get Mail Messages, didn't contains all the Headers values, the only value that I get is "Date", and I need the UID/Message-ID, also the function .MessageId() return a value that is not the real message ID.

Hi,When I want to publish a project I get this error:Type ‘UiPath.GSuite.SimpleObjectContainer’ is not defined.BUT if I run the project it works without any errors.Any help to sort this out will be much appreciated. Thanks

Is it possible to read emails from a shared mailbox that my account has permissions on?

what is Spreadsheetid to fetch any google sheet

Shouldn't the Client Secret be a Secure String? As of now we are storing the Client Secret in the Assets as credential and using it in the activity by converting to string but that's not a right way and anyone can decode and retrieve the client secret which raises Security concerns during Info security approvals

HiWhen I download a Google Sheets or a Google Docs, I'm not able to convert it in .xlsx or .docxEven if I precise it in my "Local path". I'm always receiving PDF. Any idea ?Regards,JF

Hi, may I know what's the stable version of this activity package? We're having issue with the write activity. It always throw "An error occured while sending the request.".

Hi Mihai,I want to use this activity to create a calendar schedule. I would like to enable "change event" which is a guest permission so that anyone can edit the registered schedule.If you register a schedule with "Create Event", it will be invalid. Can this be set in the properties of the "Create Event" activity?Or is it a Google account setting? By the way, "change event" is enabled in the guest's permission of event setting. Please tell me.

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

Hi Mihai, Is it available to work in spanish?

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.

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 !

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.

How to move mails from folder to folder??

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?

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.

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?

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 ?

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

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

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? 

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.

Run script: Google.Apis.Requests.RequestError

	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.

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.

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

https://forum.uipath.com/t/gsuite-app-script-run-script-activity-giving-error-requested-entity-was-not-found-404/240696

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?

getting this error when trying to install this.plz help

20.6.0-beta.93+Branch.release-v20.6.0.Sha.520fc7e20bd9baa56becf2fa30e75d1a9000a01d

The following package(s) can not be installed: 

Will there be a Set Range Color and a Create Pivot Table activity soon like the Excel one?

I have seen a previous post where another user wanted to receive the output token from the Application Scope authentication so that it can be passed on but due to security concerns, the answer was no.

I find myself in a similar scenario where I would like to use BigQuery to send data to. I have managed to build an automation that can convert a data table into the JSON body needed to insert the data into BigQuery. I have also been able to test this using the Google OAuth2 Playground to generate a Bearer Token and provide this in the header of the API call. 

Where I am stuck, and with no programming experience, is constructing the JWT for the service account I want to use, more specifically the Signing of the encoded header and claims set using the p12 key and SHA256withRSA. If I could crack this part (using UiPath or InvokeCode within UiPath) then I would not need you to output the token.

Could I request the following? revisit the decision with the product manager to output the Token as part of the Application Scope (similar to how the Salesforce Application scopes allows connection to be output)

If not, then perhaps some guidance on how I might be able to achieve the above in UiPath?

The addition of BigQuery to your solution. Most people I suspect will only want basic functionality to start with such as Insert Data, as it is likely the automation will be populating a data lake that will be consumed elsewhere.

Regarding the Send Email Activity, is there a way for the email body to have a specific format? 

I find myself in a scenario where I need to send an email with the body having a table.

Is there a way to update a file's description or metadata?

Awesome component! - Keep up the good work!


Tha way to do it - If you need to interact with the Google Suite, this is the way to do it. It has all the features you may need in your project at a click distance. 


Really helpful - Interacting with Google Suite is so much easier now! Thanks 


Very useful set of activities - Brings everything you need from Google Suite to your UiPath studio.


Very useful - Many use cases and works perfectly.


Awesome! - A really interesting and useful Custom Activity package!


Good job - I used these activities and all worked perfectly!


Google GSuite Easier to Automate - Thank you for this useful component.
I easily integrate Google Sheets with my current project.


Really useful - I used in a customer demonstration and it was really useful to show how easy we can integrate with GSuite. Thanks!


GSuit, a time saver - I used GSuit to read data from a view only spread sheet. It just worked perfect even through manually i was unable to copy. It was a time saver for me. Thanks a lot!


Where can I get the source code of this component? - Hi@Mihai Dunareanu, thanks for this component, very useful and needed one.


Superb Activity! - This is awesome one that I ever seen in Go...Thank you UiPath Team, Thank you Mihai Dunareanu.



How to install this package into Studio? - Hi
i am a newbie and i am not able to add this suite into my studio (2019.4 ver)
can anyone assist me?
Thank you in advance




Very Useful Component - It is very useful for automation specially that many clients are using Google Sheets on their daily transactions


Really useful component - When i want to use gmail and google sheet functions with UiPath, I have faced lots of difficulties and many time wasting steps to get it done. By using the Gsuite component it made me really easy to implement those funtions on UiPath.
Greate Job @Mihai....Cheers


Great integration - Thanks ! This package has been a huge help on our recent project. Keeping my fingers crossed for further development of the package and for the addition of other GSuite API methods.
A definite 5 stars !


How to get Spreadsheet ID? - Hi Everyone,
Can any one help me with steps to configure automation of google sheets?
I have followed the steps mentioned on documentation(API Key, enabling Google sheets API).
I want to read one google sheet but I am not sure how to get spread sheet Id as to get spreadsheet ID, I have to use Files and folders Activity inside GoogleDrive packages. And this part is giving me error.
Please help if someone knows how to use these activities.
Thanks,
Mohan


How to delete file in google drive? - I use delete activity in scope but I receive 403 error.


10/10 - Great work Mihai, this package saved me a ton of time and effort during my last project.


 - A Meticulous gsuite component..
5/5
cheers


Great work Mihai!!
One of the best components and it saves a ton of work and makes our lives so easy when working with google docs...

Amazing. You are a rock star!!!

Great component. I was able to use it multiple times in different proje ts 

Obviously much-needed activities to work with the Google cloud!

Thanks!! 
Works fine with franchise characters. :)

Used it for testing purposes for gmail and it works excellent.

This hotfix addresses outstanding issues with version 1.5.0 and contains various improvements.

Solved an issue with GetMailMessages where single part emails were not inspected for an attachment.

Introduced support for parsing of names contained in an email address.

InArgument <string []>、 'AttachmentList'を新しくメールの送信アクティビティに追加し、ユーザーが動的にファイルを添付して送信できるようにしました。

OutArgument <string>、 'UpdatedEventID'はModifiy Eventアクティビティに新しく追加しました。

Made Google Authentication scope selection granular.

Removed the Services input, which was used to select the Google service and the scopes associated with the service.

Added a new button, 'Configure Scopes'. Upon pressing the button, a wizard is displayed which contains a list of all possible authentication scopes usable by the child activities. The 'Auto-Detect' button can be used to automatically select required scopes. The user is free to insert new scopes in the list. If no scopes are selected, the minimum required scopes are selected at runtime.

Resolved a nuget package signing issue on the 1.4.1 release. This build has the same functionality as 1.4.1.

Resolved a bug with Orchestrator request when requesting data from a modern folder.

The behaviour of the DataStoreLocation option has been changed: Local disk (no changes), Orchestrator (this option has changed from per robot asset to global asset), Never Store (no changes).

Rename the Folder input in Options to OrchestratorFolderPath to reduce confusion.

SupportsTeamDrives property has been hidden and deprecated.

Add a new option under OAuth Client ID, "DataStoreLocation". 

Google GSuite

Google GSuite

Help

How To