# Adding Shopify orders to Google Sheet data source

**URL:** <https://community.glideapps.com/t/adding-shopify-orders-to-google-sheet-data-source/42141>\
**Category:** Ask for Help\
**Created:** [May 19, 2022, 6:02am UTC](https://community.glideapps.com/t/adding-shopify-orders-to-google-sheet-data-source/42141 "2022-05-19T06:02:22Z")\
**Posts on this page:** 1\
**Showing post:** 9

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [May 21, 2022, 4:33am UTC](https://community.glideapps.com/t/adding-shopify-orders-to-google-sheet-data-source/42141/9 "2022-05-21T04:33:50Z")

</div>

Well theoretically you can expand your structure with more columns (let’s say purchase 1 name, purchase 1 timestamp, purchase 2 name, etc. all the way to purchase 5). Not the cleanest structure in my opinion, but if row count is a problem for you then ok.

Then in Integromat/Make, do a search row step and then a router.

If purchase 1 name is empty then add an update row step to write to purchase 1 name and purchase 1 timestamp.

If purchase 1 name is not empty and purchase 2 name is empty then write to purchase 2 name and purchase 2 timestamp.

If purchase 2 name is not empty and purchase 3 name is empty then write to purchase 3 name and purchase 3 timestamp.

All the way to purchase 5.

For displaying it in an inline list, please adapt this method.

> [@fishbaguette\_breadbasket Transpose Columns to an Inline List: The Miracle Method](https://community.glideapps.com/t/transpose-columns-to-an-inline-list-the-miracle-method/32766):
>
> I’m often asked how to take columns of data (say form responses) and display them in an inline list. Here’s one way to do it—the MIRACLE METHOD. [[Glide: Transpose Data Columns into an Inline List with the MIRACLE METHOD] ](https://www.youtube.com/watch?v=t-sh_Q3WbQc)

---

_[View the full topic](https://community.glideapps.com/t/adding-shopify-orders-to-google-sheet-data-source/42141)._
