- Overview
- Excel
- Release Notes
- About the Excel activity package
- Project Compatibility
- Supported character encoding
- Project Settings
- Add or Update Excel Sensitivity Label
- Append Range
- Auto Fill
- Autofit Range
- Change Pivot Data Source
- Clear Sheet/Range/Table
- Copy/Paste Range
- Create Pivot Table
- Delete Column
- Delete Rows
- Delete Sheet
- Duplicate Sheet
- Export to CSV
- Fill Range
- Filter
- Filter Pivot Table
- Find First/Last Data Row
- Find/Replace Value
- For Each Excel Row
- For Each Excel Sheet
- Format As Table
- Format Cells
- Get Cell Color
- Get Excel Chart
- Get Excel Sensitivity Label
- Get Selected Range
- Insert Column
- Insert Chart
- Insert Rows
- Insert Sheet
- Invoke VBA
- Lookup
- Match Function
- Protect Sheet
- Read Cell Formula
- Read Cell Value
- Read Range
- Refresh Excel Data Connections
- Refresh Pivot Table
- Remove Duplicates
- Rename Sheet
- Run Spreadsheet Macro
- Save Excel File
- Save Excel File As
- Save Excel File As PDF
- Select Range
- Sort Range
- Text to Columns
- Unprotect Sheet
- Update Excel Chart
- Use Excel File
- VLookup
- Write Cell
- Write CSV
- Write DataTable to Excel
- Excel Application Scope
- Append To CSV
- Read CSV
- Write CSV
- Delete Column
- Filter Table
- Get Table Range
- Insert Column
- Sort Table
- Append Range
- Close Workbook
- Get Cell Color
- Read Cell
- Read Cell Formula
- Read Column
- Read Range
- Read Row
- Select Range
- Set Range Color
- Write Cell
- Write Range
- Save Workbook
- Create Table
- Get Workbook Sheet
- Get Workbook Sheets
- Refresh Pivot Table
- Create Pivot Table
- Get Selected Range
- Copy Sheet
- Delete Range
- Auto Fill Range
- Copy Paste Range
- Execute Macro
- Insert/Delete Columns
- Insert/Delete Rows
- Invoke VBA
- LookUp Range
- Remove Duplicates Range
- Excel Process Scope
- Manage CSV Files
- Filter CSV Files
- Verify CSV Files
- Table Functions
- Manage Multiple Excel Files
- Interpret Excel Results
- Manage Pivot Tables
- Manage Range Selection
- Read From Excel Files
- Manage Databases in Excel
- Compare CSV Files
- Compare Numeric Values
- Sort Data in Excel Files
- Filter and Delete Rows in Excel Files
- Manipulate Range Selections
- Verify Excel Workbook Data
- Read, Write, and Append Data in Excel
- Google Workspace
- Release notes
- About the Google Workspace activities package
- Project compatibility
- Wait for Calendar Event Created and Resume
- Wait for Calendar Event Received and Resume
- Wait for Calendar Event Replied and Resume
- Wait for Calendar Event Updated
- Wait for Email Received and Resume
- Wait for Email Sent and Resume
- Wait for File Created and Resume
- Wait for File Updated and Resume
- Wait for Folder Created and Resume
- Wait for Sheet Created and Resume
- Wait for Sheet Cell Updated and Resume
- Wait for Task Created and Resume
- Wait for Task Completed and Resume
- Add Attendee
- Create Event
- Delete Event
- Modify Event
- Search Events
- Use Google Drive
- Share File
- Delete File Permission
- Get File Permissions
- Update File Permission
- Copy File
- Create Folder
- Delete File
- Download File
- Find Files and Folders
- Get File Info
- Move File
- Upload File
- Create Document
- Create New Spreadsheet
- Get Mail Messages
- Send Mail Messages
- Change Labels
- Use Google Spreadsheet
- Add Delete Columns
- Add Delete Rows
- Auto Fill Range
- Add New Sheet
- Append Row
- Batch Spreadsheet Updates
- Copy Sheet
- Copy Paste Range
- Delete Range
- Delete Sheet
- Get Cell Color
- Get Sheets
- Read Cell
- Read Column
- Read Range
- Read Row
- Rename Sheet
- Write Cell
- Write Range
- Clear Range
- Download Spreadsheet
- Use Google Document
- Batch Document Updates
- Get Document
- Get Text Index
- Insert Text
- Replace Text
- Read All Text
- Create Script Project
- Get Project Content
- Upload Script File
- Create Deployment
- Run Script
- Mail
- Microsoft 365
- Release notes
- About the Microsoft 365 activity package
- Project compatibility
- Connections
- AddEmailCategories
- ArchiveEmail
- DeleteEmail
- DownloadEmail
- DownloadEmailAttachment
- DownloadEmailAttachments
- ForwardEmail
- GetEmail
- GetEmailAttachmentsInfo
- GetEmails
- GetMailFolders
- GetNewestEmail
- MarkEmailAsRead
- MarkEmailAsUnread
- MoveEmail
- RemoveEmailCategories
- ReplyToEmail
- SendEmail
- TurnOffAutomaticReplies
- TurnOnAutomaticReplies
- Merge multiple sheets into a new summary Excel sheet
- Automatically accept calendar invites from your manager
- Move files to dedicated folders by type
- Verify if new employment documents (I9 and ID) match
- Add new customers to a SharePoint List
- Delete SharePoint List items newer than yesterday
- Notify me on Slack when an important Outlook Email is received
- Include creation date in new OneDrive file names
- Notify me by email when a new file is created
- Microsoft 365 Scope
- Add Sheet
- Append Range
- Clear Range
- Copy Range
- Copy Sheet
- Create Workbook
- Delete Range
- Delete Sheet
- Get Cell Color
- Get Sheets
- Read Cell
- Read Column
- Read Range
- Read Row
- Rename Sheet
- Write Cell
- Write Range
- Set Range Color
- Create Table
- Get Table Range
- Insert Column
- Delete Column
- Insert Rows
- Delete Rows
- VLookup Range
- Use OneDrive & SharePoint
- Copy File/Folder
- Create Folder
- Delete File/Folder
- Download File
- Export File as PDF
- Find Files And Folders
- Get File/Folder
- Move File/Folder
- Upload File
- Share File/Folder
- For Each File/Folder
- Forward Mail
- Get Mail
- Move Mail
- Send Mail
- Reply to Mail
- Delete Mail
- Set Mail Categories
- Add Attachment
- Add Attendee
- Add Location
- Create Event
- Delete Event
- Find Meeting Times
- Get Calendars
- Modify Event
- RSVP
- Search Events
- Create Group
- Delete Group
- Get Group
- List Groups
- Create Bucket
- Delete Bucket
- List Buckets
- List Bucket Tasks
- Create Plan
- Get Plan
- List Plans
- Create Task
- Delete Task
- Get Task
- List Tasks
- Update Task
- For Each List
- Get List Info
- For Each List Item
- Delete List Item
- Add List Items
- Update List Item
- Get List Items
- Presentations
- Release Notes
- About the Presentations activity package
- Project Compatibility
- Add or Update Powerpoint Sensitivity Label
- Add Data Table to Slide
- Add File to Slide
- Add Image or Video to Slide
- Add New Slide
- Add Text to Slide
- Copy Paste Slide
- Delete Slide
- Format Slide Content
- Get Powerpoint Sensitivity Label
- Replace Text in Presentation
- Paste Item Into Slide
- Run Presentation Macro
- Save PowerPoint File As
- Save Presentation as PDF
- Use PowerPoint Presentation
- Word
- Release Notes
- About the Word Activities Package
- Project Compatibility
- Word Application Scope / Use Word File
- Add or Update Word Sensitivity Label
- Add Hyperlink to Document
- Add Picture
- Append Text
- Get Word Sensitivity Label
- Insert DataTable in Document
- Paste Chart/Picture Into Document
- Read Text
- Replace Picture
- Replace Text in Document
- Save Document As
- Save Document as PDF
- Set Bookmark Content
Release notes
Browse the release notes by clicking on the desired version in the table of contents on the right.
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.
Release date: October 31, 2024
Release date: October 10, 2024
Release date: September 26, 2024
Release date: September 24, 2024
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.
GmailMessage
object now includes attachments metadata support.
We added a new AttachmentsInfoList
property which includes the
following metadata: name, size, and extension (MIME type).
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.
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.
Release date: 12 August 2024
Release date: 18 June 2024
- 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 "*".
Release date: 3 June 2024
Release date: 14 May 2024
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.
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.
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.
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.
Release date: 15 April 2024
Release date: 7 March 2024
Release date: 1 March 2024
Release date: 30 January 2024
Release Date: 29 January 2024
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.
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.
GmailMessage
, we added AttachmentsCount
and AttachmentNames
(replacing Attachments
, which has been deprecated), ToAddressList
, CCAddressList
, and BCCAddressList
. For GSuiteEventItem
, we added AttendeesEmailList
and Location
.
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.
Release date: 15 November 2023
Release date: 30 October 2023
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.
Release date: 2 October 2023
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.
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.
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.
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.
Description
property.
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.
Release Date: 12 June 2023
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.
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.Release Date: 27 March 2023
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.
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:
New trigger activities
This release also brings two new trigger activities:
The existing trigger activities were renamed for this release, as follows:
- When an Email is Sent is now called Email Sent
- When New Email Arrives is now called Email Received
- 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.
-
Fixed a bug in the Get Newest Email activity which caused the folder ID to be wrongly attributed.
Release date: 28 February 2023
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.
Release date: 25 January 2023
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:
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
GetSizeInBytes()
— that allows you to retrieve file size for locally downloaded files.
- The Insert Text activity had different property names between the Designer panel and Properties panel.
Release date: 9 May 2022
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.
- Attachment names were being altered and the file extensions removed when sending email using the Send Mail Messages activity.
Release date: 8 November 2021
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.
Release date: 27 October 2021
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.
- 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.
Release Date: 15 April 2021
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.
- 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.
- 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:
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:
Release Date: 17 November 2020
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.
Release Date: 26 October 2020
MicrosoftApplicationInsights
.
GSuite Application scope
InArgument<SecureString>
, SecureCredentialSecret
, in the OAuth Client ID category. If set, the SecureClientSecret
parameter takes precedence over the ClientSecret
parameter.
Get Mail Messages
BodyAsHtml
, has been added.
Release Date: 15 September 2020
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.
Release Date: 15 June 2020
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
- 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.
Release Date: 26 August 2019
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.
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:
Release Date: 19 June 2019
This release introduces integration with Google Docs, enabling automation via the Create Document, Get Document, Get Text Index, Insert Text, and Replace Text activities.
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.
Release Date: 14 March 2019
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.
Release Date: 22 January 2019
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 issue
- v2.7.24
- Bug fixes
- v2.7.23
- Bug fixes
- v2.7.22
- Bug fixes
- v2.7.21
- Google Tasks activities
- Improvements
- Updates in Classic activities
- Working with scopes
- v2.6.24
- Bug fixes
- v2.6.23
- Bug fixes
- v2.6.22
- Bug fixes
- v2.6.21
- Coded workflows support
- New activities
- New features and improvements
- Errata
- v2.5.10
- Bug fixes
- v2.5.9
- Bug fixes
- v2.5.8
- Bug fixes
- v2.5.7
- Bug fixes
- v2.5.6
- Bug fixes
- v2.5.5
- New features and improvements
- Bug fixes
- v2.4.3
- Bug fixes
- v2.4.2
- New features and improvements
- v2.3.4
- Bug fixes
- v2.3.3
- Activity caching
- Improvements in Sheets activities
- General improvements
- v2.2.6
- Bug fixes
- v2.2.5
- Bug Fixes
- v2.2.4
- Bug Fixes
- v2.2.3
- New Features and Improvements
- Bug Fixes
- v2.1.2
- Bug Fixes
- v2.1.1
- New Features and Improvements
- Bug Fixes
- v2.0.3
- Bug Fixes
- v2.0.2
- Improvements
- v2.0.1
- New Features and Improvements
- Bug Fixes
- v1.16.2
- New Features and Improvements
- Bug Fixes
- v1.13.2
- Bug Fixes
- v1.13.1
- New Features and Improvements
- Bug Fixes
- v1.11.0
- New Features and Improvements
- v1.8.0
- New Features and Improvements
- GSuite Application scope
- v1.7.0
- New Features and Improvements
- v1.6.0
- New Features and Improvements
- v1.5.1
- Bug Fixes
- v1.5.0
- New Features and Improvements
- v1.4.0
- New Features and Improvements
- v1.3.1
- Bug Fixes
- v1.3.0
- New Features and Improvements
- v1.2.0
- New Features and Improvements
- Bug Fixes
- v1.1.1
- New Features and Improvements
- Bug Fixes
- v1.0.6961.3913
- Bug Fixes
- v1.0.6961.3913
- New Features and Improvements
- Known issues
- v1.0
- New Features and Improvements