Help me bulk add array + nested collection into a google sheet?

Hello :wave:

As shown in the screenshot, I have an array with a list of people, and each person has an “organization” collection within that contains the detail of their company.

What I’m trying to do is bulk add the array (instead of adding rows individually, since that would take me thousands of ops per run) into a google sheet.

The problem is when I include the organization collection in the aggregator module that then is used for the bulk add, it doesn’t work.
Instead it functions correctly if “organization” is omitted.
I’ve been trying for hours, can’t yet figure out how to do so.

Here’s the screenshots :


The error when I try to bulk add with “organization” selected :

TIA :pray:

You need to select the “Target Structure Type” field of the aggregator.

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!

3 Likes

@samliew
That worked. You’ve blessed me twice today :pray:
I’ll be sending you a small gift in the messages, as a token of my appreciation.

Hi @Kailtis,

No problem, glad I could help, and I don’t expect any gift from you since being able to solve your problem is already a reward in itself!

Anyway, my private messages are off on this forum as I find it easier to consolidate private conversations via email instead.

You could join the Make community Discord server if you’d like to hang out and chat – we won’t be complete without you!

See you around :slight_smile:

samliewrequest private consultation

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

1 Like

Alright! @samliew
I’ll be sending it via email then :grin:
I’ve already joined the discord, but that account has a different name, I’ll make sure to change it.
Cheers!