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: