• View
• Edit
• History
• Print

GS-mail-trigger

function tr14() {
ScriptApp.newTrigger("xmail")
  .timeBased()
  .onWeekDay(ScriptApp.WeekDay.FRIDAY)
  .create();
xmail();
}

function xmail(){
url = "https://script.google.com/macros/s/AKfycby8dyRbADnVlQQ0hczOvyWKgrtzOru3jHXWfFzF7pn7_CeN5JIU/exec"
var res = UrlFetchApp.fetch(url);
var js = JSON.parse(res);
var sub = js[0]['fn']+" "+js[0]['ln']
var mess = js[0]['em']+"\n"+js[1]['em']+"\n"+js[2]['em']
var x = MailApp.sendEmail("[email protected]", sub, mess);
console.log(x)
}///



////////////////////////////////////////


function jooke() {
ScriptApp.newTrigger("xxmail")
  .timeBased()
  .onWeekDay(ScriptApp.WeekDay.TUESDAY)
  .create();
xxmail();
}

function xxmail(){
url = "https://script.google.com/macros/s/AKfycby8dyRbADnVlQQ0hczOvyWKgrtzOru3jHXWfFzF7pn7_CeN5JIU/exec"
var res = UrlFetchApp.fetch(url);
var js = JSON.parse(res);
var sub = js[0]['fn']+" "+js[0]['ln']
var mess = js[0]['em']+"\n"+js[1]['em']+"\n"+js[2]['em']
var to = js[5]['to']
MailApp.sendEmail(to, sub, mess);
console.log(to)
console.log(Session.getActiveUser().getEmail());
}///