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

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.

Screenshot 2024-07-11 at 10.18.10 AM

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:

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.

samliewrequest private consultation

Join the Make Fans Discord server to chat with other makers!

2 Likes

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!

3 Likes