Cannot map items from Weather app to Google Sheets

This is expected behaviour. If you want to preserve some fields in the collections, make sure you use an Array Aggregator instead.

Use the right aggregator for the job:

  • A Text Aggregator reduces everything to just a single Text variable.
  • An Array Aggregator adds each item to an Array, which can hold multiple items.

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:

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.

3 Likes