Skip to main content
Version: Current

Delete Rows

Description​

Deletes one or more rows from a Google Sheet.

All cells within the deleted rows are removed, and the remaining rows are shifted to close the gap.

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 containing the rows to delete.

Sheet Name​

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

If not specified, the currently active sheet is used.

Selection Type​

Determines whether a single row or a range of rows will be deleted.

Row Number​

The row to delete.

Required when Selection Type is set to Single.

From​

The starting row of the range to delete.

Required when Selection Type is set to Multiple.

To​

The ending row of the range to delete.

Required when Selection Type is set to Multiple.

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​

Result​

A Boolean value indicating whether the delete operation completed successfully.

ValueMeaning
TrueThe specified rows were successfully deleted.
FalseThe delete operation was unsuccessful.

Remarks​

  • The authenticated Google account must have permission to modify the spreadsheet.
  • Deleting a row removes all data contained within that row.
  • When multiple rows are deleted, all rows within the specified range are removed.
  • Remaining rows are automatically shifted to close the gap created by the deletion.
  • Existing formulas, references, charts, and dependent calculations may be affected by the deletion.