Rearranging arrays

[Msquare_Automation]

Hi @Caine_Wai

Method 1: You need to create the template before the module you are mapping the data from in the iterator.

1. create the spreadsheet from template
2. get the data using your designated module
3. Use add a row module from google sheet.
   Map the spreadsheet ID from “create a spreadsheet using template” module.

It will cost operation for each added row.

Method 2: If you want to save the operations, you can use this approach

Insert multiple rows in Google Spreadsheets from HTTP request that give xml of products

I will divide my answer into 2: Your data is probably in an array, that means you will need to use the array iterator in order to generate a bundle per item (product in you case). Lets say you have this XML: [image] This shows you have multiple products via the Products array, if you take this XML and parse it using the XML parser in make it will look like this: [image] Now we need to map the array into an iterator like so: [image] Once you run this scenario, it will return a bundl…

Method 3: To save more operations, you can go with our Custom App:

Best Google Sheet Custom App | Msquare Automation

If you require additional assistance, please don’t hesitate to reach out to us.
MSquare Support
Visit us here
Youtube Channel