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

Beginner Questions
, ,
2

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.