Add an icon to a custom menu item on a Google Sheet

Adding a distinct signage to the custom menu is crucial as it helps users differentiate it from other menu items. Unfortunately, Google Sheets doesn't support adding images or icons like in HTML code using classes such as Font Awesome. However, you can add Unicode characters to achieve a similar effect.

Here's how you can do it:

function onOpen() {

  SpreadsheetApp.getUi()

      .createMenu('? Update Status')

      .addItem('?? Task Transfer', 'transfer')

      .addToUi();

}
        

In this example, we've used Unicode characters ('?' and '??') to add icons to custom menu items. You can find various Unicode symbols online, and some useful resources include:

• Unicode Character Table
• Unicode Character (U+3164)

Simply copy the desired Unicode symbol and paste it into your Google Sheets script to add icons to your custom menu items. This simple addition enhances user experience by providing visual cues and making navigation more intuitive.