Created
May 31, 2017 22:08
-
-
Save fastmover/50d4dbbf46a9e0bba5efcf74bf693394 to your computer and use it in GitHub Desktop.
This will email a response to a form submission from Google Forms. Be sure to set the current project triggers to Run emailResponse from form submission.
This file contains hidden or 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
| function emailResponse(e) { | |
| var form = FormApp.getActiveForm(); | |
| var formResponses = form.getResponses(); | |
| for (var i = 0; i < formResponses.length; i++) { | |
| var formResponse = formResponses[i]; | |
| var itemResponses = formResponse.getItemResponses(); | |
| var output = ""; | |
| var htmlOutput = "<h1>Form Response</h1><hr>"; | |
| for (var j = 0; j < itemResponses.length; j++) { | |
| var itemResponse = itemResponses[j]; | |
| output += itemResponse.getItem().getTitle() + ": " + itemResponse.getResponse() + "\n\n\n"; | |
| htmlOutput += "<b>" + itemResponse.getItem().getTitle() + "</b>: " + itemResponse.getResponse() + "<br><br>"; | |
| } | |
| } | |
| MailApp.sendEmail('[email protected]', 'E-Mail Subject', output, { | |
| htmlBody: htmlOutput, | |
| name: 'Web Form', | |
| noReply: true | |
| }); | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment