How to Send Conditional Notification Emails Based on Google Form Answers
With the Google Forms Email add-on, you can easily set up conditional notification emails that are sent only to the form respondent and your team members only when one or more specified conditions are met.
To give you an example, if a Google Form asks the age of the submitter, you can send a notification email to the parent if the age entered is less than 18. If you are using Google Forms for tech support, you can send an escalation email to the manager if the customer has selected "high" forΒ the severity level.
Conditional or rule-based notifications in Google Forms can also help you route emails to different team members based on form answers.
For instance, a school may route parent's response to different teachers based on the pupil's class selected in the form. An online store may send different auto-responder emails to customers based on the product selected by the customer.
Set up Notifications Based on Conditionsβ
For this example, we have a Google Form where the user selects their county of residence and the notification is sent to different teams in the company based on the country selection.
If the user has selected Singapore or Japan, the Asia-Pacific team is notified, while for US and Canada, your form notifies the North American team. If some country is selected, the global support team is notified.
Create Conditional Email Ruleβ
Open your Google Form, launch the forms add-on and choose Create Email Notification
from the menu. In the configuration sidebar, check the Conditional Notifications
option and it will open a new window where you can define the conditional logic.
Define Conditional Email Logicβ
In the Conditional Logic window, create new rules by specifying the condition and the email address(es) where the notifications should be sent if the conditions are met.
You can put multiple email addresses, separated with commas. The email fields also accepts dynamic form fields so you can send confirmation emails to the respondent's address that they have entered in the form.
When a new form submissions is received and the form answers do not meet any of the specified conditions, the notification email is sent to the email address specified in the No match found
field. If that address is not specified, no notification is generated for that response.
The conditional logic consists of rules and each rule can have one or more criteria with filters.