Google sheets , google app script

Ends 25 Mar 2018 (in 3 months)

Currently I am using google sheets to track data. I need you to create a function in script editor with a trigger that will send a email when a specific cell is edited(numerically).
Ideally we will use onedit to state that if cell in specific column is equal to 5, then email address in specific row of cell that has been changed is sent an email. I would also like a cell to the right of the cell that is being edited to reflect when email is sent and not allow for a duplicate.
I would like the email body to be standard for every email address, but I would like the option to personalize with a name, link, or form.

Sign up to apply →

Posted on

Know a freelancer that can do this job?

Earn lifetime commission for every freelancer you refer, by becoming an affiliate. Find out more

Share this job: