Sending a notification / email in case of a missed entry

Dear members ,

I tried searching for this problem on the blog but couldn't get a similar query. 

Basically, I want to have multiple checklists to be filled at fixed time intervals by our team members. Say at 9am, 12pm, 3pm, 6pm and 9pm. 

Each checklist will have a seperate Google sheet so 5 Google sheets, with each row for every new checklist entry.

I want to trigger an email or a notification in case the new checklist entry is not added by the respective team member after maybe an hour of it becoming overdue. 

 

0 3 109
3 REPLIES 3
Top Labels in this Space