Skip to content

Instantly share code, notes, and snippets.

View JEverhart383's full-sized avatar

Jeff Everhart JEverhart383

View GitHub Profile
function formSubmitReply(e) {
var userEmail = “example@gmail.com”;
var name = e.values[2];
var letterdraft = e.values[1] + " " + e.values[2];
var letterdraftHTML = '<p>' + e.values[1] + " " + e.values[2] +' </p>';
GmailApp.sendEmail (userEmail, name, letterdraft, {htmlBody: letterdraftHTML, name: name, replyTo: e.values[4], cc: “another@gmail.com, thirdemail@gmail.com“});
}
/* Send Confirmation Email with Google Forms */
function Initialize() {
var triggers = ScriptApp.getProjectTriggers();
for (var i in triggers) {
ScriptApp.deleteTrigger(triggers[i]);
}
function sendFormByEmail(e)
{
var email = "digitaledcollaborator@gmail.com";
var becky = "dec@longwood.edu";
var subject = "Google Docs Form Submitted";
var s = SpreadsheetApp.getActiveSheet();
var headers = s.getRange(1,1,1,s.getLastColumn()).getValues()[0];
// Includes functions for exporting active sheet or all sheets as JSON object (also Python object syntax compatible).
// Tweak the makePrettyJSON_ function to customize what kind of JSON to export.
var FORMAT_ONELINE = 'One-line';
var FORMAT_MULTILINE = 'Multi-line';
var FORMAT_PRETTY = 'Pretty';
var LANGUAGE_JS = 'JavaScript';
var LANGUAGE_PYTHON = 'Python';