Skip to main content
Go to the Studio
Rows

Delete row

Delete row

Deletes a row of the table, found by its row number or by a column/value filter.


Options​

Google Sheets connection​

Select the Google Sheets Connection action set up in the flow.

Spreadsheet ID​

Enter the ID of the spreadsheet. The ID can be found in the spreadsheet URL: docs.google.com/spreadsheets/d/{spreadsheetId}/edit.

Table name​

Enter the name of the table (named range), for example Clientes.

Find the row by​

Choose how the row is found: Column and value (default) or Row number.

Column to search in​

Visible when finding by Column and value. Enter the exact column name, as it appears in the table header, for example Email. The first row matching that column/value is deleted.

Value to search for​

Visible when finding by Column and value. Enter the value to search for in the given column.

Row number​

Visible when finding by Row number. Enter the number of the row to delete, counting the table's header row as row 1.

Returns​

Javascript code​

js
actions["action-id"].rowNumber // number of the row deleted (Number)

Field selection​

  • rowNumber — Number of the row deleted.

Rules and Conditions​

  • The Google Sheets connection, Spreadsheet ID and Table name fields are required.
  • When finding by Column and value, the Column to search in and Value to search for fields are required. When finding by Row number, the Row number field is required.
  • The given table must exist in the spreadsheet and have a bounded row range (with a defined end); otherwise the robot stops with an error.
  • When finding by Column and value: if no row matches, the robot stops with a row-not-found error; if more than one row matches, the robot stops with an ambiguity error (use a column with unique values, or delete by row number).
  • When finding by Row number: if the row does not exist within the table's bounds, the robot stops with a row-not-found error.
  • The deletion removes the whole row from the tab (shifting the following rows up) and automatically resizes the table range to reflect the removed row.
  • This action does not return the deleted row, only the number of the row that was removed.