Sum or aggregate a column of spreadsheet or table data

Published 2 years ago

Created by

maxt
Max Tkacz

Categories

Building Blocks

Template description

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 avoid needing a credential to run the workflow. The second node actually performs the summation - the javascript has various comments in case you need to edit the JS. For example, to sum multiple items of data.

Below is an example of the type of data this workflow can sum - so anything that is in a tabular form (Airtable, GSHeets, Postgres etc).
Screenshot 20220228 at 18.31.25.png

Share Template

Implement complex processes faster with n8n

red icon yellow icon red icon yellow icon