This week we are sharing a handy feature of Google Sheets that allows you to setup custom notification alerts when a spreadsheet has been edited. This is especially useful with Google Forms as you can create an email alert when a user submits a form.
To get started, open the spreadsheet you wish to create a notification rule from. Please note that each user can setup their own notification rules so this works even on shared spreadsheets.
Once your spreadsheet is open, click on the "Tools" menu and click "Notification rules":
You will now see the notification options:
You can receive an email alert when a change is made or a user submits a form. Alerts can be sent once a day or right away. If you select right away, you will receive an email every time either a change is made or a form is submitted...that could be a lot depending on how active your document is. Click on "Save" to apply your notification rules.
Some ideas for application: Parent meeting requests via Google Forms, volunteer applications, physicals for sports eligibility, absence documentation, and digital data spreadsheets.
Have a great weekend!