Script to get the contents of a Google form submission emailed to you.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode characters
|// Remember to replace this email address with your own email address|
|var email = "firstname.lastname@example.org";|
|var s = SpreadsheetApp.getActiveSheet();|
|var headers = s.getRange(1,1,1,s.getLastColumn()).getValues();|
|var message = "";|
|var subject = "New Hire: ";|
|// The variable e holds all the form values in an array.|
|// Loop through the array and append values to the body.|
|for(var i in headers)|
|message += headers[i] + ': '+ e.namedValues[headers[i]].toString() + "\n\n";|
|// Insert variables from the spreadsheet into the subject.|
|// In this case, I wanted the new hire's name and start date as part of the|
|// email subject. These are the 3rd and 16th columns in my form.|
|// This creates an email subject like "New Hire: Jane Doe - starts 4/23/2013"|
|subject += e.namedValues[headers].toString() + " - starts " + e.namedValues[headers].toString();|
|// Send the email|
|MailApp.sendEmail(email, subject, message);|
|// Based off of a script originally posted by Amit Agarwal - www.labnol.org|
|// Credit to Henrique Abreu for fixing the sort order|
Oct 30, 2015
- How can I change it to draw the email from a column and row in the form instead of entering a static email?
- I'm getting errors on line 15 when I run the script. Am I doing something wrong?
- Do I need to change lines 7 and 15 to reflect what data I want to pull? If so, do you have a completed version as an example to draw from?
- You mention in the script notes in line 19 that you are drawing from the 3rd and 16th columns. Where is this specified in the code?
Apr 7, 2016
Hi, if possible add new value (random number) on last column and sent on email confirmation this value, when person filled out form
Column 17 or last
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment