Use Google Spreadsheet

UiPath.GSuite.Activities.Sheets.GoogleSheetsApplicationScope

Description

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.

Project compatibility

Windows - Legacy | Windows

Configuration

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.

Selecting An Account

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.