title: GAS - onChange trigger (get value) from Active Sheet and Write to Another Spreadsheet
body: <p>Here's what I'm trying to do,</p>
  
  <p>Every time the user inserts a new row and adds a new value into spreadsheet 'A', the <code>onChange()</code> trigger will get the new value and insert the new value into spreadsheet 'B'.</p>
  
  <p>I'm not sure how I can get the new value since it requires <code>onEdit()</code> as well.</p>
  
  <pre><code>function onChange(e){
  
    var editedRange = e.source.getActiveRange();
    var editedRow = editedRange.getRow();
    var editedCol = editedRange.getColumn(); // integer
  
    if (e.changeType == 'INSERT_ROW') {
      Logger.log("inserted");
      // get new value
  
    }
  }
  </code></pre>