I need to have a zap triggered when there is NO entry made during a given period of time (X days before today’s date). I have a Sheet that collects data entered from a Form. Users are supposed to use the form to log their mood on a daily basis. I want to get notified when they did NOT do that so that I can check in with them.
Best answer by andywingrave
Hey Peter - There are a few ways you can do this (Although I would recommend Airtable for your use case over Google Sheets) because it will allow you to achieve your desired result without any workarounds.
However, for sheets, my recommendation is that you create a VLOOKUP in a new tab where the condition is ‘User Update = “” ‘ (i.e. Blank)
From there you can trigger your zap.