As you can see the image attached I got an .csv attachment from gmail and I wanted to put it in google sheet. The current approach works but every row needs one operation which is too costly. I tried to use the “bulk add rows” module instead but it seems that it also costs one operation for each row. I am wondering if there are some alternative approaches to using only one operation for each file? TIA!
Welcome to the Make community!
This is the way.
You probably needed to use an Array Aggregator to combine all the bundles into a single “Rows” array, so that it will only use a single operation.
Every result (item/record) from a iterator/search/list/parse 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.
Read This
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.
I suggest doing the Make Academy if you haven’t yet.
samliew – request private consultation
Join the Make Fans Discord server to chat with other makers!
1 Like
Thanks so much! Would you mind specifying where I should put the array aggregator and what I should set for it? I am so confused 
really appreciate your instruction!!
Delete the Iterator.
Put an Array Aggregator in it’s place.
Map the array into the Sheets “Bulk Update Rows” Rows field.
samliew – request private consultation
Join the Make Fans Discord server to chat with other makers!