Woocommerce key value export of product attribute to google sheets

What are you trying to achieve?

Hello,

I’m really not a programmer and I’m having a bit of a hard time with Make.com, so I hope you can help me :slight_smile:

I want to import WooCommerce order data into Google Sheets. So far, this part works perfectly and runs without any issues.

However, there are 2 product attributes that I urgently need for each order, but I can only ever retrieve one of them, no matter what I try or configure.

The two attributes are:

the value of key: “abfahrtsort”

the value of key: “ticket”

Here is an example of the order data:
“lineItems”: [
{
“metaData”: [
{
“id”: 129897,
“key”: “abfahrtsort”,
“value”: “Frankfurt”,
“displayKey”: “Abfahrtsort:”,
“displayValue”: “Frankfurt”
},
{
“id”: 129898,
“key”: “ticket”,
“value”: “mit Eintrittskarte”,
“displayKey”: “Ticket”,
“displayValue”: “mit Eintrittskarte”
},