Automatic Email Based on Column Trigger

[Liz S.]

Hi Henrique!

This script is super easy to use, and I know very little about Google scripts so thank you!  I have a question about setting a different kind of trigger to run the emailer automatically:

Is there a way to set up a trigger that will only send an email when a certain column in the spreadsheet is filled in?  The form is filled out by customers and populated on the spreadsheet.  Then I have my customer service reps fill in answers to customer questions on a sheet that I then want to email back to the customer.  I have everything set up properly and the Emailer script runs just fine if I do it manually, but I need it to run automatically or tie the manual option to a "button" in the row so that the email only goes out once the customer service rep answers all the customer's questions.

Is this possible?  Is there a somewhat easy way to do this by going into the script editor?

Any help will be greatly appreciated....  Thank you!

- Liz

[Jodi Lew]

I'm looking for this too.  Also would like to have the timestamp for the FormEmailer Status column.