Delete row

Remove rows from an existing worksheet

Delete row ${rowNumber} from worksheet My Worksheet in spreadsheet My Sheet

fileId
rowNumber

Use cases

  • Remove subscribers from a subscription list
  • Delete all rows from a sheet

Configuration

Click on the bold text in the title of the building block to open the configuration dialog.

 Reload

Click on the reload icon to scan the template again to track down added or removed variables. If you have renamed your template on Google Drive clicking on this button will also update the document name in Ultradox.

 Edit

Use the edit icon to edit the template in a new browser tab.

Usage

When dragging this block into the flow you can either select an existing spreadsheet from Google Drive or you can create a new one. If you choose to select an existing sheet, a file picker dialog will help you to find the sheet on your Google Drive. Creating a new spreadsheet will open the new sheet in a new browser tab.

After selecting the Google Sheet a dialog will pop up where you can specify the row to be deleted.

As you are deleting an existing row you will have to specify the row number to be deleted. This can either be done by providing a fixed number or a variable containing the row number to be removed.

Useful combinations

Clear worksheet before adding rows

Load worksheet

For each row repeat (1 block)

Before adding rows to a sheet you may want to consider clearing existing entries.

Clear old entries by first loading all rows from the sheet and for each row execute the Delete row building block.

Remove row 2 from sheet

Repeat: Continue with next item

Copy App

Questions and Feedback

If you have any comments on this page, feel free to add suggestions right to the Google document that we are using to create this site.

If you are not yet member of the Ultradox community on Google+, please join now to get updates from our end or to provide feedback, bug reports or discuss with other users.

Last Updated: 11/30/17