Google spreadsheet putting data in 1 row, instead of separate rows out of a JSON file

Hi Everyone. I made a scenario in Make where data is extracted from an E-mail and Parsed with Json. The data is then put in Google spreadsheet, however it puts all data in 1 row instead of separate rows. I am extracting three variabels; productID, productname and number of items. So for example;

JSON string
{
“Productname”: “ANANAS STUKS KL (580 ML)”,
“ProductID”: “1500”,
“number of items”: “1”
}

{
“Productname”: “ANANAS STUKS GR (3100 ML)”,
“ProductID”: “1505”,
“number of items”: “2”
}

I linked it with a google spreadset table, but it puts all information in 1 row, for example:

|ProductID|Productnaam|Aantal|
|1500, 1505|ANANAS STUKS KL (580 ML), ANANAS STUKS GR (3100 ML)|1, 2|

However I want separate rows, how can I achieve this? I have made it into separate bundles, however in the google spreadsheet I need to mark each bundle which each row, but for example there could be sometimes 10, sometimes 15, sometimes less, and it needs to automatically add each bundle to each row. How do I do this?

blueprint (1).json (23.5 KB)

Welcome to the Make community!

After your Parse JSON module, you need to add an Iterator-ArrayAggregator pair like this:

Every result (item/record) from an Iterator module will output a bundle. To “combine” them into a single structure, you’ll need to use an aggregator of some sort.

Aggregators are modules that accumulate multiple bundles into one single bundle. An example of a commonly-used aggregator module is the Array aggregator module.

The Array Aggregator module allows you to build a complex array of collections for a later module’s field to map multiple items (collections) to it.

Here is an example of using the “Target structure type” of an Array Aggregator module:

As you can see, the “Map” toggle on fields are used when you have an array. You can easily build an array variable to map to a field, by using an Array Aggregator module and select the “Target Structure Type” as the future field you want to map the array into.

Hope this helps! Let me know if there are any further issues!

samliewrequest private consultation

Join the Make Fans Discord server to chat with other makers!

Hi I have tried it (see blueprint) but it still does not add the information in the correct way in the google spreadsheet. It puts it all in 1 row.

blueprint (2).json (25.2 KB)

Please provide a screenshot of your Array Aggregator module fields.

Hi @samliew hereby the screenshots

Translations:
Product naam = Product name
ProductID = ProductID
Aantal = number of items ordered





This is incorrect. The earlier provided instructions were not followed yet.

Hope this helps! Let me know if there are any further issues!

samliewrequest private consultation

Join the Make Fans Discord server to chat with other makers!

@samliew what do I fill in the places (rows) in the following screenshot:

You can add more columns and then map the variables into the columns.