Google sheets , google app script
- or -
Post a project like this2236
$$
- Posted:
- Proposals: 2
- Remote
- #1912952
- Awarded
Description
Experience Level: Intermediate
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.
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.
Holland B.
20% (1)Projects Completed
-
Freelancers worked with
-
Projects awarded
100%
Last project
10 May 2024
United States
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies