毎月のスプレットシート生成するやつ(spreadsheetで作成)

monthly_report.gas

function run() {
  try {
    var newSheetName = Utilities.formatDate(new Date(), 'Asia/Tokyo', 'yyyyMM')
    var sheet = SpreadsheetApp.getActive().getSheetByName('template')
    SpreadsheetApp.setActiveSheet(sheet)
    SpreadsheetApp.getActiveSpreadsheet().duplicateActiveSheet().setName(newSheetName)


    var sheet = SpreadsheetApp.getActive().getSheetByName(newSheetName)
    SpreadsheetApp.setActiveSheet(sheet)
    SpreadsheetApp.getActiveSpreadsheet().moveActiveSheet(1)
    setToDate()
  } catch (e) {

    Logger.log(e)


  } finally {

  }
}

function setToDate() {
  SpreadsheetApp.getActiveSheet()
    .getRange('H7') //挿入したいセル
    .setValue(new Date())
}