Create multiple new rows in a Smartsheet sheet. NOTE: Smartsheet only allows 5,000 rows per sheet.

Options

  • Your Smartsheet sheets (dropdown list): a list of all available Smartsheet sheets associated with your Smartsheet account.
  • Row Position (dropdown list):
    • Top of Sheet - This will add the row at the top of the sheet
    • Bottom of Sheet - This will add the row at the bottom of the sheet
    • Above Row - This will add the row above a row that you specify
    • Below Row - This will add the row below a row that you specify
    • To Parent Row (top) - This will add the row as the top child row to a parent row that you specify
    • To Parent Row (bottom)  - This will add the row as the bottom child to a parent row that you specify

Input Fields

  • Add Rows (object): Each added row is an object. The best way to construct these objects is with a Build Row Object card, accompanied by a 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.

Output Fields

  • Row
    • id (array): An array of the Smartsheet IDs for each created row