如何让Google Sheets根据Google表单提交的关键字发送电子邮件

function sendEmails() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var data = sheet.getDataRange().getValues();
  
  for (var i = 1; i < data.length; i++) {
    var keyword = data[i][0];
    var recipient = data[i][1];
    var subject = data[i][2];
    var message = data[i][3];
    
    if (keyword !== "") {
      // 根据关键字筛选需要发送邮件的数据行
      var filteredData = data.filter(function(row) {
        return row[0] === keyword;
      });
      
      // 发送邮件
      MailApp.sendEmail(recipient, subject, message);
      
      // 清空已发送邮件的关键字
      filteredData.forEach(function(row) {
        row[0] = "";
      });
      
      // 更新Google Sheets中的数据
      sheet.getRange(2, 1, data.length - 1, data[0].length).setValues(data);
    }
  }
}