spreadsheetとAppsScriptでスケジュール表作成

AppsScriptのコード

function myFunction() {
 let spreadSheetByActive = SpreadsheetApp.getActive()
 
 let range = spreadSheetByActive.getSheetByName("sheet1").getRange("H2:I2")
 let date = spreadSheetByActive.getSheetByName("sheet1").getRange("D2")
 let data_holder = spreadSheetByActive.getSheetByName("sheet3").getRange("D1")
 let values = range.getValues()
 let dates = date.getValues()
 let count = data_holder.getValues()

 spreadSheetByActive.getSheetByName("sheet3").getRange(count,2,1,2).setValues(values)
 spreadSheetByActive.getSheetByName("sheet3").getRange(count,1).setValues(dates)
 spreadSheetByActive.getSheetByName("sheet3").getRange("D1").setValues([[++count]])

 let sh = spreadSheetByActive.getSheetByName("sheet1").getRange("C6:L24");
 sh.clearContent();
}