# Woocommerce order product list to google sheets problem

**URL:** <https://community.make.com/t/woocommerce-order-product-list-to-google-sheets-problem/78819>\
**Category:** Questions\
**Tags:** collections, arrays\
**Created:** [April 15, 2025, 10:24am UTC](https://community.make.com/t/woocommerce-order-product-list-to-google-sheets-problem/78819 "2025-04-15T10:24:34Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Daveeee](https://avatars.discourse-cdn.com/v4/letter/d/9de053/32.png) [@Daveeee](https://community.make.com/u/Daveeee)\
**Post date:** [April 15, 2025, 10:24am UTC](https://community.make.com/t/woocommerce-order-product-list-to-google-sheets-problem/78819/1 "2025-04-15T10:24:34Z")

</div>

**I’m trying to export a list of products and their prices from WooCommerce to a field in Google Sheets.**  
When I add just `array()`, the field in Google Sheets only shows this result: `[collection]`.

When I use the following formula:  
`{{join(map(29.array; "name"; "total"); ", ")}}`  
It only exports the list of product names, without the prices from the “total” field.

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

---

<div class="post-metadata">

**Author:** ![ponvaskon](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/ponvaskon/32/67139_2.png) [@ponvaskon](https://community.make.com/u/ponvaskon)\
**Post date:** [April 15, 2025, 11:50am UTC](https://community.make.com/t/woocommerce-order-product-list-to-google-sheets-problem/78819/2 "2025-04-15T11:50:03Z")

</div>

Hi @Daveeee  
You can replace the array aggregator module with the text aggregator and add text the result text to a Google Sheet field.

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

---

<div class="post-metadata">

**Author:** ![Daveeee](https://avatars.discourse-cdn.com/v4/letter/d/9de053/32.png) [@Daveeee](https://community.make.com/u/Daveeee)\
**Post date:** [April 15, 2025, 3:22pm UTC](https://community.make.com/t/woocommerce-order-product-list-to-google-sheets-problem/78819/3 "2025-04-15T15:22:21Z")

</div>

Thank you. It worked well.

---

<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:** [April 29, 2025, 3:31pm UTC](https://community.make.com/t/woocommerce-order-product-list-to-google-sheets-problem/78819/4 "2025-04-29T15:31:45Z")

</div>

This topic was automatically closed because it's resolved or inactive. Please, start a new topic.