Sum or aggregate a column of spreadsheet or table data
Needs changesNeeds changes. This template uses 1 thing(s) that n8n 3.0 removes: Function (legacy). 1 breaking item(s) found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 3 nodes and runs manually, when you click “Execute workflow”. It uses only n8n's built-in nodes.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Mock data (Function): runs custom JavaScript (legacy Function node)
- Summing function (Function): runs custom JavaScript (legacy Function node)
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- Function (legacy) in Mock data, Summing function: replace with Code node, mode 'Run Once for All Items'.
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| Function (legacy) Mock data, Summing function | Code node, mode 'Run Once for All Items' |
Nodes used (2)
- Manual Trigger
n8n-nodes-base.manualTrigger - Function
n8n-nodes-base.function
From the author
This workflow shows how to sum multiple items of data, like you would in Excel or Airtable when summing up the total of a column. It uses a Function node with some javascript to perform the aggregation of numeric data. The first node is simply mock data to…