Send email notifications to different people based on specific form answers when a Google Form is submitted

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.

How it works

This automation will turn the details from each Google Form submission into a custom email. The email recipient will be dynamically calculated based on the answers to different form questions.

Get New Submissions from Google Forms

Triggered when a new row is added to the bottom of a spreadsheet

Choose which person to email based on the value in a column

IF(B2 = “Yoga 1”,”tom@gmail.com”,IF(B2 = ”Yoga 2”,”celine@gmail.com”,”team@gmail.com”))

Send an email

Send a personalized email from a Gmail or Outlook account

SENDGMAIL(”admin@yoga.com”,D2,”Thanks for signing up!”,”Tom, thanks for signing….)

Similar Apps

Use Lido to make your forms, spreadsheets, and communication apps all talk to each other.

Google Forms
Slack
WhatsApp
Google Drive
Google Calendar
Typeform