Enable Email Notifications Google Form to 2 email accounts

Enable Email Notifications Google Form to 2 email accounts -

One of the advantages of the google form is the availability of facilities to set up email notifications online form google form, that notification can be set in order to provide information to providers form via email each time there responder to input the data, so that every time there is a responder or a user to input data via form google form provided then automatically the information can be known by the provider of online forms through notification pemberitahaun via email.

this time my my will be little to discuss about how to set email notifications google docs online form in order to send mail to two or more emails at once, and I assume you already know about how to create an online form with google form. If you are new to you can read my previous article on how to create an online form with google form.

Setting up email notifications online form google Sheet before you can send mail to two or more messages at once

When form google form is created then there will be two special files are generated automatically, the first one is form and the second is data spreadsheet, form useful for media input data including display online form web-based, while the spreadsheet data is a file used as a storage medium for inputted data form google form that has been created previously.

to enable email notifications in the google form in order to send notifications to 2 or more email we will use google script, with the steps as follows:

a.? Sign in to your google drive
I assume you have previously made forms and spreadsheet data to the form in the google drive you.

b. Activate or open the spreadsheet data to your online form.
Data spreadsheet is usually presented as Microsoft Excel, please double click on your spreadsheet data, or right-click? on your spreadsheet file> menu select Open With> Choose Sub Menu Data Sheet.

c. In the data sheet is already active, select the Tools menu> then select the sub menu Script Editor ..., looks like the image below:

d.Pada Script Editor we will create a script to send an automated email

Eg data sheet that we created has a column Temestamp name email and column message?

Let's say we will create an email pemneritahuan, whenever there responder who perform data input, then google form will automatically send a notification email, the email provider to know the owner of the online form, and the other the responder to the input data.?

please copy and enter the following script google script editor on your data sheet.

emailNotification function (e) {
? var name = e.values ​​[1]; // Retrieve the data inputted name of the spreadsheet columns 1

var email = " email ";
var subject = "New Input already received";
var message = "The new input has been received from" + name;

MailApp.sendEmail (email, subject, message);
}

emailConfirmation function (e) {
var name = e .values ​​[1]; // Retrieve the data inputted name of the spreadsheet columns 1
var EMAILADDRESS = e.values ​​[2]; // Retrieve email data from column 2
var subject = "Thank you for Partisifasinya";
var message = "Thank You" + name + "You've berfartisifasi, your data is our savings";

MailApp.sendEmail (email, subject, message);
}

Posts email red please replace with your email (eg example@gmail.com), notifications for you will be sent to the email you enter it.

so it looks like the view below:

Please you save by pressing the diskette lingkarin as in the image above.

e. Enable Trigger to Google Script Alert email.
The next step is to activate the trigger or Piccu for the script, which means that the script even though you have saved will not be started or processed if it is not associated with the trigger, trigger could be when there responder storing data or when there are changes to the spreadsheet data.

to activate the trigger script steps are as follows:

1. on the script editor, select the menu Reseources > [194501million] Current Project's triggers , as shown below:

2. dialogue Current Project's triggers, please click the link No triggers set up , Click here to add one now , and adjust as shown below:

First Row Run select, emailNotification, then Events, select From spreadsheet and on from submit,

As for the second line, the column rum select emailConfirmation, for Events select from spreadsheets and on from submit.

that function emailNotification and emailConfirmation we make discript will be executed or processed ketikaada responder who perform Submit form data via google form.

for each of the line still, please Klink link Notifications , which are in addition to his right. siahkan set as shown below:

Please you press Ok, and then press the Save button.

3. If you have done the above process, the next step please adna trying to activate online form google your form, and for the trials, please enter form data requested and press submit.

data will be sent to a google spreadsheet form, and you will get a notification to emaiil you .

Until the stages above you are finished activate email notifications google form in order to send notifications to 2 email or more simultaneously whenever there responder who do submit or input data.

the above examples are just a a simple example, google script you can create e-mail notification in accordance with the wishes of both sides to see the email contents of email that we can design according to your desires and of the content of the email message.

Similarly, an email on how to activate email notifiaksi google form (google docs, google spreadsheet) to send messages with confirmation and notification to 2 or more emai. hopefully useful and good luck.

Tweet