Google Sheets - Copy data from one sheet to another

#Google Sheets copy data from one sheet to another

Google Sheets copy data from one sheet to another

Code.gs

function copyData(){
  const ss = SpreadsheetApp.getActive();

  const copyFrom = "currentPrice";
  const copyTo = "priceHistory";
  const copyRange = "A7:E7";

  const sourceSheet = ss.getSheetByName(copyFrom);
  const destSheet = ss.getSheetByName(copyTo);

  const sourceValues = sourceSheet.getRange(copyRange).getValues();

  for(let i=0; i<sourceValues.length; i++){
    destSheet.appendRow(sourceValues[i]);
  }
}