Send emails to different people based on a Google Sheets column

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.

How it Works

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.

When a new row is added to Google Sheets

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