Skip to main content

Transformation Nodes

Transformation nodes modify, reshape, and process your data as it flows through the workflow.

Overview​

These nodes change item data without reading from or writing to external sources:

  • Edit Item - Add, modify, or remove fields
  • Aggregate - Group items and calculate summaries
  • Split - Expand arrays into multiple items
  • Merge - Combine multiple input streams
  • Limit - Restrict the number of items
  • JS Code - Execute custom JavaScript
  • Sheet Calc - Evaluate spreadsheet formulas

Common Patterns​

Field Mapping​

Use Edit Item to rename fields or add calculated values.

Data Summarization​

Use Aggregate to group and summarize data with operations like SUM, AVG, and COUNT.

Data Expansion​

Use Split to turn array fields into individual items.

Stream Combination​

Use Merge to combine data from multiple sources with joins or appends.

Available Nodes​