title: Trying to send email based on checkbox selection
body: <p>I am trying to send emails automatically if the checkboxes in Column H are checked. I barely know enough about code to get in trouble. The code I have has been Frankensteined together, so I know I'm missing something but I'm too new at this to understand what. If I run the code as-is, an email is sent if there is an email address listed in Column G, but it is sent regardless of if Column H is checked or not. I don't want an email sent if the checkbox is not checked. I've searched through the forums and have tried to piece together a solution that works for me but I just keep hitting a wall. I know the problem lies with identifying the checkbox and that's where I'm getting lost. Any help would be greatly appreciated. </p>
  
  <pre><code>var EMAIL_SENT = "EMAIL_SENT";
  
  function send1stnotice() {
    var sheet = SpreadsheetApp.getActiveSheet();
    var startRow = 3;  // First row of data to process
    var numRows = sheet.getLastRow()-1   // Number of rows to process
    var dataRange = sheet.getRange(startRow, 1, numRows, 1000)
    // Fetch values for each row in the Range.
    var data = dataRange.getValues();
    for (var i = 0; i &lt; data.length; ++i) {
      var row = data[i];
      var checkbox1 =row[7];
      var emailAddress = row[6];
      if (emailAddress.match('@') == null){
          continue;
      };  // First column
      var subject = "test subject";     
      var message = "test message";    
      var emailSent = row[8];     
  
      if (emailSent != EMAIL_SENT &amp;&amp;  checkbox1!= 'FALSE') {  // Prevents sending duplicates
  
        MailApp.sendEmail(emailAddress, subject, message);
        sheet.getRange(startRow + i, 9).setValue(EMAIL_SENT);
        // Make sure the cell is updated right away in case the script is interrupted
        SpreadsheetApp.flush();
      }
    }
    }
  </code></pre>