Creating a new sheet using Apps Script

One of the most basic tasks you can perform with Apps Script is creating a new sheet. In this post, we’ll show you how to create a new sheet using Apps Script in Google Sheets.

Use the following lines to create a sheet and rename the new sheet created:

function createNewSheet() {
	let sheet = SpreadsheetApp.getActiveSpreadsheet().insertSheet();
	sheet.setName('A new sheet');
}