How to send email notification from Google Sheets?

Question

Google Sheets

Good afternoon dear experts.
There is a table in which the director coordinates this or that information (changes the value of a cell from the list - agreed / not agreed).
How to make it so that when, for example, in cell F2, a value from the list appears - "Agreed", a letter is generated to a certain mail with a notification that your application has been approved?
Thanks in advance!

Answer 1

MailApp.sendEmail

Answer 2

1) To track the fact of changing the cell, use onEdit ( event ) The event
object also contains information about the new value of the cell ( enent.value ). 2) To send an email sendEmail(recipient, subject, body)