Release notes

Browse the release notes by clicking on the desired version in the table of contents on the right.

Known issue

Important:

The OAuthClientID authentication type using the UiPath OAuth Client (the UiPath public app) in Google Workspace Scope is currently unavailable. Automations using the UiPath public app to authenticate may stop working and throw the following error message: "This app is blocked". We are working to fix the issue and restore the app.

In the meantime, you can use OAuthClientID authentication with a custom Google application created by your organization. For more information, see Google Workspace Scope.

This issue does not impact Integration Service connections.

v2.7.24

Release date: October 31, 2024

Note: This version of the activity package can be used with UiPath Studio versions 2023.10 and newer. If used with older Studio Desktop versions, some functionalities might be missing or unexpected behaviors may occur.

Bug fixes

• Google Sheets activities failed in long-running processes because of expired tokens.

v2.7.23

Release date: October 10, 2024

Note: This version of the activity package can be used with UiPath Studio versions 2023.10 and newer. If used with older Studio Desktop versions, some functionalities might be missing or unexpected behaviors may occur.

Bug fixes

• The File Created, File Updated, and Folder Created triggers failed when selecting a file or folder location in a Shared drive.

v2.7.22

Release date: September 26, 2024

Note: This version of the activity package can be used with UiPath Studio versions 2023.10 and newer. If used with older Studio Desktop versions, some functionalities might be missing or unexpected behaviors may occur.

Bug fixes

• The Text field in the Write Text activity was not displayed properly.

v2.7.21

Release date: September 24, 2024

Note: This version of the activity package can be used with UiPath Studio versions 2023.10 and newer. If used with older Studio Desktop versions, some functionalities might be missing or unexpected behaviors may occur.

Google Tasks activities

You can now automate your processes for Google Tasks with the new dedicated activities and triggers. This activity package now includes an extensive list of Google Tasks activities, including Create Task, Get Task List, Complete Task, and Delete Task. Check out the full list in the Tasks activities page.

Improvements

For Gmail activities that support filtering, we replaced the Categories input option with a dropdown list of available categories from which you can select. These are the standard categories available for a Google account: Forums, Personal, Promotions, Social, Updates.

The GmailMessage object now includes attachments metadata support. We added a new AttachmentsInfoList property which includes the following metadata: name, size, and extension (MIME type).

We exposed a new property on email objects called InternetMessageID. This allows you to retrieve emails based on the ID generated by the system sending the email, not the Google email ID (generated by Google as the receiving system). You can use this value as input in the Get Email by ID activity.

The Add Sheet activity now includes an If sheet already exists field, to indicate the conflict resolution behavior in case a sheet with the same name already exists.

Updates in Classic activities

You can now use variables for the Key Orchestrator Storage Bucket field in Google Workspace Scope. Select the new Full Path input mode to specify the storage bucket's full path as a string or use a variable.

In the Run Script activity, the Script ID field has been renamed to Deployment ID. We also added a new input parameter called Deployment mode.

Working with scopes

It is now easier to identify the required scopes for working with Google Workspace activities. Each activity includes a warning informing you of the scope(s) it needs to run properly. When you add an activity to your workflow, we automatically check if the connection you're using has the necessary permissions to perform said action.

v2.6.24

Release date: 12 August 2024

Note: This version of the activity package can be used with UiPath Studio versions 2023.10 and newer. If used with older Studio Desktop versions, some functionalities might be missing or unexpected behaviors may occur.

Bug fixes

• This release brings updates to some dependencies for security reasons.

v2.6.23

Release date: 18 June 2024

Note: This version of the activity package can be used with UiPath Studio versions 2023.10 and newer. If used with older Studio Desktop versions, some functionalities might be missing or unexpected behaviors may occur.

Bug fixes

• The HTTP Request activity failed when used inside the Scope because authentication scopes could not be set. Now, when you add the HTTP Request activity inside Google Workspace Scope, the Required scopes field is displayed. This field allows you to add any additional scopes needed for running HTTP Request, other than the scopes defined in Google Workspace Scope.
• Fixed an activity override issue which caused the Get Newest Email activity to fail.
• Erratum – Added October 1, 2024: To retrieve all emails when using a shared mailbox, you can leave the Email folder path empty or enter "*".

v2.6.22

Release date: 3 June 2024

Note: This version of the activity package can be used with UiPath Studio versions 2023.10 and newer. If used with older Studio Desktop versions, some functionalities might be missing or unexpected behaviors may occur.

Bug fixes

• An error occurred when saving workflows that contained Read Cell activities configured with files or folders whose names end in white space.

v2.6.21

Release date: 14 May 2024

Note: This version of the activity package can be used with UiPath Studio versions 2023.10 and newer. If used with older Studio Desktop versions, some functionalities might be missing or unexpected behaviors may occur.

Coded workflows support

If you prefer to code when building automations, you can now achieve this using coded automations and UiPath services. The Google Workspace activity package now includes APIs that enable you to create automations for Gmail, Google Drive, Google Calendar, and Google Sheets. Visit Coded Automations to learn more about coded automations in UiPath Studio and Google Workspace APIs for the full list of supported APIs.

New activities

Google Docs

This release brings new activities that allow you to work with Google Docs documents: Read Text, Write Text, Find and Replace Text, Create Document Template, Fill Document Template, and Delete Text. With these activities you can extract information from Google Docs, populate documents with dynamic content, automate repetive tasks like text deletion or find and replace actions, and create new documents.

Google Drive Labels

We introduced five new activities that allow you to manage labels in Google Drive: Apply File Labels, Remove File Labels, Get File Labels, Clear File Label Fields, and Get Drive Labels.

Google Calendar

We also added two calendar activities: Get Event by ID and Get Calendars.

HTTP Request

Last but not least, the new HTTP Request activity allows you to make requests to any endpoint of the Google Workspace API. This means you are no longer limited to the functionalities of our predefined activities, and you can access the full capabilities of Google APIs. To use this activity, create a connection to the new Google Workspace connector.

New features and improvements

General improvements

You can now filter on labels on Gmail triggers.

We renamed the Browse input method from the context menu to Folder picker or File or folder picker, depending on activities. This also impacts the Reload browser field, now renamed to Reload file/folder picker.

We added a minor improvement to the Share File or Folder activity: a new Access URL output field is now available.

Google Workspace Scope improvements

We improved the Asset connection method by adding a Reload assets option. This allows you to reload your available assets in Orchestrator directly when setting up the connection.

A Runtime connection assets field is now available, so that you can use different assets between design time and runtime. This means you can use a regular, unencrypted asset at design time, that allows you to configure the activity, then use a more secure asset at runtime. This can also be a credential-type asset. When you create a runtime asset of the credential type, you can enter any value for the username field.

Batching API calls for performance improvements

We introduced batching capabilities for some activities, to bypass the API response time limitation. For loops that continuously read or write, we batch API calls into one single call, to increase runtime performance. The loop activities that support batching are For each email, For each file or folder, For each row, and For each event. The impacted activities are Write row and Write cell. Note that the Google API supports batching 100 requests at a time.

Erratum - Added September 2024: We have an improved activity override experience for working with files and folders. Before, when you configured an activity and selected a file or folder, we saved the connection ID and element ID. However, when you changed the connection used in a workflow, the element ID also changed, even if its path remained the same. We now save the full path of an element as a fallback mechanism, using the path to correctly identify a resource if the saved ID isn't valid.

Errata

Added June 2024: We also added an improvement to the classic Create Deployment activity. It now includes a Deployment ID output argument, which you can use further in the Run Script activity.

Added September 2024: We have an improved activity override experience for working with files and folders. Before, when you configured an activity and selected a file or folder, we saved the connection ID and element ID. However, when you changed the connection used in a workflow, the element ID also changed, even if its path remained the same. We now save the full path of an element as a fallback mechanism, using the path to correctly identify a resource if the saved ID isn't valid.

v2.5.10

Release date: 15 April 2024

Note: This version of the activity package can be used with UiPath Studio versions 2023.10 and newer. If used with older Studio Desktop versions, some functionalities might be missing or unexpected behaviors may occur.

Bug fixes

• An input field was mistakenly displayed twice on the Copy file activity's canvas.

v2.5.9

Release date: 25 March 2024

Note: This version of the activity package can be used with UiPath Studio versions 2023.10 and newer. If used with older Studio Desktop versions, some functionalities might be missing or unexpected behaviors may occur.

Bug fixes

• Some workflows containing Google Workspace activities failed to load in Studio Web.

v2.5.8

Release date: 7 March 2024

Note: This version of the activity package can be used with UiPath Studio versions 2023.10 and newer. If used with older Studio Desktop versions, some functionalities might be missing or unexpected behaviors may occur.

Bug fixes

• The Download file activity failed when using the URL or ID input method.

v2.5.7

Release date: 1 March 2024

Note: This version of the activity package can be used with UiPath Studio versions 2023.10 and newer. If used with older Studio Desktop versions, some functionalities might be missing or unexpected behaviors may occur.

Bug fixes

• When using Google Workspace Scope in Studio without a connection to Orchestrator, creating a connection during design time was not possible. The menu actions for Connect now and Auto-detect (scopes) were not displayed.

v2.5.6

Release date: 30 January 2024

Note: This version of the activity package can be used with UiPath Studio versions 2023.10 and newer. If used with older Studio Desktop versions, some functionalities might be missing or unexpected behaviors may occur.

Bug fixes

Fixed an issue affecting the Turn On Automatic Replies activity.

v2.5.5

Release Date: 29 January 2024

Note: This version of the activity package can be used with UiPath Studio versions 2023.10 and newer. If used with older Studio Desktop versions, some functionalities might be missing or unexpected behaviors may occur.

New features and improvements

On-prem support for all activities

You can now use all the Google Workspace activities on-prem, even if you don't have Integration Service, through Google Workspace Application Scope. When added inside the Scope, the activities inherit connection information from it. To support this improvement, we also revamped the Scope activity to introduce an Asset connection method, which allows you to set up an asset in Orchestrator and use it to create a connection. Configuring the connection using the Properties panel is still supported.

Dynamic DataTable improvements

A refresh tables mechanism is now available at activity level, with Update table and Update fields options for Read range, For each row, Write row, and Write column activities. With these options you can refresh the dynamic DataTable at design time after you add or modify a column in your sheets.

We added new dynamic DataTable worksheet metadata to the Read Range and Row added to the bottom activities: SheetRowIndex, [Name] Address, and [Name] ColumnAddress.

Columns generated through dynamic DataTables are available as simplified attributes in variables.

Simplified view for Studio Web

All the activities now support the Studio Web simplified view for output types. We also updated the curated shortlist of properties displayed for output objects, based on usage and priority.

We also updated the properties available for output objects. For GmailMessage, we added AttachmentsCount and AttachmentNames (replacing Attachments, which has been deprecated), ToAddressList, CCAddressList, and BCCAddressList. For GSuiteEventItem, we added AttendeesEmailList and Location.

We also added URL to object properties and deprecated URI.

Default values for folders, inbox, and calendars

We introduced default values for some fields in the activities. Your inbox is now the default folder on all email activities. For calendar activities and triggers, the user connection name is the default value for the Calendar field. For Drive and Sheets activities and triggers, My Drive is the default value for the In Location field. If you modify this default value, the next activity added in the workflow will automatically retrieve the latest user selection.

New Out of Office and Gmail Labels activities

This release brings two new Gmail activities: Turn On Automatic Replies and Turn Off Automatic Replies.

We also have a new set of Gmail Labels activities: Apply Gmail Labels and Remove Gmail Labels. We added support for Google labels and revamped our activities to reflect this improvement.

Other improvements

The Archive folder is now available in the folder browser for email activities.

You can now iterate through all the emails in Outlook, regardless of folders, by selecting All Mail in the folder browser.

Google Workspace activities can benefit from the updated Studio Web Test trigger feature. At design time, you can test the trigger and Studio Web calls the activity and returns the object that triggers the event. This allows you to see all available object properties, and use these values further in the workflow.

We updated the names of output variables for all activities and triggers.

We also added additional filter operators to triggers, to enhance filtering capabilities.

We improved the error message for out of range scenarios, providing more clarity.

We added a retry mechanism on Get [object] activities to prevent file processing errors.

Note: Errata - Added May 2024: We mistakenly announced an improvement for this release (Batching API calls for performance improvements), which was in fact released in a later version.

Bug fixes

• We have increased the limit for the maximum number of shared drives retrievable in an activity, from 100 to 500.

v2.4.3

Release date: 15 November 2023

Note: This version of the activity package can be used with UiPath Studio versions 2023.10 and newer. If used with older Studio Desktop versions, some functionalities might be missing or unexpected behaviors may occur.

Bug fixes

Switching the context menu from Browser to Use variable failed on some activities.

v2.4.2

Release date: 30 October 2023

Note: This version of the activity package can be used with UiPath Studio versions 2023.10 and newer. If used with older Studio Desktop versions, some functionalities might be missing or unexpected behaviors may occur.

New features and improvements

We exposed a new WebLink property for output Gmail messages.

New activities

This release introduces two new Google Sheets activities: Delete Rows and Delete Column.

New Google Sheets triggers

We are also expanding our trigger capabilities with three new Google Sheets triggers: Cell in Sheet Updated, Row Added to the Bottom of a Sheet, and Sheet Created.

v2.3.4

Release date: 2 October 2023

Bug fixes

The browser widget in the Add Sheet activity displayed only folders.

Note: This version of the activity package can be used with UiPath Studio versions 2023.10 and newer. If used with older Studio Desktop versions, some functionalities might be missing or unexpected behaviors may occur.

v2.3.3

Release date: 26 September 2023

The improved activities included in the latest release set the foundation stone for core automation use cases in Studio Web and Cross-platform. Continue reading to learn what's new in this release and how you can benefit from the most recent features.

Note: This version of the activity package can be used with UiPath Studio versions 2023.10 and newer. If used with older Studio Desktop versions, some functionalities might be missing or unexpected behaviors may occur.

Activity caching

Sharing information between activities is important to achieve faster loading times. With this in mind, some caching improvements were introduced in this release.

The Sheets activities include two new options that enhance caching: Update ranges and Update sheets. They allow you to retrieve the latest data from your spreadsheets without reselecting a file. You can find Update ranges, for example, in the For Each Row in Spreadsheet, Read Cell, and Write Cell activities; and Update sheets in Rename Sheets or Delete Sheets.

Connection caching is also available. When you change the connection in an activity, the other activities in the workflow are reloaded with the new connection.

Activities which use calendars, email folders, and folders include a Reload browser option, which allows you to retrieve the latest data if you've performed any changes in your folders. For example, this option is available in For Each Event, Get File/Folder, Read Range, or Get Newest Email.

Improvements in Sheets activities

Two new Google Sheets activities are available: Write Row and Write Column. You can manage entire rows and columns and manipulate cells within with Append, Insert, or Overwrite options.

Sheets activities introduce a new dimension of worksheets control using A1 Notation metadata and the new activities. Sheets activities now offer metadata about the worksheet they are working on to give more control and enable complex scenarios for business users. Until now, users had to make additional auxiliary calculations to store a range of metadata and to know where the robot acts at any moment in Google Sheets. With the metadata now exposed and the new activities, we reduced the redundant auxiliary logic a business user must apply to automate a Google Sheet. This also reduces the barrier for more complex scenarios where the range doesn’t start from A1.

The following additional worksheet metadata is now exposed: WorksheetsRowIndex – the worksheet row value in the context of the specified Range; [Column Name] Address – the A1 notation address of the specified cell; [Column Name] Column Address – the A1 notation of the column of the specified cell; and Range information.

The Range information output field is available in the Read range activity. This field can be a complex object or a string, and it exposes information such as FullRangeAddress, RangeAddress, StartCell, EndCell etc.

We improved the validation message that indicates where the duplicate or empty columns are located.

The Remove empty rows or columns field was renamed to Delete behavior.

The Has Headers option in For Each Row in Spreadsheet is now set to True by default.

You can use the Write Range activity to insert a new row using the Append option.

We also added some improvements to dynamic datatables: the Column Names are now available in a Description property.

General improvements

The folder picker in the Get File/Folder activity includes two new options: Full path and Relative path. You can now manage folders better by iterating through them and referencing parent folders and file/folders through relative paths. By doing this, you can dynamically parse recursively from the file to the parent’s parent folder and the whole folder hierarchy until the root.

We also restructured the hierarchy in the Browser widget for calendars, email folders, and Google Drive folders.

v2.2.6

Release date: 30 August 2023

Bug fixes

An error occurred when upgrading a workflow that contains a GSuite Application Scope activity to a package version greater or equal to 2.1.0.

v2.2.5

Release Date: 24 July 2023

Bug Fixes

This release includes minor bug fixes.

v2.2.4

Release Date: 16 June 2023

Bug Fixes

This release includes minor bug fixes.

v2.2.3

Release Date: 12 June 2023

New Features and Improvements

The Total number of items processed output property in the cross-platform For Each activities has been renamed. Instead of "items", the property now includes the object name. For example, in the For Each Event activity, the output property is now Total number of events processed. This property can also be used inside the For Each to count the total number of items processed. It iterates through items and is incremented by 1 at the end of each iteration.

Range caching is available for the Sheets activities, making it easier to share information between activities using the same connection and spreadsheet. Caching is also available within each activity, with information stored in memory. When you select a workbook, the Range field is prepopulated. If you select the same spreadsheet in another activity, the ranges load from the cache memory. An Update Ranges option is available for the Range field, in case you perform any changes in the selected spreadsheet ranges metadata (such as Range names, Sheets names, or Table names). This feature impacts the following activities: For Each Row in Spreadsheet, Read range, Write range, Read cell, Write cell.

GDriveRemoteItem variables now expose a ParentID property, representing an item's parent folder. The ParentID property can be used downstream in other activities to add items to a specific parent folder.

A Job Data output property is available in all the trigger activities. It contains the job info, such as Process name, Process version, Workflow name, Robot name, and mode of execution.

Several Drive activities now include a If file/folder already exists property.

The Get File List activity was renamed to Get File/Folder List. The Move File activity was renamed to Move File/Folder.

New activities

A Get Event List activity is now available.

New trigger activities

Three new trigger activities are available: Calendar Event Replied, Calendar Event Updated, File Updated.

Bug Fixes

Fixed a bug in the For Each Event activity, which didn't expose the output list of events.

Fixed a bug which caused the Read Cell and Write Cell activities to throw an error when a NamedRange was used. The Cell property was interpreted as being required instead of optional.

v2.1.2

Release Date: 6 April 2023

Bug Fixes

Fixed some issues with the Drive trigger activities.

v2.1.1

Release Date: 27 March 2023

New Features and Improvements

A Number of items processed output property is now available in the cross-platform For Each activities.

The Filter by file names (e.g. .xlsx or .xlsx|*.docx) input property in the Download email attachments activity has been renamed to Filter by filename.

The For Each Event activity now includes filtering capabilities.

The How to write property in the Write Range activity includes a new Append option: Append Right.

For the Read Range and For Each Row in Spreadsheet activities, we now expose columns as headers when named headers are not available.

The In location field in the For Each File/Folder activity supports the use of IResource variables.

We also implemented a new behavior in activities to reduce validation errors. Switching the input type doesn't clear the value from the previous input mode. The information is instead stored in a back-up slot and restored if the input mode changes. This way, no validation errors appear when switching between input modes.

New activities

This release brings three new activities:

• Delete Range

• Get Email List

• For Each Sheet in Spreadsheet

New trigger activities

This release also brings two new trigger activities:

• Calendar Event Created

• Calendar Event Received

The existing trigger activities were renamed for this release, as follows:

Gmail:

• When an Email is Sent is now called Email Sent
• When New Email Arrives is now called Email Received

Google Drive:

• When a New File is Created is now called File Created
• When a New Folder is Created is now called Folder Created

Improvements for Sheets activities

We've improved performance for the Write Cell activity. When used inside a For Each Row in Spreadsheet activity, Write Cell writes in-memory, to improve speed and prevent API quota limits.

The For Each Row in Spreadsheet activity also has a new error handling mechanism, for writing the data already stored in-memory when an error is thrown.

Bug Fixes

• Fixed a bug in the Get Newest Email activity which caused the folder ID to be wrongly attributed.

v2.0.3

Release Date: 2 March 2023

Bug Fixes

• This release includes minor bug fixes.

v2.0.2

Release date: 28 February 2023

Improvements

We've reorganized the activities in Studio. The classic activities (which are Windows-Legacy and Windows compatible) are now available under the Integrations > Google > Workspace - Classic category.

The newer activities (which are Windows and Cross-platform compatible) are available under Integrations > Google > Workspace. These activities have improved UX and functionalities and they require using Integration Service for establishing connections. For non-Integration Service connections, use the Classic activities.

v2.0.1

Release date: 25 January 2023

New Features and Improvements

New activities

This release brings many new activities for Cross-platform and Windows projects. They include a renewed Designer panel, which provides an improved experience compared to the existing activities that are available in Windows and Windows — Legacy projects.

These activities are available for the following Google categories:

• Calendar
• Drive
• Gmail
• Sheets

These new activities use Integration Service connections. For a full list of activities and an overview on how to use them, see the Activities page.

Trigger activities

The following Trigger activities are now available:

• Drive: When a New File is Created, When a New Folder is Created
• Gmail: When an Email is Sent, When New Email Arrives.

For more information, see Trigger activities.

Improvements

We've exposed a new method — GetSizeInBytes() — that allows you to retrieve file size for locally downloaded files.

Bug Fixes

• The Insert Text activity had different property names between the Designer panel and Properties panel.

v1.16.2

Release date: 9 May 2022

New Features and Improvements

Improvements

The Use Google Document, Use Google Spreadsheet, and Use Google Drive activities now allow you to use multiple account connections by accessing the UiPath Orchestrator through Integration Services. The Default option has been replaced by the connection name.

The Search Events activity has been updated with a new parameter, called Event ID, that lets you specify an event ID to look for.

The Upload File activity has been updated with a new option, called Convert to Google Workspace file type, that lets you convert uploaded files to Google Workspace file types, such as a Google document or spreadsheet.

The Get Mail Messages activity has been updated with a new parameter, called Email ID, that lets you specify an email ID to look for.

The Google GSuite Activities pack has been upgraded to use Google API version 1.55.0.

Bug Fixes

• Attachment names were being altered and the file extensions removed when sending email using the Send Mail Messages activity.

v1.13.2

Release date: 8 November 2021

Bug Fixes

Fixed a bug in the Use Google Drive, Use Google Document and Use Google Spreadsheet activities to allow entering a Client Secret with a length of 35 characters.

v1.13.1

Release date: 27 October 2021

New Features and Improvements

Support for Integration Service Connections

You can now easily authenticate to Google by using connections from the new Integration Service in UiPath Automation Cloud.

When the Integration Service is enabled in your tenant, the Use Google Drive, Use Google Document, and Use Google Spreadsheet activities enable you to quickly authenticate by creating a connection or selecting an existing connection from the service. To enable the use of the Integration service for managing the connection, select the Use Connections option in the Properties panel of the activities. If you select the global setting Default to managed connections in the Studio settings, the Use Connections option is selected by default in all the activities that support it. The global setting is selected by default if the Integration service is available in the Orchestrator tenant that Studio is connected to.

Runtime Governance

Organizations can now use Robot governance policies deployed from Automation Ops to specify email addresses where automations are not allowed to send emails at runtime. The new Robot policy available in Automation Ops starting with Robot v2021.10 includes the Email Blocklist Runtime Analyzer rule that enables you to define email addresses or domains that GSuite activities which can send emails are prohibited from using as recipients. The rule supports the use of regular expressions for defining patterns for email addresses to block.

Other Improvements

• The Use Google Drive, Use Google Document, and Use Google Spreadsheet activities are now available by default in the Studio profile. You can find them in the Activities panel under Integrations > Google. In addition:
  • The following activities can now be used with Use Google Document: Get Document, Get Text Index.
  • The following activities can now be used with Use Google Spreadsheet: Append Row, Get Cell Color, Get Sheets, Read Column, and Read Row.
• The Remote File browser for G Suite activities now loads the first 200 entries and then, once you scroll down to the bottom of the list, the next 200 entries are loaded and added to the list.
• The Add Gmail Account dialog has been renamed to Add Google Account in the following activities: Use Google Document, Use Google Drive, and Use Google Spreadsheet.

Bug Fixes

• Fixed an issue that caused the Copy Paste Range activity to stop working.
• An issue has been fixed that caused the Sheet1 element to be translated with an extra space in Japanese, and as a result caused the activity to return an error.

v1.11.0

Release Date: 15 April 2021

New Features and Improvements

Support for StudioX

We’ve updated most Google Drive, Google Docs, and Google Sheets activities to make them compatible with StudioX. New properties are available and some property labels have changed for the activities that were updated to support StudioX.

The following activities are available for StudioX:

Google Docs:

• Batch Document Updates
• Insert Text
• Replace Text
• Read All Text

These activities got an additional parameter called Document. This parameter represents a reference to a Google Docs document, typically obtained via StudioX’s Use Google Document activity.

Google Sheets:

• Add New Sheet
• Batch Spreadsheet Updates
• Copy Sheet
• Delete Range
• Delete Sheet
• Read Cell
• Read Range
• Rename Sheet
• Write Cell
• Write Range
• Clear Range
• Download Spreadsheet

These activities, with the exception of Copy Sheet whose new parameters are FromSpreadsheet and ToSpreadsheet, got an additional parameter called Spreadsheet. This parameter represents a reference to a Google Spreadsheet, typically obtained via StudioX’s Use Google Spreadsheet activity.

Google Drive:

• Copy File
• Create Document
• Create Folder
• Create New Spreadsheet
• Download File
• Move File
• Share File
• Upload File

When configuring activities that require indicating files or folders from Google Drive, now you can quickly make your selection using a file browser available in the activities. The file browser can be used when the file activities are placed inside StudioX’s Use Google Drive activity.

This update brings some additional changes.

New scope activities are available to make it easy to add the resource you need to automate:

• Use Google Drive
• Use Google Document
• Use Google Spreadsheet

To use StudioX’s new scope activities in Studio, enable the Show StudioX filter in the Activities panel.

When working with Google Sheets activities in StudioX, you can select sheets and named ranges directly from the Plus menu.

A new Download Spreadsheet activity enables you to download a Google spreadsheet and then modify it using Excel automation.

The following activities have been renamed:

• Create File Permission is now Share File
• Batch Update Values Scope is now Batch Spreadsheet Update
• Batch Update Document Scope is now Batch Document Update

The following activities have been moved under Google Drive:

• Create Document
• Create New SpreadSheet

v1.8.0

Release Date: 17 November 2020

New Features and Improvements

GSuite Application scope

Added a new parameter in the OAuth Client ID category, called OAuthClient. Now the users can select UiPath Google Suite App (default) instead of having to create their own OAuth Client. Using UiPath’s app allows the user to bypass complex options such as multiple authentication methods, define services the scope will use, etc.

v1.7.0

Release Date: 26 October 2020

New Features and Improvements

Removed a dependency from MicrosoftApplicationInsights.

GSuite Application scope

Added a new InArgument<SecureString>, SecureCredentialSecret, in the OAuth Client ID category. If set, the SecureClientSecret parameter takes precedence over the ClientSecret parameter.

Get Mail Messages

The Body property of the received emails now defaults to the text part. In cases where no text view of the email is available, the Body property takes the value of the Html part. This makes it easier to search or see the body, as its text is simpler and does not include Html tags. To help workflows where the Html body was manipulated, a new property of GmailMessage, BodyAsHtml, has been added.

Note: This change breaks backward compatibility if your automation used parsing of the Body.

v1.6.0

Release Date: 15 September 2020

New Features and Improvements

When selecting Local Disk in the DataStoreLocation, the resulting token data is encrypted at rest using DPApi.

Fixed a localization problem with the Run Script activity.

Added support for authenticating to Orchestrator using the UiPath IDP service as a means to using Orchestrator as a token datastore.

Fixed the exception message being thrown in the Run Script activity when the remote functions fail.

Updated the designers to include more information.

v1.5.1

Release Date: 23 June 2020

Bug Fixes

• Fixed an issue occurring on the GetMailMessages activity where single part emails were not inspected for an attachment. This hotfix introduced support for the parsing of names contained in an email address.

v1.5.0

Release Date: 15 June 2020

New Features and Improvements

This release brings many new exciting features. Five new activities are available under the Google AppsScript functionality:

• Create Script Project
• Create Deployment
• Get Project Content
• Run Script
• Upload Script File

The GSuise Application Scope activity has been improved with a new wizard that contains a list of all possible authentication scopes usable by the child activities. The Auto-Detect button can be used to automatically select the required scopes. New scopes can manually be added to the list. If no scopes are selected, the minimum required scopes are selected at runtime.

This wizard replaces the previous Services input option, which was used to select the Google service and the scopes associated with the service.

v1.4.0

New Features and Improvements

Using the Robot and Studio API for tighter integration with the platform.

Added a telemetry client, which however is disabled in runtime.

Added an Orchestrator client.

Added project settings.

The activity has been translated in all the languages available to UiPath Studio.

New activities released

• Clear Range

Google Drive activities

• SupportsTeamDrives property has been hidden and deprecated. It now defaults to true. Google documentation states: Deprecated - Whether the requesting application supports both My Drives and shared drives. This parameter will only be effective until June 1, 2020. Afterwards all applications are assumed to support shared drives.
• Added a new boolean property, UseDomainAdminAccess, to Permission activities.

GSuite Application Scope

• Add a new option under OAuth Client ID, DataStoreLocation. It allows selecting multiple storage locations for the TokenResponse received upon successful completion of the OAuth2 flow: Local disk (the default behaviour of the package until now), Orchestrator (as per robot asset), Never Store at all (this will mean the consent screen will be shown each time the activity is run).
• Added a new category named Options. Inputs that are common between the various categories will be found here.
• Moved the User input from the OAuth Client ID category to the newly created Options category.
• Added a new InArgument<string[]>, Folder, to the Options category, for versions of Orchestrator that support it.

v1.3.1

Release Date: 21 October 2019

Bug Fixes

• Solved a bug in the Change Labels activity where the activity tried to remove the DRAFTS and SENT labels, even though these are system labels and cannot be added/removed from an email.

v1.3.0

Release Date: 26 August 2019

New Features and Improvements

This release adds a new AttachmentList (String[]) property to the Send Mail activity, giving you the ability to send a dynamic number of attachments. The activity sends all attachments specified in both the Attachments and AttachmentList properties.

The Modify Event activity was also updated to include a new UpdatedEventID property (String[]) to output the ID of the resulting modified event. In most cases, the UpdatedEventID value is the same as the specified EventID. However, there are instances when a new event is created (e.g., recurring events).

In addition to updating exsiting activities, this release adds the following activities:

• Add Delete Columns
• Add Delete Rows
• Append Row
• Batch Update Values Scope
• Copy Sheet
• Copy Paste Range
• Create New SpreadSheet
• Delete Range
• Get Cell Color
• Rename Sheet

v1.2.0

Release Date: 19 June 2019

New Features and Improvements

This release introduces integration with Google Docs, enabling automation via the Create Document, Get Document, Get Text Index, Insert Text, and Replace Text activities.

In addition to the new Google Docs activity set, this release adds an optional InArgument\<string\> (User) to the GSuite Application Scope that you can use to store different tokens for multiple Google accounts. It also adds two optional InArgument\<int\> (Rows and Columns) to the Add New Sheet and Create Spreadsheet activities that you can use to specify the sheet size you want to create.

Bug Fixes

• This release fixed the bug (introduced in version v1.1.0) that did not allow the GSuite Application Scope to be run in a loop.

v1.1.1

Release Date: 14 March 2019

New Features and Improvements

This release adds new activities to each supported application, as well as, introduces integration with Google Calendar.

With this release, you can now Delete File in Google Drive, Change Labels in Gmail, and Delete Sheet in Google Sheets.

In addition to the new activities for the existing applications, this release integrates with Google Calendar, enabling the management of your calendar events, including Add Attendees, Create Event, Delete Event, Modify Event, and Search Events.

Bug Fixes

• This release fixed the issue of email addresses being truncated when they contained capital letters.

v1.0.6961.3913

Release Date: 22 January 2019

Bug Fixes

• This release fixed a series of minor bugs where ArgumentNullExceptions and ArgumentOutOfRangeExceptions were not displayed correctly.

v1.0.6961.3913

Release Date: 22 January 2019

New Features and Improvements

This release introduces integration with Google Drive. With this integration, you can automate your interactions with Google Drive, including Download File, Upload File, and Get File Info. In addition to the new activity set, this package adds Japanese language support.

Known issues

• There are two known issues in this release. The first is the Upload File activity is limited to 2GB size files. The second is the Download File activity is limited by your memory size, so you may need to check your available memory when downloading large files.

v1.0

Release Date: 17 December 2018

New Features and Improvements

The first beta release introduces integration with Google Docs, Google Sheets, and Gmail.