Row Added to the Bottom of a Sheet

UiPath.GSuite.Activities.Sheets.Triggers.RowAddedToSheetBottom

Description

Starts the automation when a new row is added to the bottom of a sheet (tab).

Scopes

This activity requires the following scopes:

• https://www.googleapis.com/auth/drive.readonly
• https://www.googleapis.com/auth/spreadsheets.readonly
• https://www.googleapis.com/auth/spreadsheets
• https://www.googleapis.com/auth/drive

Project compatibility

Windows | Cross-platform

Configuration

• Google Sheets connection - The connection for the Google Workspace account to use in the activity.

• Spreadsheet - The Google spreadsheet to use. Click the Folder icon to browse Google Drive folders and select a spreadsheet.

  • Select the Reload File Picker option if you've modified your folders and need to retrieve the latest data.

• Sheet name - The sheet to be monitored.

  • Select the Update Sheets option if you've modified your sheets and need to retrieve the latest data.

• Has headers - Specifies whether the first row in the sheet has headers. Boolean value.

Output

• Spreadsheet - The Google spreadsheet file, saved as a GDriveRemoteItem variable. Automatically generated output variable. You can use it as it is or save it with a different name.

• Job Data - Contains job info, such as Process name, Process version, Workflow name, Robot name, and mode of execution.

  Row added - The row that was added to a sheet, saved to a DataRow variable. Automatically generated output variable. You can use it as it is or save it with a different name.

Example

See also:

• Sheets activities
• For Each Sheet in Spreadsheet
• Read Range