Only add NEW Shopify Orders to Google Sheets

How To
,
1

Hi there,

I’m adding new rows to a google sheet for each Shopify order. This is an “on-demand” scenario that I’ll run at the end of the month.

Each order is a new row in my google sheet. The row includes various order details

I’m pulling order_name from the shopify data and includding it in my pulled data. This identifies each order in my sheet.

How can I set up my scenario such that it only adds new orders to my google sheets? Is there a way to search the sheet and only add new rows if order_name isn’t found? Or can I only pull orders since the last execution?

Thanks for the help!

2

Welcome to the Make community!

To find out whether the order has been added to your sheet before, you’ll need to use a search module first.

Then add a filter after the search module to check if the order does not exist, to continue to the next module where you add a new row to your sheet.

2 Likes