user-interfacegoogle-apps-scriptgoogle-sheets

How do you add UI inside cells in a google spreadsheet using app script?


I'd like to add buttons to specific cells in Google docs spreadsheet. The apps script UI documentation talks about how to add a new panel, but it's not clear how UI in that panel could be attached to specific rows or cells.

Is it possible to add UI to particular cells, or are we limited to adding new panels?


Solution

  • The apps UI only works for panels.

    The best you can do is to draw a button yourself and put that into your spreadsheet. Than you can add a macro to it.

    Go into "Insert > Drawing...", Draw a button and add it to the spreadsheet. Than click it and click "assign Macro...", then insert the name of the function you wish to execute there. The function must be defined in a script in the spreadsheet.

    Alternatively you can also draw the button somewhere else and insert it as an image.

    More info: https://developers.google.com/apps-script/guides/menus

    enter image description here enter image description here enter image description here