Mapping iterated bundles in Google Sheets module

Hey there,

I’ve been trying now for 8 hours and I can’t figure it out.

I’m trying to achieve the following:

When a change in Google Sheets happens, I let it go into the iterator (router is needed for later). Inside the iterator, I have the fields mapped:

Then it goes 4 times into Claude to do my translations.

The output are 4 operations:

To get those for operations into one array, I used the text array module with a custom separator:

Then I though, to have the variables available for mapping in my last step “Add a row to Google sheets”, I need to do an iteration again, so I can access the fields one by one for mapping. The output from the iterator looks as following:

Unfortunately, in the last step, I’m only able to chose “Value” but not a specific one:

I’ve also tried with the array aggregator instead of the aggregator but the output is the same.

What am I doing wrong?

Thank you so much for your help in advance - really getting nuts here!

Best regards
David

Issue is the way you setup your scenario your outputting multiple bundles. This is why you cannot map different values into the different fields. The value comes out for each bundle, in your case for each section of the text.

I suggest you rework yor text aggreagtor. Instead format it into a JSON with each of the fields and values. From there use the parse json module to transform it from text to JSON. Then you should be able to map each value into the google sheet without that 2nd iterator.