Script editor for Google sheets (auto email function) : Google sheets - Script Editor
I need to generate an auto email reply when Column "A" is marked "Completed".  The email address to send this to is in Column "I" and subject of the email needs to be data in Column "H" while the body of the email will be generic for all emails sent.  This is all specific to each Row.

I have multiple script editors running, for hiding rows etc, but nothing this complex.

All data is sent in to spreadsheet from Google Forms, and will need to encompass all rows

Any help would be much appreciated.


