# Google sheets - How to add two rows for two different items on the same order?

**URL:** <https://community.make.com/t/google-sheets-how-to-add-two-rows-for-two-different-items-on-the-same-order/107148>\
**Category:** Questions\
**Tags:** google-sheets\
**Created:** [April 8, 2026, 11:55am UTC](https://community.make.com/t/google-sheets-how-to-add-two-rows-for-two-different-items-on-the-same-order/107148 "2026-04-08T11:55:11Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![TM](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/tm/32/90373_2.png) [@TM](https://community.make.com/u/TM)\
**Post date:** [April 8, 2026, 11:55am UTC](https://community.make.com/t/google-sheets-how-to-add-two-rows-for-two-different-items-on-the-same-order/107148/1 "2026-04-08T11:55:11Z")

</div>

### 🎯 What is your goal?

To have a seperate row for each item on a single order.

### 🤔 What is the problem & what have you tried?

I integrated WooCommerce with Google Sheets to automatically log my orders instead of entering them manually.

It works fine for single-product orders. But when a customer buys multiple products in one order, only the first product shows up in the sheet.

In the screenshot, row 138 shows only one item under “Item description,” even though two products were purchased.

In row 139, I tried adding multiple “Line items” fields to capture additional products, but it just keeps repeating the first product (“Daphnie Belle Dress”) instead of pulling the others.

Ideally, each product in an order would be added as a separate row. If that’s not possible, I at least want all products from the order to appear within a single cell.

How can I fix this?

### 📸 Screenshots (scenario flow, module settings, errors)

 ![Screenshot 2026-04-08 at 5.15.38 PM.png](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/9/4/945bfb1995328326cf082123a42beee39091f2b7.png)

---

<div class="post-metadata">

**Author:** ![Stoyan\_Vatov](https://avatars.discourse-cdn.com/v4/letter/s/5daacb/32.png) [@Stoyan\_Vatov](https://community.make.com/u/Stoyan_Vatov)\
**Post date:** [April 11, 2026, 1:12pm UTC](https://community.make.com/t/google-sheets-how-to-add-two-rows-for-two-different-items-on-the-same-order/107148/2 "2026-04-11T13:12:28Z")

</div>

6 posts were merged into an existing topic: [Google sheets/woocommerce: How do I correctly map Variation1 and Variation2 from line item meta?](https://community.make.com/t/google-sheets-woocommerce-how-do-i-correctly-map-variation1-and-variation2-from-line-item-meta/107193)

---

<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:** [July 10, 2026, 1:18pm UTC](https://community.make.com/t/google-sheets-how-to-add-two-rows-for-two-different-items-on-the-same-order/107148/3 "2026-07-10T13:18:10Z")

</div>