Back to Workflows

Sum or aggregate a column of spreadsheet or table data

Apps in this workflow

Share

Details

Created 1 year ago by maxt
eye 9 views
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

Implement complex processes faster with n8n

red icon yellow icon red icon yellow icon