Email sending when status change

I created an APP starting from a google sheet populated through google form. I’ve added functions for changing status and a bot that sends emails when the status changes.
My problem is that I can not make him read the recipient mail from the mail column. He always sends emails to me. At the change of status he should read the recipient email from the mail cell and send. I don’t know much about the software I just started playing it and I’m not a programmer can you give me an example of expression?

Could you mention if the app is deployed? For non deployed apps, the email goes to only the app creator.

Please check the section " Why are emails only sent to the app creator?" in the article below


Yes now Work, thanks

1 Like