Skip to main content
Docs
Go to the Studio
Roberty Studio
RPARows

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, 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 column and value must identify a single row.

Value to search for​

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

Row number in the sheet​

Visible when finding by Row number. Enter the row's number in the sheet, the same one shown on the side of Google Sheets (not its position inside the table). The header row is not a data row: in a table whose header is on row 1, the first data row is 2; with the header on row 5, it is 6.

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.