Insert Image to Google Sheets Menu

Question

I created a new submenu on the toolbar. I want to have several drop down items each with their own assigned image so that when someone clicks their name an associated image from the Drive automatically appears in the cell. How do I do this? This is what I have so far:

    function onOpen() {
      var ui = SpreadsheetApp.getUi();
      // Or DocumentApp or FormApp.
      ui.createMenu('Supervisor Signatures')
      .addItem('First item', 'menuItem1')
      .addSeparator()
      .addSubMenu(ui.createMenu('Sub-menu')
          .addItem('Second item', 'menuItem2'))
      .addToUi();
     }

function menuItem1() {
  SpreadsheetApp.getUi() // Or DocumentApp or FormApp.
     .alert('You clicked the first menu item!');
}

function menuItem1() {
  SpreadsheetApp.getUi() // Or DocumentApp or FormApp.
     .alert('You clicked the first menu item!');
}

Nimantha · Accepted Answer · 2021-11-12 03:50:20Z

1

Looked around the community and found this post on Using Google Script, how can I insert an image into a table cell?.

The answers simply mention to just do a function that sets the cell formula to -- =Image(<insert-image-url-here>) with getRange(<insert-cell-here>).setFormula();

Regarding using the images from your Drive, here's a simple and quick guide on how you can Get Images from Google Drive

edited Nov 12, 2021 at 3:50

Nimantha

6,5276 gold badges32 silver badges78 bronze badges

answered Mar 31, 2016 at 9:49

AL.

37.9k10 gold badges147 silver badges287 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

AL. Over a year ago

I think this page on Adding Images to Google Spreadsheet would also be helpful for you.

Collectives™ on Stack Overflow

Insert Image to Google Sheets Menu

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related