How can I make both Variation1 and Variation2 map into the same row in Google Sheets instead of Make creating separate rows for each variation?

[TM]

What is your goal?

Hey everyone,

I’m trying to automate my WooCommerce orders into Google Sheets using Make, and I’m stuck on handling product variations.

What is the problem?

What I want:

• Variation1 and Variation2 should go into separate columns in the same row for each product

What’s happening instead:

• It duplicates Variation1 in both fields on the same row
• Then creates a second row where it duplicates Variation2 in both fields
• So instead of one row with both variations, I end up with two rows — each repeating a single variation

How do I make both variations land in the same row instead of getting split like this?

What have you tried so far?

Here’s what I’ve set up:

• WooCommerce → Watch Orders
• Iterator → Line Items (to get each product as a separate row)
• Second Iterator → Meta Data (to extract variations)
• Google Sheets → Add a Row

Screenshots: scenario setup, module configuration, errors