Notify your internal team of new leads or signups in a Google Sheet. Send notifications to different team members based on the value of a cell.
This automation will turn the details from each Typeform submission into a custom email. The email recipient will be dynamically calculated based on the answers to different form questions.
New Typeform responses are automatically added to Lido's spreadsheet.
Use spreadsheet formulas to calculate the correct recipient based on values (e.g. Typeform responses) in any column.
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….)