Skip to main content
Version: Current

Insert Cells

Description​

Inserts one or more cells into a Google Sheet.

Existing cells are shifted to create space for the newly inserted cells.

Common Capabilities​

Process Data Support​

info

This activity supports dynamic configuration using variables from the Process Data drawer.

You can bind values from Model Data, Form Data, System Data, Enterprise Variables, and Activity Outputs.

Learn more → Using Process Data

Design-Time Configuration​

Display Text​

A user-defined name for the activity, displayed on the workflow canvas to help identify its purpose.

Connection Name​

The configured Google Sheets connection used to access Google Sheets resources.

Spreadsheet​

The spreadsheet where the cells will be inserted.

Sheet Name​

The name of the sheet where the operation will be performed.

If not specified, the currently active sheet is used.

Selection Type​

Determines whether a single cell or a range of cells will be inserted.

Cell Address​

The cell at which the new cell will be inserted.

Required when Selection Type is set to Single.

From​

The starting cell of the range to insert.

Required when Selection Type is set to Multiple.

To​

The ending cell of the range to insert.

Required when Selection Type is set to Multiple.

Shift Direction​

Determines how existing cells are shifted to create space for the inserted cells.

Supported options include:

  • Shift Down
  • Shift Right
info

For details about selecting spreadsheets, sheets, and cell ranges, see Google Sheets Data Selection.

Wait All Incoming​

Execution Control

Controls how this activity behaves when multiple incoming execution paths converge.

Determines whether the activity executes when:

  • Any incoming path completes, or
  • All relevant incoming paths complete before execution

Learn more → Execution Control

On Error​

Error Handling Strategy

Defines how the workflow behaves if this activity encounters a runtime error.

Supported strategies include:

  • Fault
  • Continue
  • Suspend
  • Retry

Learn more → Error Handling

Output​

Result​

A Boolean value indicating whether the insert operation completed successfully.

ValueMeaning
TrueThe specified cells were successfully inserted.
FalseThe insert operation was unsuccessful.

Remarks​

  • The authenticated Google account must have permission to modify the spreadsheet.
  • Inserting cells affects only the selected cells and does not insert entire rows or columns.
  • When Shift Down is selected, existing cells below the insertion point are moved downward.
  • When Shift Right is selected, existing cells to the right of the insertion point are moved right.
  • Existing formulas, references, charts, and dependent calculations may be adjusted automatically by Google Sheets.
  • To insert entire rows or columns, use the Insert Rows or Insert Columns activities.