EmailConfirmation.gs

function emailConfirmation() {
  var sheet = SpreadsheetApp.getActiveSheet();
  var startRow = 2;
  var numRows = sheet.getActiveRange().getNumRows();
  var dataRange = sheet.getRange(startRow, 1, numRows, 23);
  
  var data = dataRange.getValues();
  
  var EMAIL_SENT = "EMAIL_SENT";
  var INVALID_EMAIL = "INVALID_EMAIL";
  
  for (i in data) {
    
    var row = data[i];
    
    var emailSent = row[21];
    var emailAddress = row[7];
    var name = row[1];
    var message = "Olá, " + name + "! Você se inscreveu para o XVII Seminário de Yoga. \nPara realizar o pagamento da sua inscrição, acesse o link abaixo.";
    var subject = "INSCRIÇÃO XVII SEMINÁRIO DE YOGA";
    
    if (emailSent != EMAIL_SENT && emailSent != INVALID_EMAIL) {
      try {
        MailApp.sendEmail(emailAddress, subject, message);
        sheet.getRange(startRow + parseInt(i), 22).setValue(EMAIL_SENT);
        SpreadsheetApp.flush();
      } catch(e) {
        sheet.getRange(startRow + parseInt(i), 22).setValue(INVALID_EMAIL);
        SpreadsheetApp.flush();
      }
      
    }
       
  }
  
}