Skip to main content
Version: Current

Find Last Empty Cell

Description​

Finds the last empty cell along a specified row or column in a Google Sheet.

The activity can search horizontally across a row or vertically down a column and returns the address of the last empty cell found.

Common Capabilities​

Process Data Support​

info

This activity supports dynamic configuration using variables from the Process Data drawer.

You can bind values from Model Data, Form Data, System Data, Enterprise Variables, and Activity Outputs.

Learn more → Using Process Data

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.

Use this option to find the last empty cell within a specific row.

Column Letter​

The column to scan vertically.

Use this option to find the last empty cell within a specific 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.

Wait All Incoming​

Execution Control

Controls how this activity behaves when multiple incoming execution paths converge.

Determines whether the activity executes when:

  • Any incoming path completes, or
  • All relevant incoming paths complete before execution

Learn more → Execution Control

On Error​

Error Handling Strategy

Defines how the workflow behaves if this activity encounters a runtime error.

Supported strategies include:

  • Fault
  • Continue
  • Suspend
  • Retry

Learn more → Error Handling

Output​

Cell Address​

The address of the last empty cell found.

Example:

B5

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.