Two Important Google Sheets Tips for Teachers

July 30, 2015
In today’s post, we are sharing with you two important Sheets tips pertaining to email notifications. You can use these tips to receive email notifications and keep track of the forms you create and share with your students. The first way is through the use of Sheets integrated feature called ‘ Notification rules’ and the second one is through using a third party add-on called Form Notification.

1- Notification rules
This is a feature we have covered in an earlier post a few months ago. 'Notification rules' allows you to receive a notification email every time a student submits a form. You can select whether you want to be notified each time a change is made to the form or only when a user submits a form. Similarly, you can also choose whether you want to receive a daily digest email or an instantaneous email. In this way, you will be able instantly track all the forms submission from your students and determine who submitted what and when. Here is how to activate it:

Head over to your Google form, and click on “ Tools” and select “Notification rules”

Select from the options provided in the box.

Watch this video to learn more about this tip.

2- Form Notification
This is a great Sheets add-on we discovered through Time Saving Tips. 'This add-on allows users to create and configure email notifications that are sent when a Form receives submissions. Users can have emails sent to the creator of the Form and/or send short, customized reply emails to the Form submitter.'