Insert Rows

This action inserts one or more rows in a spreadsheet.

Properties

The Insert Rows action can be configured using the following properties:

Insert Where

This option specifies where to insert the rows. Options are:

  • First
  • Before (Default)
  • After
  • Last

When a cell range is selected, the Before option inserts a row before the range, and the After option inserts a row after the range, while the First option inserts a row at the beginning within the range, and the Last option inserts a row at the end within the range.

Number of Rows

The number of rows to insert.

Set as Named Range

Range name options are:

  • Auto (Default)
  • Named: If you select this option, specify a name of the range.
Range Name

Has two options: Auto or Named.

Auto: Gives the item a name that is a number. The first auto-numbered item is 1, the next is 2, and so on.

Named: Gives the item a fixed and explicitly stated name.

See Named Tags, Ranges, and JSON for details.