# Transfer an Array to one single Google Sheet cell

**URL:** <https://community.make.com/t/transfer-an-array-to-one-single-google-sheet-cell/37038>\
**Category:** Questions\
**Tags:** arrays, google-sheets, functions\
**Created:** [May 11, 2024, 10:53pm UTC](https://community.make.com/t/transfer-an-array-to-one-single-google-sheet-cell/37038 "2024-05-11T22:53:32Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![workine.ag](https://avatars.discourse-cdn.com/v4/letter/w/47e85d/32.png) [@workine.ag](https://community.make.com/u/workine.ag)\
**Post date:** [May 11, 2024, 10:53pm UTC](https://community.make.com/t/transfer-an-array-to-one-single-google-sheet-cell/37038/1 "2024-05-11T22:53:32Z")

</div>

Hi!

I need to bring values of multiple collections of an array into one single cell in Google Sheets. How can I do this?

This is the input:

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/f/f/ff9c49c1f062a9acb0d4075e510b101a9cc0e816.png)

The field “Tags”, which is an Array, has one collection for each tag I need to extract. The tags are on the field “label”.

I tried several ways but none seems to work. Some of which are below:

I tried using the function “Join” to concatenate all the values, but no success.

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/f/e/fef7d436c0f21a1e2228f0632189e922b6570be3.png)  
 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/9/5/95aaa054640d8a1826ec7bcb9cf333a686c13fd5.jpeg)

I tried to select the deeper field, but still no success.

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/6/6/66b78057ca816aeb46a72f73f7382f596d6dcf2e.png)  
 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/d/1/d18e6cfbacbc2a63839627e7f30ac62ad84ef6bd.jpeg)

If I map only the field, with no function, it does bring the value I need, but only the first value, and I need all of them.

Was I able to explain myself?

Can somebody help me fix this?

Thanks!

---

<div class="post-metadata">

**Author:** ![Msquare\_Automation](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/msquare_automation/32/6634_2.png) [@Msquare\_Automation](https://community.make.com/u/Msquare_Automation)\
**Post date:** [June 27, 2024, 2:11am UTC](https://community.make.com/t/transfer-an-array-to-one-single-google-sheet-cell/37038/2 "2024-06-27T02:11:55Z")

</div>

Hi @workine.ag

This post can be a game changer while mapping values from Array in Make.

> [@Extract an Item from Array | Get and Map Function | Make Beginners Guide](https://community.make.com/t/extract-an-item-from-array-get-and-map-function-make-beginners-guide/2134/4):
>
> WOW this is so helpful!!! Thank you so much!! I have been trying to learn Iterators and Arrays and got close, but wasn’t using the map function, I was using the iterator to extract values from arrays and then using Set Variables. Going to try it this way. Thanks again, looking forward to more!

Regards,  
**Msquare Automation - Gold Partner of Make**

> [Free Consultation](https://calendly.com/msquarepro/meeting) | [Live Implementation](https://calendly.com/msquarepro/msquareautomation-live)

> Visit us [here](https://www.msquare.pro/) | [Youtube Channel](https://www.youtube.com/channel/UCqidlIIwbejxZmRUWBICcjQ)

---

<div class="post-metadata">

**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:** [September 25, 2024, 2:21am UTC](https://community.make.com/t/transfer-an-array-to-one-single-google-sheet-cell/37038/3 "2024-09-25T02:21:22Z")

</div>