I'm new to scripting and have been trying to get this URL shortener script to show in my spreadsheet. I have clicked 'debug' to authenticate the script, then what?

I thought the menu item would be created in the Google Sheet... what am I missing please? I'm sure it's pretty basic!

If you want to add something to a menu, you need to implement an onOpen function, and do the necessary menu setup there.

Take a look at this example from Google's documentation:

function onOpen() {
  // Add a custom menu to the spreadsheet.
  SpreadsheetApp.getUi() // Or DocumentApp or FormApp.
      .createMenu('Custom Menu')
      .addItem('First item', 'menuItem1')
      .addToUi();
}

This will add a menu Custom Menu with a single item First item, which, when selected, will launch a function menuItem1, which you will have to implement:

function menuItem1() {
  // Do whatever you like here
}

Note that you will have to reload your spreadsheet in order to have onOpen run. So you won't see any effect by just writing the script and clicking save, you need to reload (Cmd-R) on the spreadsheet window for the new menu to appear.

A script error may prevent the menu from appearing. If you don't see the desired result after reloading the spreadsheet, check the script editor's View → Execution Transcript for any errors.

  • Thanks, Vidar, I'll give that a go today! Appreciate the help greatly. – Rob Clarke Nov 14 '17 at 19:04

Your Answer

 

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.