当有人点击订阅谷歌表格时,我有一个代码可以从我的网站收集电子邮件。该过程基于此处的这些步骤: https: //github.com/jamiewilson/form-to-google-sheets/blob/master/README.md 但是我还想向订阅我网站的人发送一封电子邮件通过谷歌脚本,但我无法这样做。这是代码:
function doPost (e) {
var lock = LockService.getScriptLock()
lock.tryLock(10000)
try {
var doc = SpreadsheetApp.openById(scriptProp.getProperty('key'))
var sheet = doc.getSheetByName(sheetName)
var headers = sheet.getRange(1, 1, 1, sheet.getLastColumn()).getValues()[0]
var nextRow = sheet.getLastRow() + 1
var newRow = headers.map(function(header) {
return header === 'timestamp' ? new Date() : e.parameter[header]
})
sheet.getRange(nextRow, 1, 1, newRow.length).setValues([newRow])
var row = sheet.getLastRow()-1
var column = sheet.getLastColumn()
var dataRange = sheet.getRange(2, 1,row,column)
var data = dataRange.getValues();
var email = data[row-1][1];
MailApp.sendEmail("man@test.com", "Wellcome To Engineers", email);
return ContentService
.createTextOutput(JSON.stringify({ 'result': 'success', 'row': nextRow }))
.setMimeType(ContentService.MimeType.JSON)
}
catch (e) {
return ContentService
.createTextOutput(JSON.stringify({ 'result': 'error', 'error': e }))
.setMimeType(ContentService.MimeType.JSON)
}
finally {
lock.releaseLock()
}
}
如果收集列表中的电子邮件但不向任何人发送电子邮件
慕妹3242003
相关分类