app promotion https://drive.eojji.com/upload

Send Promotional code.gs

function triggerSubmit(e) {
  //var form = FormApp.getActiveForm();
  //var formResponse = form.getResponses()[0];
  
  var formResponse = e.response;  
  var email = formResponse.getRespondentEmail().trim();
  Logger.log('email: %s', email);
  
  // var responseId = formResponse.getId();
  // var time = formResponse.getTimestamp();
  // var itemResponses = formResponse.getItemResponses();  
  // var name = itemResponses[0].getResponse().trim();
  
  // send row num: B1 cell in _promotional code1
  var ssId = PropertiesService.getScriptProperties().getProperty('ssId');
  var sheet = SpreadsheetApp.openById(ssId).getSheets()[0];
  var b1Range = sheet.getRange('B1');
  var rowNum = b1Range.getValue();
  Logger.log(rowNum);
  var rowData = sheet.getRange(rowNum, 1, 1, 9).getValues()[0];
  MailApp.sendEmail(email, "Upload app, Promotional code",
                    "code: " + rowData[2]
                    + "\n\nredeemable URL: " + rowData[3]);
  // Logger.log(rowData);
  b1Range.setValue(rowNum + 1);
}