Imagine if you created a Form and presented it to many users. It would be tedious to open the response Sheet every time to verify whether any user has submitted the Form or not. The problem would be worse if you created many Forms and sent them to many users. It will be helpful receiving a notification e-mail whenever there is a Form submission.
For this task, create a Form with three fields as shown in the following screenshot:
Submit the test data from a live form. Your submitted data will be saved in a response Sheet named something like Form Responses 1. The column headers will be as per your Form fields as shown in the following screenshot. Data may vary as per your input.
In the script file, you need to make the following changes:
Enter the
sendEmailfunction mentioned from the following code.Replace the receiver's e-mail ID. If you run this function, then it will send an e-mail with the last submitted data (bottom-most row) in the response...
