- 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
Use Google Spreadsheet
UiPath.GSuite.Activities.Sheets.GoogleSheetsApplicationScope
Opens an existing Google spreadsheet or creates a new Google spreadsheet to use in the automation. After you add this activity, add the activities that work with data from the sheet inside Use Google Spreadsheet. If using an existing file, when you configure the activities added inside it, you can select data such as named ranges or sheets directly from the Plus menu.
Use Google Spreadsheet is compatible with the following activities: Add New Sheet, Batch Spreadsheet Updates, Clear Range, Copy Sheet, Delete Range, Delete Sheet, Download Spreadsheet, Read Cell, Read Range, Rename Sheet, Write Cell, Write Range. Starting with v1.12.0, it is also compatible with Append Row, Get Cell Color, Get Sheets, Read Column, and Read Row.
In the Body of the Activity
- Account - Select the account to use.
-
Action - Select if you want to use an existing file or create a new file:
- Use existing - Select an existing file.
- Create new - Create a new file with the specified name in the specified folder.
- Create if not exists - Use an existing file if the specified name is found in the specified folder, or create a new file if a file is not found. If multiple files with the specified name are found, an error occurs.
-
Indicate the file to use:
- Browse - Click Browse to select the file (for Use Existing) or the folder where to create the file (for Create new and Create if not exists).
- Enter id - Click Plus and use one of the options in the menu to specify the ID of the file to use (for Use Existing) or of the folder where to create the file (for Create new and Create if not exists). For example, if you saved the file ID for later use in a G Drive activity earlier in the automation, select the saved value.
- File name - For Create new and Create if not exists, click Plus and use one of the options in the menu to specify the name of the file.
- Reference as - Enter a
name by which to refer to the file in the automation project. The default value
is
Spreadsheet
.
The way you indicate the account to use depends on whether or not the Use Connections option is selected in the Properties panel. When the option is selected, it indicates that the Integration Service in Automation Cloud manages the connection. When not selected, it indicates you are connecting using an application set up in Google Cloud.
When Using the Integration Service
Add a new account or use an account connection you already added to the Integration Service.
- If a connection does not already exist, select Add new account from the drop-down menu to add a new account connection. A browser window opens and you are prompted to select the account to use and grant the required permissions to UiPath. The connection is created in Integration Service and is labeled as the default connection.
- If existing account connections have already been added, they are automatically detected and displayed in the menu. To add multiple accounts, simply click the drop-down menu and select Add new account to add another account connection.
When Not Using the Integration Service
Add a new account or select an account you already added from a Use Google Spreadsheet activity.
- If you choose to add a new account and the G Suite client ID and secret are added in Orchestrator, you are prompted to sign in to your Google account.
-
If you choose to add a new account and the G Suite client ID and secret are not added in Orchestrator, the Add Gmail Account dialog box opens to help you add the account:
- Authentication type - Select Default to use the UiPath client ID and secret, or select My ID/Secret to enter your organization's own client ID and client secret in the provided fields.
- Click OK to sign in to your Google account.
Properties Panel
Common
- ContinueOnError - If set, the remaining activities are executed if the current activity fails. This field supports Boolean values.
- DisplayName - The name
displayed for the activity in the Designer panel. This property supports
String
variables and string formatted values. - Timeout - How many seconds
to wait for the browser authentication process to complete before generating an
error. The default value is 90 seconds. This property supports
Int32
variables and Int32 formatted values.
Input
- File name - The name of
the file to create. This property supports
String
variables and string formatted values. - Spreadsheet file - The
existing file to open. This property supports
String
variables and string formatted values.
Integration Service
- Use Connections - If selected, the Integration service in Automation Cloud manages the connection. This field supports Boolean values.
Misc
- Private - If selected, the data used in the activity is not logged by StudioX. This field supports Boolean values.
OAuth Client ID
- ClientId - Read-only, this is set when the account is added.
- ClientSecret - Read-only, this is set when the account is added.
- Google Account - Read-only, this is set when the account is added.
Output
- File ID - The ID of the file opened or created by the activity.