Conditional Google Spreadsheet App Script that automatically sends email based on the value of a cell
I'm just putting up here how I made a project which requires to make a Google App Script on a Google Spreadsheet to send email if a particular cell contains Yes or No or something like OK as a value of a cell or your column indicator for something. It's like this, supposed you have a Google Form which has name , email , address , and other important details on it, and you also have there an input which asks the users who fill up the form if they want to receive an email or not? or something complex and customized that requires you to build a custom script on it and you can't find any add-ons available. On the project I made, it required me to send an email if the value of a particular cell which is a computed value of some cells from another sheet is " Y " and also if " N ", but the two has a different email body customized for the users based on their answer in the form. I broke the work down to pieces to learn about the scripting, first I s...