Insert Cells
Description
Inserts new empty cells at a specified location in a Google Spreadsheet, shifting existing content to accommodate the new cells.
Common Capabilities
Process Data Support
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
The label for this activity as it appears on the workflow canvas.
Connection Name
Select the configured Google Drive connection used to authenticate and access the spreadsheet.
Spreadsheet
The file path or unique Spreadsheet ID of the Google Spreadsheet stored in Google Drive.
See this guide for details on using file paths and IDs.
Sheet Name
The name of the sheet where the operation will be performed.
If left empty, the currently active sheet is used.
Selection Type
Specifies whether to insert a single cell or a range of cells.
Cell Address
The address where the new cell will be inserted (for example, A1).
Required when Selection Type is set to Single.
From
The top-left cell of the range where new cells will be inserted (for example, A1).
Required when Selection Type is set to Multiple.
To
The bottom-right cell of the range where new cells will be inserted (for example, C5).
Required when Selection Type is set to Multiple.
Shift Direction
Determines how existing cells are shifted to make room for the new cells
(for example, Shift Down or Shift Right).
Wait All Incoming
Controls how this activity behaves when multiple incoming execution paths converge.
Choose whether the activity runs when:
- any incoming path completes, or
- all relevant incoming paths complete before execution
Learn more → Execution Control
On Error
Defines how the workflow behaves if this activity encounters a runtime error.
Supported strategies include Fault, Continue, Suspend, and Retry.
Output
Returns True if the cells were successfully inserted; otherwise returns False.