Edit Spreadsheet

Performs direct spreadsheet operations: insert/delete rows and columns, manage worksheets, update cells, and resize grids.

Overview

The Edit Spreadsheet node provides low-level spreadsheet manipulation. Unlike data-focused nodes like Insert Rows or Update Cell, this node works at the spreadsheet structure level — adding empty rows, deleting columns, creating worksheets, or resizing grids.

Use it to:

• Prepare a spreadsheet before writing data (insert rows/columns)
• Clean up after processing (delete rows/columns)
• Manage worksheets (create, delete, rename)
• Write values to specific cells or ranges
• Resize worksheet grids

Parameters

Parameter	Description	Required
Operation	The spreadsheet operation to perform	Yes
Lido Spreadsheet URL	Override the default spreadsheet	No

Operations

Insert Rows

Parameter	Description	Required	Default
Worksheet Name	Target worksheet	Yes	—
Index	1-based row position to insert at	Yes	—
Count	Number of rows to insert	No	1

Delete Rows

Parameter	Description	Required	Default
Worksheet Name	Target worksheet	Yes	—
Start Index	1-based first row to delete	Yes	—
Count	Number of rows to delete	No	1
Adjust Grid Size	Reduce total row count after deletion	No	false

Insert Columns

Parameter	Description	Required	Default
Worksheet Name	Target worksheet	Yes	—
Index	1-based column position to insert at	Yes	—
Count	Number of columns to insert	No	1

Delete Columns

Parameter	Description	Required	Default
Worksheet Name	Target worksheet	Yes	—
Start Index	1-based first column to delete	Yes	—
Count	Number of columns to delete	No	1
Adjust Grid Size	Reduce total column count after deletion	No	false

Add Worksheet

Parameter	Description	Required
Name	Name for the new worksheet	Yes

Delete Worksheet

Parameter	Description	Required
Worksheet Name	Worksheet to delete	Yes

Rename Worksheet

Parameter	Description	Required
Worksheet Name	Current worksheet name	Yes
New Name	New worksheet name	Yes

Update Cell

Parameter	Description	Required
Cell Reference	Cell address (e.g., A1, Sheet1!B2, or named cell)	Yes
Value	Single value, 1D array, or 2D array	Yes

Set Grid Dimensions

Parameter	Description	Required
Worksheet Name	Target worksheet	Yes
Mode	Set (exact dimensions) or Adjust (add/remove)	Yes
Row Count / Row Count Delta	New total rows or rows to add/remove	Conditional
Column Count / Column Count Delta	New total columns or columns to add/remove	Conditional

Settings

Setting	Description
Execution Mode	Once per item (default) or Once
Output Mode	How to output results when running once
Batch Size	Items to process concurrently (default 5)
Stop on Error	Stop workflow on operation failure

Output

{
  "status": {
    "operation": "insertRows",
    "success": true,
    "message": "Inserted 3 rows at position 5"
  }
}

Access in expressions:

• {{$item.data.status.success}} — Whether the operation succeeded
• {{$item.data.status.message}} — Operation summary

Examples

Insert Rows Before Writing Data

[Get Table] → [Aggregate (count)] → [Edit Spreadsheet (insert rows)] → [Insert Rows]

1. Count how many rows you need
2. Insert that many empty rows at the target position
3. Write data into the newly created rows

Create a New Worksheet per Report

[Scheduled Trigger] → [Edit Spreadsheet (add worksheet "Report-{{$now}}")] → [Template Filler]

Create a fresh worksheet for each report run, then fill it with data.

Write a Range of Values

[Aggregate (collect all)] → [Edit Spreadsheet (update cell A1 with 2D array)]

Update Cell supports 2D arrays for writing ranges:

[
  [1, 2, 3],
  [4, 5, 6]
]

Clean Up Processed Data

[Get Table] → [Process...] → [Edit Spreadsheet (delete rows)]

Tips

• All parameters support expressions for dynamic values
• Update Cell accepts 2D arrays for writing multiple cells at once
• Batch operations (insert/delete rows/columns) are processed efficiently together
• Use Adjust mode in Set Grid Dimensions to add/remove rows/columns relative to current size
• Worksheet management operations (add, delete, rename) execute individually per item