Find First Empty Row And Column

Description

This activity gets the first empty Row and Column address inside the specified sheet.

note

This activity works only inside Google Context activity.

Properties

Location

• Spreadsheet Path / Id - Specify the relative spreadsheet path or Id inside Google Drive.

Misc

• DisplayName – Add a display name to your activity.
• Private – Logs the variable and argument values at the Verbose level when unchecked.

Optional

• Sheet Name - The sheet's name where you want to find the first empty Row and Column. By default, it operates on the currently active sheet.
• Continue On Error – Specifies if the automation should continue even when the Activity throws an error. This field only supports Boolean values (True, False). The default value is False.
  note

  Catches no error if this Activity is present inside the Try-Catch block and the value of this property is True.

Output

• Row Address - Returns the address of the first empty Row.
• Column Address - Returns the address of the first empty Column.

Example

Download Example