Insert Rows

Adds new rows or updates existing rows in a worksheet.

Overview

The Insert Rows node writes data to your spreadsheet. It can:

• Append new rows to a worksheet
• Update existing rows by matching an ID field

Use it to save processed data, create reports, or sync external data.

Parameters

Parameter	Description	Required
Worksheet Name	Target worksheet for the data	Yes
Data	The data to insert (expression)	Yes
Mode	Append new rows or update existing	Yes
ID Field	Field to match for updates (update mode only)	Conditional
Lido Spreadsheet URL	Override the default spreadsheet	No

Mode Options

Mode	Behavior
Append	Add new rows at the end of the worksheet
Update	Find and update rows matching the ID field; append if not found

Data Parameter

The data to insert. Accepts:

• Single object: {{\$item}}
• Array of objects: {{\$item.data.items}}
• 2D array: {{[["A", "B"], ["C", "D"]]}}

Insert current item:

{{$item}}

Insert specific fields:

{{
  {
    Name: $item.data.name,
    Email: $item.data.email,
    Status: "Processed"
  }
}}

Update Mode

When using update mode:

1. Set the ID Field to a unique identifier column
2. The node finds rows where the ID matches
3. Matching rows are updated; non-matching items are appended

Output

Each input item passes through with the same data.

Examples

Append Processed Records

Save each processed item to a Results worksheet:

1. Set Worksheet Name: Results
2. Set Mode: Append
3. Set Data: {{\$item}}

Update Order Status

Update existing orders with new status:

1. Set Worksheet Name: Orders
2. Set Mode: Update
3. Set ID Field: OrderID
4. Set Data: {{ { OrderID: \$item.data.OrderID, Status: \$item.data.newStatus } }}

Selective Field Insert

Only write specific fields:

{{
  {
    Date: $item.data.processedDate,
    Customer: $item.data.customerName,
    Total: $item.data.amount * $item.data.quantity
  }
}}

Tips

• Column headers in the worksheet must match field names
• New columns are not automatically created
• Use expressions to transform data before inserting
• Update mode requires a unique ID field for matching
• Empty fields are written as empty cells
• The node processes items individually by default