Add-on menu on open

<div>0:01 When a Google Sheet is opened, there is a moment in which you'll see, and even when a Google Sheet is created, there is a moment in which Apps Script is loaded.<br>0:10 And at that moment is what starts the trigger of onOpen. And we will literally go to my Spintax one, and we'll just copy this function on open.<br>0:21 And we're just going to copy that and put it into our code here. We're still naming this code.gs. OnInstall to onOpen Explore Coding in Google Sheets Activate A Certain Sheet When Opening a Spreadsheet Log Every Time a Google Sheet is Opened

You can rename your code if you want.<br>0:30 But we have this show alert that we're going to just, rename this alert to CPM custom, custom function by BetterSheets.<br>0:50 And we're going to write a little bit about how to use this right here. If you want to, you can see the whole thing.<br>0:58 It's just, spreadsheet . .getui, um,.alert, and then we have this button set, and we just need okay. This is fairly simple.<br>1:09 It just looks like a lot. OnInstall to onOpen GPT in SHEETS Advanced Coding in Google Sheets for Programmers How to Create a Custom Automation Menu in Google Sheets

This is the custom function you can use to calculate CPM or cost per, Okay, that's all we're gonna write.<br>1:24 So whenever this sheet is opened, it will create an add-on menu here. When we deploy it, we're gonna see this we will see this up here new deployment.<br>1:34 We will see it in extensions right here. This is different than a menu item. That is next to the help function , or help menu item.<br>1:45 That is what I have done previously in other videos and stuff on the unopened and creating this custom menu . Turn Your Apps Scripts into Native Formulas | Apps Script Custom Function Tutorial EASY Custom Menu - 1 Function CPM Custom Function How to Create a Custom Automation Menu in Google Sheets

And that's really cool, and you can add your app scripts to use that extra menu, and you can even create I think an add-on that creates that menu as well.<br>2:02 But we want to make sure that actually, no, I don't think you can do a custom menu on the side here.<br>2:07 It has to be here, and it'll show up all along here. Help will be here. That is just we'll write that in the marketplace, I think.<br>2:19 And here's all the functions you can use. It's button styles and sheet styles both show a sidebar . Are you an A1 or B2 Kind of Sheet Guy? Custom Menu - 2 functions How To Insert Row Under Header Automatically

So it's, this is where your users will use this.<br>2:29 And this onOpenSpreadsheetApp.getUI.createAddOnMenu and then addItem addToUI. We can add other items that have other functions if we want. For now, we are keeping it simple.<br>2:41 And hit save and that is adding the onOpen. Next video we'll do on install.</div> How to Spin Content Custom Menu - 2 functions How to Create a Custom Automation Menu in Google Sheets