My JSON returns all data as one bundle instead of multiple — how do I get one JSON bundle per row

Hi Make Community :waving_hand:
I’m working on a scenario where I pull data (from Notion or Google Sheets) and then format it as JSON to send to another module.

My issue is that I’m using the JSON from Array aggregator, but instead of getting multiple small bundles (one per row/record), I get one single bundle containing all values merged together in one long array.

What I want is for Make to output one JSON bundle per record, so I can process each row separately — for example, each address or house as its own bundle. This is going to be in the google sheets bulk update rows module.

Here’s an example of what I’m getting right now (everything merged into one bundle):

Instead i want the data to be formatted like this:

This is just an example, and in reality this is just optimally how the first two bundles should look like. And thus not all the data is used here.

This is what my JSON code looks like:

Here is my full scenario:

I hope you can help me. Let me know if you need any other information than what i have included in this post.

Best regards Silas

Add an Iterator module right after your Array Aggregator.

Setup:

  1. Keep your current Array Aggregator as is
  2. Add Iterator module after it
  3. In the Iterator, select the array output from your aggregator
  4. The Iterator will split your aggregated data back into individual bundles
  5. Now each bundle goes to Bulk Update separately

This way you keep your JSON structure but process each row individually.

Sam @ Flow Digital

Hi, thanks for your reply.

The way that you explain i should fix my scenario, is going to use up my credits way faster than i expect. This is because the iterator seperates all the bundles from the aggregator, and makes the modules afterwards run once per bundle - which kind of destroys the idea of using the “Bulk update rows”-module

Do you have any other ideas for how i can fix my problem, but still keep my use of credits low?