Email on Insertion of a New Row

How do I automatically send an email when a new row is inserted?

This article describes how to setup automatic email responses so that an email notification will be sent each time a new row is inserted into a Google Sheet containing Google Forms responses, i.e. on future Google Form Submits.

Available From the Google Sheets Add-on Only

Step 1

From your Google Form response sheet, start the Mail Merge add-on by clicking Extensions > Mail Merge > Start.

This will open the Mail Merge dialog box.

NOTE: Alternatively, you can setup automatic email notifications in Google Forms by following the steps in this article.

Step 2

Click New under Body Template.

Step 3

Create your email body and insert your *|merge fields|*, if required.

Step 4

Click Save to apply changes.

Step 5

Edit the following settings as required:

  • Select your email address *|merge field|* from the Email To drop-down.

  • Enter an email display name under From Display Name.

  • Enter an email subject under Subject.

Step 6

Select Send email automatically from the On a Google Form Submit drop-down.

Step 7

Click Save to apply changes.

Future Google Form Submits will now receive an automatic email response.