Woocommerce order product list to google sheets problem

[Daveeee]

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.

[ponvaskon]

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

[Daveeee]

Thank you. It worked well.