Automate emails with Google Sheets when status changes
How to send an automated email when a cell changes in a Google Sheet.
This video will teach you how to write a Google Apps Script application that will send an automated email with the data entered into the row of the sheet.
The structure of the video is as follows:
1:12 demo
4:27 code review
10:00 tutorial begins with statusEval function
17:58 conditional logic for statusEval function
20:20 create onEdit trigger
39:45 conditional logic for status completed
48:35 build sendEmail function
58:45 build html template