Update Cell

Updates specific cells or ranges in a spreadsheet.

Overview

The Update Cell node writes values to specific cell locations. Unlike Insert Rows, it targets exact positions rather than appending data.

Use it to:

• Update summary cells
• Write values to specific locations
• Modify cells based on calculations

Parameters

Parameter	Description	Required
Cell Reference	The cell or range to update	Yes
Value	The value to write	Yes
Lido Spreadsheet URL	Override the default spreadsheet	No

Cell Reference

Specify cells using standard spreadsheet notation or named cells:

Examples:

A1                  // Cell A1 in default sheet
Sheet1!B5           // Cell B5 in Sheet1
Summary!C10         // Cell C10 in Summary sheet
myNamedCell         // A named cell

Value

The value to write to the cell. Supports expressions and different data types:

Single value:

{{$item.data.total}}

1D array (writes as row):

{{[$item.data.jan, $item.data.feb, $item.data.mar]}}

2D array (writes as range):

{{[[1, 2], [3, 4]]}}

Output

The input item passes through unchanged after the cell is updated.

Examples

Update a Summary Cell

Write a calculated total to a specific cell:

1. Cell Reference: Summary!B2
2. Value: {{\$item.data.grandTotal}}

Write Monthly Values to a Row

Write an array to consecutive cells:

1. Cell Reference: Report!B5
2. Value: {{[\$item.data.jan, \$item.data.feb, \$item.data.mar, \$item.data.apr]}}

This writes to B5, C5, D5, E5.

Update Named Cell

Use a named cell for clearer references:

1. Cell Reference: TotalRevenue
2. Value: {{\$item.data.revenue}}

Write a 2D Range

Write a grid of values:

1. Cell Reference: Data!A1
2. Value: {{\$item.data.matrix}}

If matrix is [[1, 2], [3, 4]], this writes:

• A1: 1, B1: 2
• A2: 3, B2: 4

Tips

• Cell references are case-sensitive for sheet names
• Single values write to a single cell
• 1D arrays write horizontally (as a row)
• 2D arrays write as a rectangular range
• Invalid cell references will cause errors
• Use named cells for more maintainable workflows