Easy Dropdown Selection Email Notifications in Google Sheets

Are you ready to automate email alerts or notifications in Google Sheets? In this tutorial, I walk you through setting up an email alert that will get sent when you select certain values in a dropdown.
Check out the related video on how to do the same thing but using a checkbox instead: • ✅ Effortless Email Not...
You can download a copy of the final template here: bit.ly/3xgUMcP

[@SolomonTetteh-ot7ww]

This video just saved me alot of stress.. Thank you.. I have liked and subscribed😊

[@SheetsNinja]

Awesome! Thank you!

[@stanjontra9405]

On my sheet, we have hidden columns. Would you count the hidden columns in the array?
Very cool video, this is exactly what we were looking for.

[@SheetsNinja]

Yes, you would need to count the hidden columns as well.

[@Carlie-d2w]

This is great! What do I need to remove if I don't want any data from the columns pulling into the email, just the notification email sent?

[@SheetsNinja]

You can just type what you want in the htmlBody part of the sendEmail section, and don't need to include any of the template literals: ${}