Check the date from yesterday in Google sheet file

[Steven0age]

I have established the questionnaire for my employees, which is filled out daily. The results are entered into an Google sheet file.

I would like to create a Make automation now. This should check every morning at 5 o’clock whether the questionnaire was filled out the previous day. If not, a reminder message should be sent to the employee via WhatsApp.

My problem is: I don’t know how to set up the google sheet Module properly. I manage to find in Filter it shout check “filed” “timestamp” should contain the date from yesterday. If NOT send a message through WhatsApp.

this is what I have tried so far. but honestly I have no idea to tell him "look into the sheet if there is a date from yesterday in the timestamp.

That is the set up I have tried so far:

I would be awesome if someone could help and explain me how to do this.
thanks for you help in advance.

[samliew]

Welcome to the Make community!

You want to use the addDays built-in function.

{{addDays(now; -1)}}

[Steven0age]

Hello samliew. Thanks for the warm welcoming…

I’ve tried your advise. But it seems it’s now working.
Output has no bundles. Any suggestions why this could happen?

There is definitely an entry from yesterday.
Maybe it doesn’t work because the format of the timestamp “dd.mm.yyy hh:mm:ss”?