Release notes

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.

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

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.

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.

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.

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.

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.

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

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.

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.

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.

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.

Fixed an issue affecting the Turn On Automatic Replies activity.

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.

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.

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

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

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.

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.

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

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

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.

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

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.

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.

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.

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.

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.

This release includes minor bug fixes.

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.

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.

A Get Event List activity is now available.

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.

Fixed some issues with the Drive trigger activities.

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.

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.

This release brings three new activities:

This release also brings two new trigger activities:

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

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.

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.

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:

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.

The following Trigger activities are now available:

For more information, see Trigger activities.

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.

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.

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

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:

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.

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.

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:

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:

The following activities have been moved under Google Drive:

GSuite Application scope

Get Mail Messages

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.

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

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.

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

Google Drive activities

GSuite Application Scope

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

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

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.

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.

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