Conditional Email Notifications with Google Forms - Route Responses to Different Email Addresses
How to setup conditional email notifications in Google Forms. This powerful feature allows you to route form responses to different email addresses based on form answers or choices made by respondents.
The Google Forms Email Notifications add-on lets you send Google Form responses in an email message as soon as a respondent submits the form. The email template can be customized to include the form answers or the form edit link.
You can also set up conditional email notifications for Google Forms where the form responses are sent to different email addresses based on the form answers filled-in by the respondent.
In the above example, we have a Google Form that asks the respondent to select the sessions they are interested in attending for an AI workshop. It is a mulitple choice checkbox question as the respondent can select one or more sessions. The form responses are then sent to different email addresses based on the sessions selected by the respondent.
The first rule says that if the respondent has selected either “Generative AI” or “Prompt Engineering” for the Sessions question, the email should be sent to
firstname.lastname@example.org. We thus choose “Any of” as the condition and add the two session options in the condition separated by a comma.
Similarly, if the respondent has selected “The future of AI” as the session, the email should be sent to
kiran@example. For all other sessions, the email should be sent to
email@example.com so we’ll put that email address in the “No Match Found” section.
Google Developer Expert, Google Cloud Champion
Amit Agarwal is a Google Developer Expert in Google Workspace and Google Apps Script. He holds an engineering degree in Computer Science (I.I.T.) and is the first professional blogger in India.