Send an email to a specific person or persons with the information in a Google Form response in the body of the email when a new Google Form response is submitted.
This automation will automatically send an email notification whenever a new Google Form response is submitted, including the details of the response in the email.
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”,”Dear [@Name], thanks …”)