Turning Raw Data into Insight: How Our /aggregate Node Can Help

If you’ve ever pulled a list of items into Make.com (or Zapier, Airtable, or Google Sheets), you’ve probably run into this:

“I have a list of sales… how do I group them by product and calculate the total?”

Or…

“I need to count how many support tickets we received per priority.”

Or even…

“I want to calculate the average discount per product category.”

Make.com gives you the power to connect apps and pass data, but summarizing or aggregating data? That’s still shockingly hard without custom code or painful workarounds.

The Solution: `/aggregate` – a Smart Node for Grouping and Summarizing

We built a new endpoint in NodeTrigger: /api/aggregate.

This small but powerful node turns any raw list of items into grouped summaries with totals, averages, and counts — all in one API call.

Real Use Case: Grouping Sales by Category

Let’s say your automation pulls sales records from Stripe, Airtable, or your custom CRM.

Each record looks like this:

{
  "category": "Books",
  "price": 20,
  "discount": 5
}

You’ve got hundreds of them — and you want to build a dashboard, chart, or summary like:

Category	Count	Total Revenue	Avg Discount
Books	12	$240	$3.50
Toys	5	$80	$1.20

Here’s all you do:

Send a POST request to:

https://node.nodetrigger.com/api/aggregate

With this body:

{
  "array": [ ... your sales data ... ],
  "groupBy": "category",
  "operations": {
    "count": true,
    "sum": ["price"],
    "average": ["discount"]
  }
}

And get this response:

[
  {
    "category": "Books",
    "count": 12,
    "sum_price": 240,
    "avg_discount": 3.5
  },
  {
    "category": "Toys",
    "count": 5,
    "sum_price": 80,
    "avg_discount": 1.2
  }
]

That’s it — you’re done. No JavaScript needed. No looping modules. Just clean summaries, ready to drop into Make, dashboards, emails, or reports.

Why This Node Matters

It replaces custom code with a one-step API
It reduces steps in Make.com dramatically (no need for iterators, filters, and aggregators)
It’s flexible: sum, count, average — use one or all
It’s fast: ideal for use with large data pulled from Airtable, MySQL, APIs, and more

What’s Next?

Use /aggregate anywhere you’d build a chart, table, or summary from raw data.

Group invoices by month and total the revenue
Count form submissions by source (e.g. “Facebook”, “LinkedIn”)
Calculate average score per product in reviews
Total hours worked per employee

Ready to Try It?

Hit the endpoint at:

POST https://node.nodetrigger.com/api/aggregate

The Solution: /aggregate – a Smart Node for Grouping and Summarizing