Only Add New Shopify Orders to a Google Sheet

How To
,
1

I have a scenario set-up to pull Abandoned Checkouts into a Google Sheet. The scenario works but each time it runs it pulls in older orders that are already on the sheet. I’d like it to only add new abandoned checkouts that are not already in the sheet.

Using the high-level explanation [in this post](Only add NEW Shopify Orders to Google Sheets), I updated the scenario as follows:

  1. Search Abandoned Checkouts in Shopify (this process works correctly)

  2. Filter orders where the Abandoned Checkout URL does not already exist in the google sheet. (this is where things breakdown, no results are returned after this filter, even though there are unique URLs from the Search function that are not in the sheet)

Any help is appreciated!
Chip