# I can map my 2 output collections from Json parser in my Google sheet **URL:** \ **Category:** Questions\ **Tags:** google-sheets\ **Created:** [October 29, 2024, 8:05pm UTC](https://community.make.com/t/i-can-map-my-2-output-collections-from-json-parser-in-my-google-sheet/59156 "2024-10-29T20:05:16Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![Simon5](https://avatars.discourse-cdn.com/v4/letter/s/6de8d8/32.png) [@Simon5](https://community.make.com/u/Simon5)\ **Post date:** [October 29, 2024, 8:05pm UTC](https://community.make.com/t/i-can-map-my-2-output-collections-from-json-parser-in-my-google-sheet/59156/1 "2024-10-29T20:05:16Z")
i have a simple automation that queries the facebook graph api over 2 campaigns i get an array with 2 collections each having the information of the respective campaign after i have used the parse json module, but as soon as i want to map the vales in my google sheet it shows me the data of only one campaign. i have already used an iterrator, aggregator etc nothing has worked. thanks for your help and time ![CleanShot 2024-10-29 at 20.57.24](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/f/3/f326840f2d057569c35ccfc89ebed72382234c41.png) ![CleanShot 2024-10-29 at 20.57.56](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/9/7/9707e38c85da71930682023056a5aa128b5767d9.png) ![CleanShot 2024-10-29 at 20.58.50](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/8/e/8e13c8aef7d3f1a26ca60baedded24d4a95901da.png) ---
**Author:** ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)\ **Post date:** [October 30, 2024, 7:25am UTC](https://community.make.com/t/i-can-map-my-2-output-collections-from-json-parser-in-my-google-sheet/59156/2 "2024-10-30T07:25:47Z")
Welcome to the Make community! When you see ARRAY, think ITERATOR. ![f6bfdc6c487724e92fe7cb6537b52f6d3c999487](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/2/3/23a694ffc3939712667b383fd1b497de5d8afecb.png) ![Screenshot_2024-07-15_210752](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/b/b/bb0162b13bbd34dbfbb41c5c399be413a9b592ec.png) Then, ### Aggregators Every result (item/record) from 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](https://www.make.com/en/help/modules/aggregator.html) are modules that accumulate multiple bundles into one single bundle. An example of a commonly-used aggregator module is the [Array aggregator](https://www.make.com/en/help/tools/flow-control.html#array-aggregator) module. The next popular aggregator is the [Text Aggregator](https://www.make.com/en/help/tools/tools.html#text-aggregator) which is very flexible and can apply to many use-cases like building of JSON, CSV, HTML. There are other types of aggregator modules, click the below links to find out more: - [Array aggregator](https://www.make.com/en/help/tools/flow-control.html#array-aggregator) - [Text aggregator](https://www.make.com/en/help/tools/tools.html#text-aggregator) - [Numeric aggregator](https://www.make.com/en/help/tools/tools.html#numeric-aggregator) - [Table aggregator](https://www.make.com/en/help/tools/tools.html#table-aggregator) - [JSON aggregator](https://www.make.com/en/help/tools/json.html#aggregate-to-json) - [CSV aggregator](https://www.make.com/en/help/apps/file-and-document-management/csv.html#create-csv) - [Archive (ZIP) aggregator](https://www.make.com/en/help/apps/built-in-apps/archive.html#create-an-archive-973677) - _other app-specific aggregators_ ### Array Aggregator – mapping multiple bundles into a complex field The Array Aggregator module is very powerful because it allows you to build a complex array of collections for a later module’s field to map multiple items (collections) to it. This is done using the “Target structure type” of an Array Aggregator module. Here is an example: ![](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/b/e/bea4ecffec9daf39ca9cba77c0b2a40d160e7292.png) As you can see, the “Map” toggle on complex fields are used when you have an array. You can easily build an array variable to map to a future module’s field, by using an Array Aggregator module and select the “Target Structure Type” as the future module’s field you have mapped the array into. Hope this helps! Let me know if there are any further questions or issues. — @samliew P.S.: Investing some effort into the [Make Academy](https://academy.make.com) will save you lots of time and frustration using Make. ---
**Author:** ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot)\ **Post date:** [January 28, 2025, 7:30am UTC](https://community.make.com/t/i-can-map-my-2-output-collections-from-json-parser-in-my-google-sheet/59156/3 "2025-01-28T07:30:39Z")