I have an array that has multiple collections of collections
I want Each one “1, 2, 3” To be a new row on a google sheets. Can someone help me with this, I am confused.
I have noticed if when i call the array and add a “2” it gets the information from that collection. Hopefully that makes sense. However I am still stumped
Welcome to the Make community!
You’ll need to use a second module to insert the values as separate rows into the created spreadsheet.
Try using the Google Sheets “Bulk Add Rows (Advanced)” module:
Appends multiple rows to the bottom of the table.
For more information, see https://www.make.com/en/integrations/google-sheets, and https://www.make.com/en/help/app/google-sheets in the help centre.
The Array Aggregator module is very powerful because it allows you to build a complex array of collections for a later module’s field to map multiple items (collections) to it.
This is done using the “Target structure type” of an Array Aggregator module.
Here is an example:
As you can see, the “Map” toggle on complex fields are used when you have an array. You can easily build an array variable to map to a future module’s field, by using an Array Aggregator module and select the “Target Structure Type” as the future module’s field you have mapped the array into.
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.
Hello @gavien,
Just use Iterator after Array Aggregator and then use your Google Sheet.
In the Google Sheets module select data based on the Iterator module.
