Skip to main content
Version: Current

Find Last Empty Row And Column

Description​

Finds the last completely empty row and the last completely empty column within a Google Sheet.

The search can be performed across an entire sheet or restricted to a specific range.

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.

Range​

The range within which to search for empty rows and columns.

If not specified, the entire sheet is searched.

info

For details about selecting spreadsheets, sheets, and ranges, 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​

Row Number​

The number of the last completely empty row found.

Example:

10

Column Letter​

The letter of the last completely empty column found.

Example:

AA

Remarks​

  • The authenticated Google account must have access to the spreadsheet.
  • If a range is specified, only cells within that range are considered when determining whether a row or column is empty.
  • A row is considered empty when all cells within the search scope are empty.
  • A column is considered empty when all cells within the search scope are empty.
  • The returned row number and column letter can be used by subsequent Google Sheets activities.

Set Range to A1:D10. Only values within those four columns and ten rows determine whether a row or column is empty. Empty, null, and whitespace-only returned values are treated as empty.

The search starts at the bottom/right. With no empty row or column in the selected range, the corresponding output is an empty string.

Leaving Range empty searches the allocated sheet grid, including unused trailing rows and columns. Use a bounded range when a gap inside a data area is the intended result.

Help improve this page