Ytukyg

I'm running a SendEmail script with a 3 triggers to be sent out on Mondays, Wednesdays and Fridays.

I have 10 sheets on the spreadsheet (each one contains an SentEmail script and each needs to be sent out on those days but I have only 20 trigger limitation)

This is the code:

function sendEmail() {

  var s = SpreadsheetApp.getActive().getSheetByName('BCX');

  var ss = SpreadsheetApp.getActiveSpreadsheet();

  var range = ss.getActiveSheet().getDataRange();

  var range = s.getRange('B5:Q20');

  var row = ss.getSheetByName('BCX').getRange("J1").getValue();

  var to = "info@google.com";

  var body = '';

  var htmlTable = SheetConverter2.convertRange2html(range);

var body = "Hi Team!"

     + htmlTable

     + "<br/><br/><b><i>**This is an automated email**</i></b><br/><br/>Any question please let me know.<br/><br/>Regards,<br/><br/>";

  var subject = "Google | Report " + row;



  MailApp.sendEmail(to, subject, body, {htmlBody: body});

};

But if I use something like the following script it will create 3 triggers each week until it reaches 20 triggers (trigger limit).

function createTriggers() {

   var days = [ScriptApp.WeekDay.MONDAY, 

               ScriptApp.WeekDay.WEDNESDAY,                                            

               ScriptApp.WeekDay.FRIDAY];

   for (var i=0; i<days.length; i++) {

      ScriptApp.newTrigger("sendEmail")

               .timeBased().onWeekDay(days[i])

               .atHour(7).create();

   }

};