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
Trigger When Entry to Sheets Not Made during TIme Period
- Beginner
- 2 replies
Best answer by andywingraveBest 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.
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+9- Zapier Expert
- 854 replies
- Answer
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.
- Beginner
- 2 replies
Thank you very much for your response! I was able to create a VLOOKUP and managed to set it up so that there was a cell which was either 0 or 1 depending on whether there was a recent entry. However I could not figure out how to make that condition trigger a Zap. I set up the Zap to check that value once a day but it doesn’t seem to work.
+12- Zapier Staff
- 3731 replies
Hi Peter, when you say that the Zap wasn’t working, could I ask what the trouble was? Was the Zap not triggering?
One trouble with using Google Sheets is that when you use the New or Updated Spreadsheet Row trigger, if the value in a cell changes to something that the Zap has already seen, the Zap wont trigger. For example, let’s say row 8 had a 1 in it, and then changed to a 0, that would trigger the Zap. If the Row was changed again to have a 1 again, the Zap wouldn’t trigger.
How about this - in the lookup in the sheet you say that if there was a recent entry, the value in the cell is ‘0’. If there hasn’t been an update in the last two days, the value in the cell is changed to today’s date. You would then use the New or Updated Spreadsheet Row trigger, using that column as the trigger. Does that sound like it would help?
- Beginner
- 2 replies
I am going to try doing this with a javascript add-on to Sheets. I appreciate everyone’s thoughtful answers. This is a wonderful community!
1 person likes this
+12- Zapier Staff
- 3731 replies
Thanks for letting us know
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.