This morning I answered an email from a reader who was looking for a way to be alerted whenever a student entered new information into the Google Form that she shared with them. There are a couple of Google Sheets scripts that can be used to accomplish this task. The easiest script to use is called “form_alert.” This simple script will send you an email alert whenever someone enters new information into your form. The email that you receive will contain a timestamp along with the information that was submitted through your Google Form. The spreadsheet attached to your Google Form will still update as usual too. Directions for using “form_alert” are included in the screen captures below (click the images to view them in full size).
After clicking configure you will begin to receive alerts in the email account that is attached to your Google Drive account.