{"id":78,"date":"2026-02-28T06:50:06","date_gmt":"2026-02-28T06:50:06","guid":{"rendered":"https:\/\/gigz.pk\/googlesheets\/?post_type=lesson&p=78"},"modified":"2026-03-28T02:23:39","modified_gmt":"2026-03-28T02:23:39","slug":"creating-custom-menus","status":"publish","type":"lesson","link":"https:\/\/gigz.pk\/googlesheets\/lesson\/creating-custom-menus\/","title":{"rendered":"Creating Custom Menus"},"content":{"rendered":"\n

Creating custom menus in Google Sheets<\/strong> allows you to add personalized options to the Google Sheets menu bar. This makes it easy to run scripts, functions, or workflows directly from the spreadsheet interface without opening the Script Editor.<\/p>\n\n\n\n

1. Why Use Custom Menus?<\/strong><\/h1>\n\n\n\n

Provide quick access to frequently used scripts
Enhance usability for collaborators who may not know how to use the Script Editor
Organize multiple scripts under a single menu
Streamline repetitive tasks with one-click execution<\/p>\n\n\n\n

2. Accessing the Script Editor<\/strong><\/h1>\n\n\n\n

Step 1:<\/strong> Open your Google Sheet
Step 2:<\/strong> Click Extensions<\/strong> > Apps Script<\/strong>
Step 3:<\/strong> The Script Editor opens where you can write your menu script<\/p>\n\n\n\n

3. Basic Example of a Custom Menu<\/strong><\/h1>\n\n\n\n
function onOpen() {
  var ui = SpreadsheetApp.getUi();
  ui.createMenu('My Custom Menu')
    .addItem('Show Message', 'showMessage')
    .addItem('Send Reminder Email', 'sendBasicEmail')
    .addToUi();
}function showMessage() {
  SpreadsheetApp.getActiveSpreadsheet().toast(\"Hello! Custom Menu is working.\");
}<\/pre>\n\n\n\n