Make add-on automatically available for every sheet I open

[Mike]

Hi All.  This might be a very basic question, but I have not been able to track down an answer yet.  

If I want a custom "tools" menu to show up every time I open an existing or new sheet, (1) is that possible without publishing a public add-on, and (2) how can I make it automatically visible in the sheets extensions menu (so I can enable it)?

The use case is, I want to be able to install a common menu and scripts for my own personal use, whenever I open a sheet.  In the old Office world, you could create a template that effected all spreadsheets you open.  Am I missing something simple?  Any help appreciated.   

[Keith Andersen]

Mike,

Are you the only user of this spreadsheet?

And yes, it is possible to make a special menu upon opening the spreadsheet workbook.

https://youtu.be/_Iq2-_WgFdY

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/46a71abe-54f5-4e06-a426-8995779622bfn%40googlegroups.com.

[CBMServices Web]

There is no equivalent to that in Google sheets. You can create a menu via a script, but that script would need to be existing in the spreadsheet to run. 

There is no way to cause all spreadsheets to have a particular menu show unless each spreadsheet has the same script already in it and runs to show that menu.

--

[Mike]

Thanks Keith.  I am clear how to add menus and functions for a given sheet.  What I am hoping to do is to automatically have a TOOLS menu added whenever I open a new spreadsheet.  I don't think the video is addressing automatically adding the script to all new spreadsheets?  Did I miss something?

[Mike]

Thanks George.  I was afraid of that.  Just had to ask...

[Keith Andersen]

Mike,

I misunderstood what you needed. Sorry.

Keith 

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/450fcb70-3abb-4ac2-b6e6-75fcf4235423n%40googlegroups.com.

[Andrew Roberts]

If you convert your script into an Add-on and install it privately (so you don't have to go through the verification process) and unlisted just you will see it on all your GSheets.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CAJ8MD4xuxtwyQwP-PLiWaYFRwgORv0%2B8hZx-MRm-EufwHSeMWw%40mail.gmail.com.

[Mike]

Thanks Andrew.  I had hoped this was possible.  I don't have experience with creating add-ons, so I tried following the "Clean up data in a spreadsheet" GAS samples examples here, but that was based on a TEST deployment which required connecting to a specific spreadsheet.  Do you happen to know where to find some instructions/steps to "convert your script into an Add-on and install it privately".  Seems to be exactly what I want, but not sure the steps to "install privately".

[Andrew Roberts]

That tutorial is more for testing, rather than deploying an Add-on. Although unless you have a workspace account, rather than a consumer gmail account, it looks like you can't publish the add-on privately (just to your domain). If you look in the attached screenshot of the set-up of the Marketplace SDK (where you deploy add-ons) the "MAKE INTERNAL" is greyed out.

Do you have a consumer or workspace account?

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/2179e883-9d22-43aa-ada6-816e233ea434n%40googlegroups.com.

[Mike]

Thats' what I found so far.  The key is "Although unless you have a workspace account, rather than a consumer gmail account, it looks like you can't publish the add-on privately (just to your domain)".  

I am all set at work with workspace account, but failed to be able to create and add-on for my personal use (not public) using my personal gmail account.  Just wanted a menu and some scripted tools available in every spreadsheet I work on.  I guess adding a custom menu is not possible on a personal account using add-on's.  If there is another approach for personal accounts, do share! :-)

[Andrew Roberts]

You used to be able to install an Add-on from the marketplace listing before it was published, that may still work. Also if you don't mind making your Add-on public on your consumer account you may still be able to install it but you'll still get the verification message and will be limited to the number of places it can be installed??

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/16374765-ceb5-49ab-8987-d78535a763d1n%40googlegroups.com.

[Mike]

Thanks again for helping Andrew.  I appreciate the time.  I will have to go back to copying a template every time I create a sheet - ugh!  - but "the price is right"!