Easy Dropdown Selection Email Notifications in Google Sheets

Подписаться 2,7 тыс.

50% 1

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/3XCdKVW

Опубликовано:

15 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 8

@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: ${}

@stephenphillips7445 7 дней назад

Now that Google Business has conditional notifications, can this be implemented easier without the script, but still using specifics from the dropdown menus?

@SheetsNinja 6 дней назад

So the conditional notifications that Google implemented for the business accounts can make simple notifications easier, but it doesn't give you any customization on what gets included in the notification or how it's formatted. You can see a quick walkthrough of how to set up Google's notifications here: support.google.com/docs/thread/278360807/google-sheets-new-feature-conditional-notifications?hl=en