Add Custom Menu - Google Sheets User Interface (UI) Apps Script Series Part 1

Learn how to create & add custom menus to Google Sheets user interface using Apps Script. In this tutorial we'll create custom menus & submenus and assign functions to them.

This tutorial is Part 1 from Google Sheets User Interface (UI) Apps Script Series.

#googlesheets #userinterface #menu

[MasterAtayeu]

Dude, You're easier to understand than all of the professors I had back when I was in college for a comp sci degree.

[playlists]

Very efficient and clear descriptions. That you often also identify and explain common issues, and likely potential modifications to the code in your videos, is also very helpful. Nice work.

[punyhuman]

This deserves way more likes, so easy to understand, great work.

[santosahernandezmendoza]

Another brick in Google Apps programming
Thank you!

[Sulaimangalib]

You are the BOSS!
I've learned from you a lot. Thanks

[filobonda]

Nice beginner video, thank you! Do you have videos about add-on creation for google sheets? I'd especially be interested in understanding the whole publishing process step-by-step for a public add-on, as this is truly a pain.

[luqmansecond]

I tried sharing the Google sheet with the custom menu I have created with other users but they are unable to see the custom menu. Any way to make it visible to them?

[mathiasmugoni]

How do you add those icons that appear on the function's caption

[menafady]

Hello great man! greetings from Italy! i used the quarantain to learn about AppScripts from you and i want to thank you.


i got a question: how can i run the same script on bulk of spreadsheets in the same folder?



thank you again!

[airdropufree]

Hi, can you please make more video about this, waiting for html tutorial or database website. thank you.

[patrickm]

Your videos are great, I wish you had a github repo with your source in it for reference.

[wartable]

Nice video...any way to modify the existing bar? Like adding + / - on the Font Size so one does not have to open a drop down and select size but rather just hit a plus or minus button?

[LungosBoy]

Hi The script editor is not anymore existing under Tools menu of the google sheet...how can we add script editor to make a menu?

[bekindhavepassion]

Hello! Can you help with this issue? To create dynamic menu (items) from google sheets rows by using apps script. For example, when a range of rows is changed so the menu items are changed as well. Thank you.

[ShekiMetica]

It it possible to add links to certain sheets or tabs within the same sheet) in the custom menu? I can't seem to figure this out :(

[alexphillips]

Having serious problems adding a custom menu. Have tried multiple ways then tried yours and it still is failing at some point with no indication of where. If you or any one in the comments is willing to help, I'd love the help.

[arabiancorner]

Great Videos I must say, well elaborated .

[coeag]

Hi, thanks for this interesting video. Is there a way to create a gui interface (perhaps using html code) and show it to the user to capture info and write that info into some sheets cell ?

[jiliff]

Hey LGS, is there a way to simply open an already existing menu item using Action Script?

[hongminhle]

Hi there! If my function its parameter how could I put it into addItem :( ?