I’m halfway there to getting a zap dialed in. I’m trying to send out a reminder email to a project manager until the task is complete to provide a schedule update. We use Dropbox to store an chronologically dated Excel file. It’s labeled sequentially with the date it’s made (i.e. “Daily Report MM-DD-YYYY.xlsx”). Workflow so far is:

1. At 3P daily during the week check the specified Dropbox folder for the Daily Report Excel.
2. If found, send me an email to review.
3. If not found, send an email to the project manager reminding him to do it.
   1. Check again in an hour to see if the folder is updated with the new file.
   2. If it’s updated within an hour, go back to step 2.
   3. If not  updated send another email reminding them to do it. Repeat this every hour until it’s done.

My solution so far is:

1. Schedule by Zapier Trigger everyday at 3P
2. Dropbox “Find File” action looking up the Daily Report based on the trigger date filling in the variable date.
3. PATH A: If Dropbox finds the file, send me an email telling me to review the file.
4. PATH B: If Dropbox doesn’t find the file, send project manager an email and CC me to do the work.
   1. Delay by Zapier for 1-hour.
   2. ???? then what?

Not sure if there’s a better way to capture this. I *think* if I can loop after the Delay by Zapier to search for the file again I can make it work. What do you guys think?