# Shopify order update in google sheets once an order comes in

**URL:** <https://community.parabola.io/t/shopify-order-update-in-google-sheets-once-an-order-comes-in/1518>\
**Category:** Ask a question\
**Created:** [January 29, 2021, 10:16pm UTC](https://community.parabola.io/t/shopify-order-update-in-google-sheets-once-an-order-comes-in/1518 "2021-01-29T22:16:13Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ionut\_Andrei](https://avatars.discourse-cdn.com/v4/letter/i/9f8e36/32.png) [@Ionut\_Andrei](https://community.parabola.io/u/Ionut_Andrei)\
**Post date:** [January 29, 2021, 10:16pm UTC](https://community.parabola.io/t/shopify-order-update-in-google-sheets-once-an-order-comes-in/1518/1 "2021-01-29T22:16:13Z")

</div>

Hi there, I tried creating a flow where Shopify would report in Google Sheets every 10 minutes the orders I received (product type, quantity, etc).

Basically I am looking for a way to have an automated sheet where whenever an order comes in, it will be updated in a new row.

The issue that I am facing is that after every run, the flow will not continue from the last order that came in, but it will include all the other orders from the selected period as well…!

[Parabola Test|690x287](https://community.parabola.io/uploads/short-url/8rqR9PzH0IJBLrpxit635OakvEk.png)

Pic indication: You can see on column A that the old order numbers are being imported after every run.

Is there any way this could be fixed?  
Thank you in advance for your time and consideration!

---

<div class="post-metadata">

**Author:** ![sachi](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/sachi/32/10_2.png) [@sachi](https://community.parabola.io/u/sachi)\
**Post date:** [January 29, 2021, 11:20pm UTC](https://community.parabola.io/t/shopify-order-update-in-google-sheets-once-an-order-comes-in/1518/2 "2021-01-29T23:20:43Z")

</div>

Hi @Ionut_Andrei - Thanks for your question! It sounds like you need to make some updates to your flow to account for the orders that already exist in your Google Sheet. Here’s roughly what your flow should look like:

 ![Screen Shot 2021-01-29 at 3.17.51 PM](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/2X/8/8b21302a385bbfc6f3bf71b9cb18d70e9bf17977.jpeg)

1. Add a `Pull from Google Sheets` and import the same Google Sheets step that you’re exporting to. This way, every time the flow runs on a 10 minute schedule, Parabola can know what orders already exist in the Google Sheet
2. Connect the Shopify step and then the Google Sheets step to the `Find overlap` step. Here’s how it’s configured:  
 ![Screen Shot 2021-01-29 at 3.19.34 PM](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/2X/3/324c8b714e1afabf329864cfb09a3410137da703.png)
3. With these updates, your `Send to Google Sheet` step should only **append** the new rows that are not already reflected on your Google Sheet.

Hope that helps! Let me know how it goes.