Separating the values of the iterator or variables into different cells in Google Sheets

What are you trying to achieve?

I have these variables and values ​​from files in Google Drive. And I need to separate each variable (File ID) into a specific cell in Google Sheets.

However, when I update it, one value overlaps the other in the same cell.

Steps taken so far

I’ve tried everything, I can get the values, but I can’t map them to their specific cellUploading: Captura de tela 08.03.2025 às 19.47.32 PM.png…
Uploading: Captura de tela 08.03.2025 às 19.47.47 PM.png…

Screenshots: scenario setup, module configuration, errors






blueprint.json (52.8 KB)

Welcome to the Make community!

Delete the Iterator module. What you need is an Aggregator, as the first module returns multiple bundles.

Combining Bundles Using Aggregators

Every result (item/record) from trigger/iterator/list/search/match modules will output a bundle. This can result in multiple bundles, which then trigger multiple operations in future modules (one operation per bundle). To “combine” multiple bundles into a single variable, 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 can apply to many use-cases like building of JSON, CSV, HTML.

You can find out more about the other types of aggregator modules here:

Then, you can use the built-in functions map and get to access variables within an array.

e.g.:

{{ get(map(2.array; fileId); 1) }}
{{ get(map(2.array; fileId); 2) }}
{{ get(map(2.array; fileId); 3) }}
{{ get(map(2.array; fileId); 4) }}
etc.

For more information, see the Mapping arrays page in the Make Help Centre, which covers the following:

  • Mapping an array’s first element
  • Mapping an array’s nth element
  • Mapping an array’s element with a given key
  • Converting elements to a series of bundles

You should also take note of the following important details:

  • All parameters are case sensitive. Even though in this particular example the item’s label differs from its raw name only in capitalization, it is necessary to use the raw name, which is all lowercase value in contrast to the label Value

  • The outputs from modules wrapped between an Iterator and Aggregator are not accessible beyond the Aggregator module.

For more information, see “Mapping with Arrays” below:

Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —

Getting Started

Help Centre Basics

Articles & Videos

Hope this helps! Let me know if there are any further questions or issues.

@samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.

Hey there,

from your screenshots it looks like you are updating the same row. So yeah, they will override each other. Do you need the values in new rows in the same columns? Or is it in different columns on the same row?

Hello,

Yes, they are overlapping. I need them on different lines.

I tried to apply the above step-by-step using an array aggregator, and also a json text aggregator. What I managed to do was to separate the text by line and try to separate it using formulas in sheets, but I was unsuccessful. So I’m still stuck in the same situation.

Even with the aggregator modules, I still can’t map the IDs separately.

Here are some screenshots

blueprint (1).json (17.4 KB)