Sending an e-mail notification on Form submission

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:

Sending an e-mail notification on Form submission

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 ...

Get Learning Google Apps Script now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.