How to send a confirmation email with Google Forms 

Update: the trigger option can now be found under the Edit Tab of the script editor window. PS: Thanks Jeff for the tutorial, it really helped me. Now we don't need any third party mail merge. We can just make our own. I admire your work. Keep it up!

How very kind of you to share how to do this. It helps me tremendously.

Jeff is great! Very knowledgeable and informative. I recently contacted him because I needed some custom code. He responded to my emails very quickly and was able to answer all my questions and help me get started on my project. Jeff is definitely a seasoned, experienced expert programmer. Thanks Jeff!

Great video, thank you!

It's the best what I've found online! Thank you very much!

Thanks Jef, for me still learning new things and possibility's.

Thanks, Jeff. You´re my hero!

Hi Jeff, thanks for the tutorial! I have a question though. Is it possible to delay somehow the confirmation email? I would like to send out the confirmation email 2 hours after a user submits the form.

Thank you for this tutorial! Although the Sheets scripts app has changed a bit it was still tremendously useful!

Thanks, Awesome explanation.

Thanks man! Just what I needed.

Thank you for the tutorial. Do you know if there is any way to see where the respondents where when they answered? So apart from the time stamp, is there a GPS "stamp" option?

This is great! I was wondering if there is an easy way to change font sizes? Thanks

subscribing, keep up good work, this was very helpful.

Hi! Thank you so much for this tutorial! I have a very quick question though. Some of the responses on my form are optional. When the confirmation email sends, it says that the optional responses are "undefined" if they are left blank. Is there any way to make it so that the blank optional responses are left blank in the confirmation email?

awesome thank you so much!

Thanks for the tutorial. May I know if it's possible to do some basic calculation using either column?

It worked ! thank you

Hey what's up? I wanted to ask whether it is possible to automatically send an invoice through Google Docs? The intention is that if you fill out a form then it sends an email with an attachment that individuals vary according to Google docs fields. I would be happy if you help me lior

Hi Jeff, THANK YOU SO MUCH !!!!!! I did not have a clue that this is possible to do with google drive forms. :)

Hi Jeff, I want to use the conditional mail merge feature using Google form. Means, I have a column with 10 multiple choice answer. And based on the user selection I want to send a custom email (10 multiple choices have 10 different email templates). Is it possible to do with Google scripts?

Excellent, simple and clear and it works~~~ Help me a lot!!! thank you very very much!!!!

Hey ! Thanks for your great tutorial, it's working fine ! I was wondering how can in select a value from an other sheet (on the same spreadsheet). I created an other one where i do calculations, i would like to insert the result in my email. This value is on the 2nd sheet, 6th column, so I tried something but didn't work: var userCommande = e.sheets[1].values[5]; I know this is some basic stuff but can't manage to find this solution with research, i'm becoming mad so here i ask haha. Thanks :)

Great stuff. This is a big help.

if I want to send confirmation with a sequence number ( say it's a space limited event, only the first 20 response got the seats). how to build that into the email? Can I insert one column into google from response and include that in the function script? I am not a computer science major and know very little of code or things like that... sorry about that....

Thank you sir very helpful sir

Hi, how do you make text bold, italics, and underlined, or change color, for example to blue? Thank you.

Is there a way to set this up so that it sends the "Thank you" message to the person filling out the form and a different message to a different specific email that says something like "Help request submitted..."?

Thanks Jeff! It didn't worked for me in my first try. So I double check the syntax and found out that it should have a space in `MailApp.sendEmail (userEmail, subject, message);` - on your video -> `MailApp.sendEmail(userEmail, subject, message);` which didn't worked in my case.

Thanks for the tutorial. I was wondering if there was a way to write a longer message and have it formatted properly. I try to write a long message and the whole message gets squished together. Thanks.

Any ideas why line 2 keeps saying: TypeError: Cannot read property "values" from undefined. (line 2, file "Code") unction myFunction(e) { var userName = e.values[1]; var userEmail = e.values [5]; var TrainingNumber1 = e.values[2]; var TrainingNumber2 = e.values[3]; var TrainingNumber3 = e.values[4]; var subject = "Registration Submitted"; var message = " + userName + " " \Thank you for your Student Conduct Justice On Going Training Regisration" " The registered for the following the training sessions: " + " Training Number 1: " + TrainingNumber1 + " Training Number 2: " + TrainingNumber2 + " Training Number 3: " + TrainingNumber3 + " All training sessions will be held in the Residence Life and Housing Conference Room in Van Hoesen Hall A-28A"; MailApp.sendEmail(userName, subject, message); } Thanks!!

This is great! Question though. On my responses form, I have a vlookup formula that looks up the name (inputted on the form) to get their email address. The email address is correctly auto-populating on column E.. which i show as var userEmail = e.values[6]; but I don't get an email. Do you have a workaround? Thank you!

Thank you so much for this tutorial! Very easy to follow and customize. For some reason, it sends two emails sometimes instead of just one. It doesn't always do it so I don't think I entered the code wrong. What could be the problem?

Thanks for sharing.

For the mailing "subject", do you specify that as a variable just like the message?

Is it possible to add captcha on google forms? Using Google Apps Script? Or any methods?

Hi Jeff, Can we send a text message instead of email? Is there any script for that

i've done this before, but when i start entering my "var userName = e.values[1];" it gives me a type error "cannot read property "values" from undefined" but i can't figure out why, it should be able to read that..?

Hi Mr Jeff, Thanks for the code however I'm not sure why mine isn't giving any error yet not sending me the mail as set. function myFunction(e){ var userName = e.values[4]; var userEmail = e.values[5]; var subject = "Form Submitted"; var message = "Thank you " + username + "for completing our student registration form"; MailApp.sendEmail(userEmail, subject, message) } My sheet table is as below; 0 1 2 3 4 Timestamp Student Number Title Name Surname E-mail address

I have a question and been browsing online for a while but haven't found an answer. How to add a verify email address link on autoresponder for google forms. I want to be able to know that the information entered in a google form corresponds to the email being submitted in the form. So far I've been able to add a custom message after filling out information but no luck on verifying that address, otherwise anybody could fill out and submit using other ppls email.

Great video, its it possible to get the form sent as an attachment such as a PDF ? cheers

Triggers are now found under the "Edit Tab", "All your Triggers". Otherwise, the code works fine. Thanks again.

Hi Jeff! Good and simple video. Just a question: Instead of sending an email to who submitted the form I would the message to be sent to me. How would this be done?

I'm getting this error. Any idea why? TypeError: Cannot read property "values" from undefined. (line 2, file "") Great video!

I tried to use this process with a spreadsheet that I am currently using formRanger with and can not get it to work. Do you know if it is possible to use this in addition to the code that is part of formRanger? Thanks so much for your help!

Is it possible to have a script send an email when a user submits a form but the emails to send to come from a different excel sheet and are themselves being added to constantly. sort of a notification system.

How can we attached PDF File with that Email

For you guys with the undefined issues, I've found one possible problem. Google has changed the form handling so that any blank values turn into undefined ones. Stackoverflow has a solution titled, "e.values in google forms skips empty answers, is there a workaround?" Another thing to check is that you create the script from the tools menu on the spreadsheet, not the form.

Hey Jeff, hope you are doing well.. dear i am unable to attached the Word Document File. pls help me out

hi jeff scripts doesnt work with another script, how can we run 2 scripts.

Hi Jeff. Excellent tutorial. Is there a way to insert a hyperlink into the text of the email? I'd like for the recipient to click on @username and be taken to my Instagram.

when i run code it will show line 2 error "values" please solve problem

I can't get this to work. I enter the below function myFunction(e){ var userName = e.values[1]; var userName = e.values[1]; var userEmail = e.values[2]; var date = e.values[3]; var subject = "Form Submitted"; var message = "Thank you," + userName + "for choosing " + date; MailApp.sendEmail (userEmail, subject, message); } but get the following error TypeError: Cannot read property "values" from undefined. (line 2, file "Code")Dismiss

How do I get the values and add? I put on a tie 'for', but the values are retrieved as a string.

Hi jeff! The script on insert menu doesn't appear. Can you please help on that? thanks

you think i can get the code?

How does the MailApp just appear? I'm following the instructions step by step, but when you typed in MailApp , the pull down list just popped up???? I'm currently signed into my gmail using a non-gmail email. Do I have to be signed in using my gmail email & then it will just appear or did you do something that you did not mention? Thanks so much! Up till that point I was doing great.

for some reason I just get an error when I try to run it. "TypeError: Cannot read property "values" from undefined.Dismiss" What am I missing? Here is my code (spreadsheet columns B and E are Name and Email respectively): function confirmation(e){ var userName = e.values[1]; var userEmail = e.values[4]; var subject = "Application Submitted"; var message = "Thank you, " + userName + " for your application. You will be placed on our waiting list " +date; MailApp.sendEmail (userEmail, subject, message);}

I have submiited a form, but the email wasn't sent. Here is my code: function myFunction(e) { var userName =e.values[1]; var userEmail = e.values[2]; var date = e.values[3]; var subject = "Blue Slip"; var message = "Please do your homework," + username + date; MailApp.sendEmail(userEmail, subject, message);} Please advise.

thanks Jeff. you should make more of these. i create youtubes too and appreciate this! question - how can we change the from address that sends the confirmation email? i want to change this email to my client's email.

Hi Jeff! Your tutorial is excellent! However, I'm having an issue. I had a previously created form and was trying to set up the confirmation email script. But when I tried to test it out and filled out the form - no confirmation email. So, I set up a completely new TEST form and used this: function myFunction(e) { var userName = e.values[1]; var userEmail = e.values[2]; var userEvent = e.values[3]; var subject = "Form Submitted"; var message = "Thank you " + userName + "for choosing " + userEvent; MailApp.sendEmail(userEmail, subject, message); } Still no email confirms. However, on my original script I'm getting these errors: ReferenceError: "Mailapp" is not defined. (line 9, file "Code") Authorization is required to perform that action. Here's the script for that: function myfunction(e){ var userName = e.values[1]; var userEmail= e.values[6] var date = e.values[7] var subject = "Form submitted"; var message = "Thank you " + userName + "for reserving tickets to the " + date; MailApp.sendEmail(userEmail, subject, message); } Any ideas? Thanks for your help!

here's another (perhaps trickier) question for ya Jeff. do you know how to change the email name the confirmation email sends from? see screenshot and arrow: www.dearblogger.org/wp-content/uploads/2015/04/change-email-name.png i've already tried changing Gmail settings, accounts, send mail as name, and this works for normal emails, but changes nothing as far as the confirmation email from Google Forms. your last advice helped me greatly to change the reply to email. any ideas how to change this email name to another email, or some text? thanks again.

It shown this TypeError: Cannot read property "values" from undefined. (line 2, file "FormEmailer")

I followed all your steps exactly, and I'm not able to get this to work... it's not sending the emails.

Hi Jeff great video and idea. Just i had it working fine. But suddenly it stopped working. It says it cant find the variable on line 2. Ive tried everything but nothing is wrong in the syntax since its the same as yours pretty much. Also the values are 0 indexing and referring to the correct column. Any idea why this is happening? This is the script: function myFunction(e) { var userName = e.values[2]; var userEmail = e.values[3]; var Subject = "Price Change Requested" var Message = " Thank you," + userName + " for submitting a change request "; var waiver = DriveApp.getFileById("1U2V5o9E7yubXDLDHQAO05JYWE3XnC-92MojmsmZ6z90"); var ChangePDF = waiver.getAs(MimeType.PDF); var ChangeExcel = waiver.getAs(MimeType.MICROSOFT_EXCEL); MailApp.sendEmail(userEmail, Subject, Message, {attachments:[ChangePDF]}); }

I did the exact thing and i got no email response

Hi Jeff, thanks for the great tutorial. I'm having a problem that I hope you can help. I entered the following code: function myFunction(e) { var RunnerName = e.values[1]; var Email = e.values[2]; var subject = "Jingle Bell Rock N' Run 5K- Thank you for registering!"; var message = + RunnerName + ", thank you for registering for Junior Auxiliary of Eunice's Jingle Bell Rock N' Run 5K race! We will send race details to this email, " + Email + ", as the race draws nearer. We look forward to seeing you on Saturday, December 5, 2015!"; MailApp.sendEmail(Email, subject, message); } And the error message I'm getting says: TypeError: Cannot read property "values" from undefined. (line 2, file "Code"). I tried looking through the other comments to get hints as to why it's not working, and I saw Edwin Hudepol had to "create a new results sheet". Perhaps that's my problem? If so, how do I do that? This was the first script I had ever written, so I was feeling pretty proud of myself until it didn't work.

Hi great video, for some reason Im not receiving a confirmation email after implementing the script. Ive actually successfully done it before but for some reason its not working this time. Below is the code I used, maybe you can catch a mistake Ive made. Thanks function myFunction(e){ var timestamp = e.values[0]; var firstname = e.values[1]; var MDlocal = e.values[6]; var userEmail = e.values[89]; var demodate = e.values[83]; var demostart = e.values[84]; var demoend = e.values[85]; var subject = "Demo Report Confirmation"; var totalhours = e.values[86]; var message = "Hello " + firstname + ", this email confirms that on " + timestamp + " you submitted a demo report for " + MDlocal + ", which occurred between " + demostart + " and " + demoend + " for a total of " + totalhours + ". REMEMBER: It is your responsibility to retain all confirmation emails in the event they are required as proof of time submitted."; MailApp.sendEmail(userEmail, subject, message); }

Hey Jeff, I am new at this and found your video to be quite useful to start my adventure As it was y first attempt I did everything you had said here but I did not get any email here is the Code. The Test Form was here - docs.google.com/forms/d/1fRHf6LMdA7z8MuBjdu4cubA4wnUz1jQvUQoHk3L8oWA/viewform function myFunction(e){ var userName = e.values[1]; var UserEmail = e.values[2]; var date = e.values[3]; var Subject = "Form Submitted"; var message = "Thank you, "+ Name + "For Choosing Mango Routes " + date; MailApp.sendEmail(UserEmail, Subject, message); }

Dude, how do you not have more subs? Thank you Jeff:) I have not tried this out just yet but thank you for all the explanations! If I have questions can I ask you? To all my G+ subs please check out Jeff Everhart channel and give the man a sub!

Script function not found: MailResult Edit: code here prntscr.com/6l78of It's that simple, there must be some little thing. I have a table with a different name, but is attached to the form, but I just can not get the value of it, I do not know, but thx.

don´t work values not define