google sheets-使用循环在多个复选框上运行脚本

我有一个文件，我想在我的手机上使用它。每次我选中其中一个复选框时，我都会向联系人发送一封电子邮件。现在，我正在为每个复选框执行一个函数，总共20个。有没有一种方法可以循环完成？非常感谢你的帮助。

这是我的代码：

function onEditTriggerCourse1(){
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Courses Attribuées");
  var range = sheet.getActiveRange()
  if (range.isChecked()) {
    if (range.getA1Notation() == "g2") {
    sheet.getRange('a2').setValue(new Date());
    sendValidation1()
    
    range.uncheck();
    
    } else  {
    range.uncheck()
  }
}
}

function onEditTriggerCourse2() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Nouveau Client");
  var range = sheet.getActiveRange()
  if (range.isChecked()) {
    if (range.getA1Notation() == "g3") {
    sheet.getRange('a3').setValue(new Date());
    sendValidation2()
    range.uncheck();
    
    } else  {
    range.uncheck()
  }
}
}


function sendValidation1() {
 var recipient1= SpreadsheetApp.getActiveSpreadsheet().getRange("email1").getValue();
 var subject1=SpreadsheetApp.getActiveSpreadsheet().getRange("subject2").getValue();
 var body1=SpreadsheetApp.getActiveSpreadsheet().getRange("body1").getValue();
 var nameOfSender1=SpreadsheetApp.getActiveSpreadsheet().getRange("sender1").getValue();;
   var message = {
    to: recipient1,
    subject: subject1,
    body: body1,
    name: nameOfSender1,
  }

   MailApp.sendEmail(message);
}

function sendValidation2() {
 var recipient2= SpreadsheetApp.getActiveSpreadsheet().getRange("email1").getValue();
 var subject2=SpreadsheetApp.getActiveSpreadsheet().getRange("subject2").getValue();
 var body2=SpreadsheetApp.getActiveSpreadsheet().getRange("body2").getValue();
 var nameOfSender2=SpreadsheetApp.getActiveSpreadsheet().getRange("sender2").getValue();;
   var message = {
    to: recipient2,
    subject: subject2,
    body: body2,
    name: nameOfSender2,
  }

   MailApp.sendEmail(message);
}