Automatically create new Sheets like 1st 2nd 3rd 4th and so on

Question

I am using google Sheets

I want to do the following but I cant figure out how:

We do have like a daily Report sheet. We need it for every day, so I create 31 new Sheettabs 1 for each day and give the whole Spreadsheet the name of the Month.

I want to automatize it because its way too much work to copy like every day for every month over and over. Is there a script to do so? Its enough for me that I have like 1 Button to start the Script and its copying the first day as a template and paste it 30 times, so it would be easy to do some changes aswell.

thanks!

Answer 1

Use Sheet.copyTo(), like this:

function run() {
  manageSheets_({
    action: 'insert',
    monthName: 'December',
    numDays: 31,
  });
}

function manageSheets_({ action = 'insert', monthName, numDays = 31, masterSheet, ss }) {
  ss = ss || SpreadsheetApp.getActive();
  monthName = monthName || ss.getName();
  masterSheet = masterSheet || ss.getSheets()[0];
  for (let day = 2; day <= numDays; day++) {
    const sheetName = `${day} ${monthName}`;
    if (action === 'delete') {
      const sheet = ss.getSheetByName(sheetName);
      ss.setActiveSheet(sheet);
      ss.deleteActiveSheet();
    } else {
      masterSheet
        .copyTo(ss)
        .setName(sheetName);
    }
  }
}

If you need to delete the newly created sheets for some reason, replace action: 'insert' with action: 'delete' in the run() function.

You can assign the run() function to a button.