title: Script to append range of data in Google Sheets
body: <p>I have a script that will copy and send a range of data to another sheet. I want to add another part to the script, that will do the same function but append the data to a new row. </p>
  
  <pre><code>  function saveToRecords() {
      var ss = SpreadsheetApp.getActiveSpreadsheet();
      var source = ss.getRange('Report!L1:AC1');
      source.copyTo(ss.getRange('Records!A3:R3'), {contentsOnly: true});
    }
  </code></pre>
  
  <p>I have this script attached to a button in Google Sheets. The data is sent form <code>Report!</code> to <code>Records!</code>. The <code>Records!</code> sheet will save this data. So each time I click the button I would like the data to be sent to a new row. </p>
  
  <p>I know there is an easy way to do this! I have been stumped. Thanks for your help. </p>