MailApp.sendEmail(recipient, subject, body) sends a plain email from the account that runs the script. Build the body from the sheet, so the message says what the data says today: filter the rows that matter, turn each into a line, and join("\n") them.
Read the recipient from a cell, such as a Settings tab, rather than typing it into the code; the team can then change it without editing the script. Before sending, check that there is something to say. A scheduled script that emails an empty list every morning teaches people to ignore it.
A time-driven trigger runs a function on a schedule:
ScriptApp.newTrigger("sendOverdue") followed by .timeBased(), .everyDays(1), .atHour(7) and .create()
Run the setup function once. atHour(7) asks for the hour starting at 7; Google picks the minute. Sending email needs your permission and has a daily quota, which is why simple triggers can't send it. In this practice copy, email is recorded in the execution log instead of being sent, and the checker runs your timer once.
Filter, format one line per row, and send only when there is something to report.