Verify all users have added a row to a table within a certain time

[Thilina]

Hi, So in my application I have checklists, there are weekly checks, monthly checks and so on.
I’ve set up bots to remind users with emails every week or month to add the checklists (each checklist has it’s own table),
when a user adds a new row (for example) to the monthly checklist table, that user’s monthly checklist is considered updated.
All users add to the same monthly table, there is a [user] column that has initial value of USEREMAIL() to id the user who added a record and a [timestamp] column with NOW() as it’s initial value)

My Question:
How do I create a bot to check on the next day(for weekly checklist)/next week(for monthly checklist), which users have not added a row to that table yesterday/last week and send them another email.

Appreciate any help