automatic send email from gsheets

[mohitbd]

I want to automatically send emails to the customer from google sheets when the condition is met. I want to when I Add or Edit any or specific data then send to email. Check my attached image in column N when I write Yes then send to email , when I write NO then don't send to email. How to do it?

Thanks

 

[Pabblymember11]

Hey @mohitbd

You need to select the data label which contains "Yes" or "No" instead of selecting the triggering column.

 

[mohitbd]

Its works, Thanks