Insert range action

The Insert range action of the Google Sheets package enables you to insert the range into the current worksheet without overwriting the existing value.

Settings

  • Enter the session name or select an existing variable used in the Session name field .
  • Enter the cell range in the Range address. For example A1:B4. This inserts a range of cells consisting of the first four rows by the first two columns.

    After inserting the cell, set the Shift type to Down to shift the existing values down by the specified number of rows. Or Right to shift the existing values right by the specified number of columns.