title: How to Dynamic Paste values after Last Row [Google Script]
body: <p>I am building a script to copy a row in another spreadsheet. The idea is to have one sheet with the inputs that are going to be stored in a second spreadsheet. However, I am facing some real struggle in building the dynamic paste range. This is the point I was able to reach with my present knowledge:</p>
  
  <pre><code>       function Export() {
  var ss = SpreadsheetApp.getActiveSpreadsheet()
  var database = SpreadsheetApp.openById("xxx");
  var source = ss.getSheetByName('yyy');
  var dataToCopy = source.getRange('bb').getValues();
  var copyToSheet = database.getSheetByName("zzz");
  var copyData = copyToSheet.getRange('bb').setValues(dataToCopy)
  var Clean = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('yyy').getRange('bb');
              Clean.clear({contentsOnly:true});
  }
  </code></pre>
  
  <p>This script copy a range into a fixed range in a second spreadsheet, and it clears the values present in the source. My question is: How can I create a range that makes the script paste the data in the first blank row in the second spreadsheet?</p>
  
  <p>I tried some combination of appendRow, getLastRow, insertRowAfter, but I was not able to get it done.</p>
  
  <p>Thank you for your time!</p>