Google Sheets script to duplicate a sheet at the beginning of the month?

Question

I'm working on creating a budget on Google Sheets. I have two sheets for January (titled Jan Summary and Jan Transactions). I'm trying to create a script that will automatically duplicate those sheets at the beginning of each new month and change the sheet names that month as well. I'm not sure how to do this since I'm new to coding - does anyone have ideas?

question from:https://stackoverflow.com/questions/65622876/google-sheets-script-to-duplicate-a-sheet-at-the-beginning-of-the-month

Answer 1

function duplicateAndRenameSheet() {
  const prefix="Copy of ";//add in front of new name
  const postfix= ' ' + Utilities.formatDate(new Date(),Session.getScriptTimeZone,"E yyMMdd:HHmmss");//add to back of new name
  const ss=SpreadsheetApp.getActive();
  const sh=ss.getActiveSheet();
  let name=sh.getName();//active sheets name
  let nsh=ss.insertSheet({template:sh});//inserts a new sheet that's a copy of the active sheet
  nsh.setName(prefix + name + postfix);//renames the new sheet
}

Spreadsheet Methods

Sheet Methods