If only there was a button to actually create a new sheet. Once we click it, yes, there's this add sheet button, and yes, we can go to the downward arrow and say, duplicate . Sure, but let's have some fun in Google sheets. Let's insert a drawing . Let's make this fun shape. Click me now. I want to click this and copy the sheet. So let's go to extensions app script , function , duplicate sheet. We're gonna get variable sheet equals spreadsheet . Do get active sheet sheet. Do copy two spreadsheet app dot get active spreadsheet. That is the entire file here. That's all we should need to do. We'll have duplicate sheet and we're gonna click on this image.

We're gonna click the three buttons or dots. Click assign script and paste the name of the script. Click it. Here we can copy. Of copy. Click it again. Mix another copy of a copy of a copy. Click it again, copy of a copy of a copy. And now every time we click it, we have a new sheet. Hope you enjoyed that. You are watching better sheets here on YouTube. Make sure you check out this video or this video and subscribe right now to get more tips, tricks, how tos, get more out of your Google sheets than you ever have before. I'm excited to be making a ton more videos here. Ask me questions down in the comments and I will answer them in future videos. But for right now, right here, one of these videos is gonna be your next Google sheet.