Send email notifications to different people based on Google Form answers

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.

Try this in Lido for free ->Schedule a demo with a product specialist
Lido is trusted by sales, marketing, and operations teams at:
and 100s of other companies

Why you should use this

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.

Talk to a product specialistTry this in Lido for free ->

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….)

‍

Tutorials to help you get started

Step-by-step instructions to guide you through setting up this automation in Lido.
Instructions from the Lido blog ->
Youtube video ->
Talk to a product specialistTry this in Lido for free ->

Who should use this

Talk to a product specialistTry this in Lido for free ->

Related Use Cases

Discover more workflows you can automate with Lido.

Create Contract Agreements from Google Forms

Send email when a new row is added to Google Sheets

Send Slack messages based on dates in a Google Sheet

Send SMS from Typeform responses

Create PDFs by merging Google Sheets data into a template

Create PDFs from Google Forms responses

View all