Skip to content

Summarize#

Use the Summarize node to aggregate items together, in a manner similar to Excel pivot tables.

Examples and templates

For usage examples and templates to help you get started, refer to n8n's Summarize integrations page.

Node parameters#

  • Fields to Summarize:
    • To combine values, select an Aggregation method, and enter a Field name.
    • To split values, enter a field name or list of names in Fields to Split By.
  • Options > Add Field: use this to add more optional settings, including:
    • Disable Dot Notation: when disabled, you can't reference child fields (in the format parent.child).
    • Output Format:
      • Each Split in a Separate Item: splitting generates a separate output item for each split out field.
      • All Splits in a Single Item: splitting generates a single item, which lists the split out fields.
    • Ignore items without valid fields to group by: ignore input items that don't contain the field specified in Fields to Summarize.

View example workflows and related content on n8n's website.

Learn more about data structure and data flow in n8n workflows.