Sheet Calc

Evaluates spreadsheet formulas and returns calculated results.

Overview

The Sheet Calc node applies spreadsheet formula logic to your workflow data. Use it to:

• Apply familiar spreadsheet functions
• Calculate values using cell-style formulas
• Leverage Lido's formula capabilities in workflows
• Execute spreadsheet actions with CHAIN()

Parameters

Parameter	Description	Required
Sheet Expression	The spreadsheet formula to evaluate	Yes
Context Cell	Cell reference for evaluation context	No
Split Rows	Create separate items for multi-row results	No
Run Action	Execute as action command using CHAIN()	No
Lido Spreadsheet URL	Override the default spreadsheet	No

Sheet Expression

Write spreadsheet formulas. Supports expressions with {{...}} to inject item data:

=SUM({{$item.data.values}})
=IF({{$item.data.amount}} > 1000, "High", "Low")
={{$item.data.price}} * {{$item.data.quantity}}

Context Cell

Specify a cell location (e.g., Sheet1!A1) to provide spreadsheet context for formula evaluation. This affects relative references in the formula.

Split Rows

When the formula returns multiple rows, create separate output items for each row instead of returning them all in one item.

Run Action

When enabled, the expression is executed as an action command using CHAIN(). Use this for formulas that perform actions rather than just returning values.

Output

The evaluated result. By default returns a 2D array of calculated values.

Single value result:

{
  "result": 500
}

Multi-row result (split enabled): Multiple items, one per row.

Multi-row result (split disabled):

{
  "result": [[1, 2], [3, 4], [5, 6]]
}

Examples

Basic Calculation

Calculate a percentage:

={{$item.data.value}} * 0.1

Using Spreadsheet Functions

Apply text functions:

=UPPER({{$item.data.name}})

=CONCATENATE({{$item.data.firstName}}, " ", {{$item.data.lastName}})

Conditional Logic

Use IF for conditional values:

=IF({{$item.data.amount}} > 1000, "High", "Normal")

Math Functions

Apply mathematical operations:

=ROUND({{$item.data.price}} * {{$item.data.quantity}}, 2)

Array Formulas

Sum an array of values:

=SUM({{$item.data.values}})

Reference Spreadsheet Data

Reference cells in your spreadsheet:

=VLOOKUP({{$item.data.productId}}, Products!A:C, 3, FALSE)

Tips

• Uses Lido's spreadsheet formula engine
• Inject item data using {{\$item.data.fieldName}} syntax
• Standard spreadsheet functions are available
• Use Context Cell for formulas with relative references
• Enable Split Rows when each row should be processed separately
• Use Run Action for formulas that trigger side effects