Add Rows

Create multiple new rows in a Smartsheet sheet.

Smartsheet only allows 5000 rows per sheet.

Options

Field Definition Type Required
Your Smartsheet sheets Select from the list of all available Smartsheet sheets associated with your Smartsheet instance. Choose Insert ID to select a Smartsheet sheet by its ID, which is entered in the Input section.

Dropdown

TRUE

Row Position Select the location within the sheet where the row will be added:
  • Top of Sheet : Adds the row at the top of the sheet.
  • Bottom of Sheet : Adds the row at the bottom of the sheet.
  • Above Row: Adds the row above a row that you specify.
  • Below Row: Adds the row below a row that you specify.
  • To Parent Row (top): Adds the row as the top child row to a parent row that you specify.
  • To Parent Row (bottom): Adds the row as the bottom child to a parent row that you specify.

Dropdown

TRUE

Input

The input fields for this card are dynamically generated based on your instance.

Field Definition Type Required

Sheet

Row ID

Unique identifier of the sheet.

Text

TRUE

Add

Rows Each added row is an object. The best way to construct these objects is with a Build Row Object card, accompanied by a List Construct card.
  • For each row added, a build row object card is needed. Each build row object card takes a text input for each column in the associated sheet.
  • Drag the row output on each build row object card into a list construct card.
  • Drag the list output from the list construct card into the rows input on the add rows card.

List

FALSE

Location

Row ID

Unique identifier of the row.

Text

FALSE

Output

Field Definition Type
Row IDs List of row IDs for each created Smartsheet row.

List

Related topics

Smartsheet connector

Workflow elements

Smartsheet API Reference