Google spreadsheet putting data in 1 row, instead of separate rows

How To
1

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?

2

Hey @Ayman

welcome to the make community

Can you share the blueprint of the scenario?

And If your data is in separate bundles, it will go into separate rows."

3

blueprint.json (36.6 KB)

Hereby the blueprint

4

@Ayman
Mapping and modules are working correctly. Make sure your output from the JSON is in separate bundles

5

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?