Need help with Make automation: sending tracking URL from Spreadsheet to Shopify

Hi everyone,

I’m working on an automation in Make that sends tracking URLs from a spreadsheet to Shopify, but I’m facing an issue and could use some help.

Here’s a brief overview of the automation:
1. It starts with the Watch Orders module (from Shopify), triggering every weekday evening when an order’s Fulfillment Status is set to ‘Shipped’.
2. A filter ensures that the Fulfillment Service matches a specific provider and that the tracking URL is still empty.
3. The automation then searches the spreadsheet for the order number from Shopify.
4. Once found, it retrieves the tracking code and URL from the sheet and updates the order in Shopify.

The problem:

Sometimes, the fulfillment request has been made, but the tracking details have not yet been added to the spreadsheet. As a result, the automation cannot find any tracking information, and the process fails.

What I need help with:

I want to set up a system where, if the tracking details are missing, the order is automatically rechecked the next day. Does anyone know how to implement this in Make?

Thanks in advance!