Skip to main content

Find First Empty Cell

Description​

This Activity returns the address of the first empty Cell in the given context. The context could be either a specific column or a specific row inside the specified sheet. The index is defined by its corresponding column letter or row number.

note

This Activity works only inside Google Context activity.

Properties​

Location​

  • Spreadsheet Path / Id - Specify the spreadsheet path or Id inside Google Drive.
  • Index - Specify the row or column index to find the first empty Cell.
info
  • To get the first empty Cell under column D inside a sheet, specify the index value as "D".
  • To get the first empty Cell inside row number 10 inside a sheet, specify the index value as "10".

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 Cell. 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​

  • Cell Address - Returns the address of the first empty Cell.

Example​

Download Example

Find First Empty Cell