Skip to main content

Find Last Empty Cell

Description​

Using this Activity, you can quickly obtain the location of the last vacant Cell in a particular row or column of a designated spreadsheet. The location is per the specified sheet's input column or row.

note

This Activity works only inside Google Context activity.

Properties​

Location​

  • Spreadsheet Path / Id - Specify the relative or absolute spreadsheet path or Id inside Google Drive.
  • Row Number - Specify the row number to find the last empty Cell.

    or​

  • Column Name - Specify the column name to find the last empty Cell.
info
  • To get the last empty Cell under column D inside a sheet, specify the column name value as "D".
  • To get the last empty Cell inside row number 10 inside a sheet, specify the row number 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 first 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 last empty Cell.

Example​

Download Example

Find Last Empty Cell