Google Form Notification: Sending a Report When a Duplicate Submission is Made

Copy Code

Google Form Notification: I would like to be notified when a duplicate submission is made to my form:

This script checks to see if someone has submitted previously and sends a report to the specified email address if they have. You may want to receive a google form notification when a submitter, that has not signed in, submits more than once. This script can help with that. In addition, you will need to have an Email: field in the form for people to fill out, as it uses that value to check if there were previous submissions.

Google Form Notification: Get the Code

Firstly, to copy the code please visit the GitHub repository located here:


Highlight the code, copy it, and paste it into your forms script editor.

Google Form Notification Copy Code

Code (see further instructions below the code): 

*The script has been updated to look for a field with the name email. You no longer need to add your the email field manually. 

Google Form Notification: Instructions for setting up code and additional settings


1. Open Script Manager by going to Tools->Script Manager in the form editor.

Google Form Notification

2. Copy the code into the Script Manager and don’t forget to save!
Google Form Notification

3. Edit this line in the code with the name of the Google sheet the responses are being recorded to and save.Google Form Notification Name

4. Authorize the script to run and set-up email where you will receive the report.

  • Go to the form editor and select settings from the menu. You should see three options: Authorize, Set Email, Set Email Position.
    Google Form Notification Script Settings
  • Select Authorize. You will be prompted to allow the script to run. You will receive an email if it authorizes successfully.
    Google Form Notification Settings for Email
  • Select the Set Email option to install the email you want the duplicate report sent to.
    Google Form Notification

5. Set-up the triggers so that the script runs when the form is submitted.

  • Open up the Script Manager (see above).
  • Select the trigger icon.
    Google Form Notification Trigger
  • Set-up the trigger like the picture below:
    Google Form Notification Trigger 2

6. When someone submits a duplicate from the same email address you will get an email like the one below:Google Form Notification Report


You May Also Like

About the Author: shodg001

Leave a Reply