How to use Bulk Add/Update Rows in Google Sheets?

[Josh_Hasak]

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.

[samliew]

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!

[Josh_Hasak]

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!