Add-on script features:
Send emails when someone edits your Google sheet. 
Customize email templates and create professional email to fit your needs. 
Create custom rules that run when you select a value in your sheet. 
Send unlimited emails on edit. 
Run HTML Email Campaigns and more. 
 
Activating the add-on with license:
1) Go to    ➤ ⌘ More options   ➤ Activation options ➤ ◉ Activate
2) Enter the license key provided to you after purchase.
 
Creating email rules:
1) Open Config sheet
2) Click on the sheet icon in cell C5. This will update the sheets dropdown. 
3) In column C,  select your sheet where you would like to apply the rule.
4) In column D, enter the column name where you would like to apply the rule in the above sheet. Example: Product Status
5) In column E, enter the value that needs to be checked for. Example: Order Received
"6) In column F, enter the ""To"" email address as text or marker. For example:  
As text you can type, 
         support@gscriptgallery.com
As a marker, you can type, 
        {{Email}}
Here ""Email"" is the column name where the email address is stored. "
7) In column G and H, enter the "CC" and  "BCC" emails. You can separate multiple emails address with a comma. You can use Markers here like {{Email}} where Email is the column name where CC or BCC email is present. 
8) In column I, enter the column name which you would like to update after the condition is met and rule is executed. 
9) In column J, enter the message that you would like to see after the condition is met.
8) In column K, enter the subject of the email.
9) In column L, enter the plain text body for your outbound email. 
"10) In column M, enter the HTML text body for your outbound email. 
Note: If you enter the plain text email body, you should leave the HTML text cell blank and vice-versa."
11) In column N, enter the pop up message that you would like to see after the email is successfully sent from your sheet. You can leave this blank if you don't want to see a pop up each time.