Find Last Empty Cell

Description

Returns the last allocated grid position in a specified row or column of a Google Sheet.

The current activity does not test whether that final cell is empty. Use Find First Empty Cell to locate a gap or the next position after returned data.

Common settings

Use Process Data to bind supported inputs to workflow values or upstream outputs. See Common Activity Features for shared execution, error-handling, and output-persistence settings. Availability depends on the activity.

Design-Time Configuration

Display Text

A user-defined name for the activity, displayed on the workflow canvas to help identify its purpose.

Connection Name

The configured Google Sheets connection used to access Google Sheets resources.

Spreadsheet

The spreadsheet where the search will be performed.

Sheet Name

The name of the sheet where the operation will be performed.

If not specified, the currently active sheet is used.

Row Number

The row to scan horizontally.

The activity returns the final allocated column in this row.

Column Letter

The column to scan vertically.

The activity returns the final allocated row in this column.

note

Specify either Row Number or Column Letter, depending on the desired search direction.

info

For details about selecting spreadsheets and sheets, see Google Sheets Data Selection.

---

Execution settings

Configure Wait All Incoming when execution paths converge, and On Error for failure handling. Select Inherit where available to use the workflow-level error policy.

Output

Cell Address

The address of the final allocated grid cell in the selected row or column. Its contents are not checked.

Example:

B1000

The returned value uses standard A1 notation.

---

Remarks

• The authenticated Google account must have access to the spreadsheet.
• When Row Number is specified, the search is performed across the specified row.
• When Column Letter is specified, the search is performed down the specified column.
• Only one search direction should be specified for a single execution.
• The returned cell address can be used by subsequent Google Sheets activities that accept cell references.

Current behavior

For a sheet with 1,000 allocated rows, Column Letter A returns A1000 even if A1000 contains a value. A row search returns the cell at that row's final allocated column. Check the target before writing to it; do not use this output as an append position without validation.