Easy Dropdown Selection Email Notifications in Google Sheets
Вставка
- Опубліковано 5 вер 2024
- 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
This video just saved me alot of stress.. Thank you.. I have liked and subscribed😊
Awesome! Thank you!
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.
Yes, you would need to count the hidden columns as well.
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?
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: ${}