Dear sir,
Thank you for posting your project here.
I am expert in GAS and had finished many GAS project before. Please have a look on my profile.
With your project, we will use a sheet trigger to process when cell change and send mail.
Waiting for discuss more about project,
thanhhungqb