google sheets - send email notification based on time of day

Question

In google sheets, is there a way to send an email notification when a cell is not filled by a certain time of the day? Like if cell A1 isn't filled by 5pm, send an email to user to tell them to fill that cell.

Answer 1

You'll need a Time driven trigger that checks if the cell(or range) is blank and then calls a email function

Also look at this SO answer, which uses OnEdit()