Can I get some basic instruction on how the Google Sheets Bulk Add/Update Rows modules work? I am trying a bulk add, and I can’t get the right syntax for mapping. You can see how many ways I tried.
Welcome to the Make community!
Every result (item/record) from a search/match 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 next popular aggregator is the Text Aggregator which is very flexible and has applies to many use-cases.
There are other types of aggregator modules, click the below links to find out more:
- Array aggregator
- Text aggregator
- Numeric aggregator
- Table aggregator
- JSON aggregator
- CSV aggregator
- Archive (ZIP) aggregator
- other app-specific aggregators
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.
samliew – request private consultation
Join the Make Fans Discord server to chat with other makers!
Thanks for the swift reply, @samliew. I have used aggregators somewhat before and anticipate using them for my ultimate use case here. I was just trying to wrap my brain around how the module works and was wondering if I could input some plain text to test it out. It sounds like if I want to do that I have to toggle off “Map,” which is fine.
Also, the missing piece was the ability to map the target structure type in the aggregator to a future module. Never would’ve guessed that. Thanks for answering my question!