title: Can't set a value on a cell
body: <p>I'm able to send multiple emails at once using Google Spreadsheet.</p>
  
  <p>Now, I'm trying to set a cell with the information that the emails have been sent. </p>
  
  <pre><code>function enviar() {
    var app = SpreadsheetApp
    var sheet = app.getActiveSheet()
    var range = sheet.getActiveRange()
    var contact = range.getValues()
    for (var i = 0; i &lt; contact.length; i++) {
      var email = contact[i]
      GmailApp.sendEmail(email[3], email[5], email[6])
      email[7].setValue("enviado")
      email[7].setBackground("green")
      email[7].setFontColor("white")
    }
  }
  </code></pre>
  
  <p>The problem is on the three following lines: </p>
  
  <pre><code>email[7].setValue("enviado")
  email[7].setBackground("green")
  email[7].setFontColor("white")
  </code></pre>
  
  <p>I can't find a way to get a range other then:</p>
  
  <pre><code>SpreadsheetApp.getActiveSheet().getRange("H2")
  </code></pre>
  
  <p>Another idea was:</p>
  
  <pre><code>range[0].getRange()[7].setValue("enviado")
  </code></pre>
  
  <p>None of them worked.</p>