Notify your internal team of new leads or signups in a Google Sheet and automatically route information to the best person. Send notifications to different team members based on the value of a cell.
This automation will automatically send emails to different people based on the values in a Google Sheets column whenever a new row is added to the Google Sheet.
Triggered when a new row is added to the bottom of a spreadsheet
IF(B2 = “Yoga 1”,”tom@gmail.com”,IF(B2 = ”Yoga 2”,”celine@gmail.com”,”team@gmail.com”))
Send a personalized email from a Gmail or Outlook account
SENDGMAIL(”admin@yoga.com”,D2,”Thanks for signing up!”,”Tom, thanks for signing….)