This article describes how to set up automatic email responses so that an email notification is sent each time a new row is inserted into a Google sheet containing Google Forms responses (e.g., on future Google Form Submits).
From your Google form response sheet, start Mail Merge add-on by clicking on Extensions > Mail Merge > Start to open the Mail Merge dialog box.
NOTE: Alternatively, you can set up automatic email notifications in Google Forms by following the steps in this article.
Click on New in the Body Template field.
Create your email body and insert your *|merge fields|*, if required.
Click on Save to apply the changes.
Edit the following settings as required:
Select your email address *|merge field|* from the Email To drop-down menu.
Type an email display name in the text box under From Display Name.
Type an email subject in the text box under Subject.
Select Send email automatically from the On a Google Form Submit drop-down menu.
Click on Save to apply the changes.
Future Google form submits are now going to initiate automatic email responses.