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).
Step 1:
Step 2:
Step 3:
Step 4:
After clicking configure you will begin to receive alerts in the email account that is attached to your Google Drive account.
