Great video! I got things working from your explanation and was able to deploy an internal app. I do think more could be said about scopes, but that's a different video! I did have an issue where I ended up with my menu only having a "Help" option that pops up a dialog with the "Post Install Tip *" that is required in the Store Listing page. This was because I had copied a script adding a menu from another apps script that used ui.createMenu('Menu') which I modified to ui.createAddonMenu('Menu') which was what broke things. You had the correct ui.createAddonMenu() in the video without any variables being passed to the function, but I missed it! I was up to version 5 of my deployment before I finally caught the mistake and got things working. I just wanted to drop this here in case someone else does the same sort of thing while trying to deploy.
@@BetterSheets Thanks I published it internally for our organization to help clean up data in gSheets similar to Ablebits Power Tools, like Capitalize, all lowercase, all uppercase for sometimes thousands of records/rows. This helps keep the comments and notes in tact w/out having to create new columns to do functions on and then delete/merge, etc. :-)
Thanks a lot for this great tutorial. Would it be possible to publish this script so that organization internal users approve it once and then can use the same functionality in several different sheets without approving it again? And can the add-on also export sheet data in to a doc from every sheet?
Yes. There are two ways to handle this. First, restrict installing all Google Workspace Marketplace apps in Google Admin Console -> Apps-> Google Workspace and Marketplace apps-> Settings-> [X] Allow user to install allowlisted apps from the Marketplace. Then in Google Admin Console -> Apps-> Google Workspace and Marketplace apps-> Apps list-> Allowlisted App Search for the name of the app, Allow users to install this app, then you can limit the app to be allowed for specific OUs or groups. The second way which I do not recommend is to allow all marketplace apps and then use the same Allowlisted App wizard to "Block users from installing this app" Which approach you take depends on if you are blocking everything and then poking holes (proactive) or if you are allowing everything and then patching holes (reactive). Blocking all is more secure, but harder to manage up front.
Great video! I got things working from your explanation and was able to deploy an internal app. I do think more could be said about scopes, but that's a different video!
I did have an issue where I ended up with my menu only having a "Help" option that pops up a dialog with the "Post Install Tip *" that is required in the Store Listing page. This was because I had copied a script adding a menu from another apps script that used ui.createMenu('Menu') which I modified to ui.createAddonMenu('Menu') which was what broke things. You had the correct ui.createAddonMenu() in the video without any variables being passed to the function, but I missed it! I was up to version 5 of my deployment before I finally caught the mistake and got things working. I just wanted to drop this here in case someone else does the same sort of thing while trying to deploy.
Good point!
Thanks! Great tutorial - saves me lot of time. Man of the day!
Amazing. What else do you need help with?
It is super clear and crisp, I didn't find any clear tutorials about publishing the add-ons. I just submitted my add-on for the review, thanks!
Good luck!
Oh man, this is a fantastic tutorial. As a non-programmer I was struggling a lot to succeed in this and this video helped perfectly. Thanks!
Glad its useful!
Thank you soo much!!!! Is and will help me so much. And for that I just bought your Udemy courses. :-)
Amazing. Let me know what add on you ultimately publish.
@@BetterSheets Thanks I published it internally for our organization to help clean up data in gSheets similar to Ablebits Power Tools, like Capitalize, all lowercase, all uppercase for sometimes thousands of records/rows. This helps keep the comments and notes in tact w/out having to create new columns to do functions on and then delete/merge, etc. :-)
Thanks a lot for this great tutorial. Would it be possible to publish this script so that organization internal users approve it once and then can use the same functionality in several different sheets without approving it again? And can the add-on also export sheet data in to a doc from every sheet?
Users need to approve an addon each time they use it in a sheet.
@@BetterSheets thank you for the response 😊 Each time they use it in the same sheet or when copying the sheet and using the add-on in the copy?
can you tell about how to call your addon for special sheet that you will sell in your website, so sheet which user will buy addon will be called?
Can you please explain? Addon special sheet?
Can you restrict what users have access to it within your domain?
I dont think so.
Yes. There are two ways to handle this.
First, restrict installing all Google Workspace Marketplace apps in Google Admin Console -> Apps-> Google Workspace and Marketplace apps-> Settings-> [X] Allow user to install allowlisted apps from the Marketplace.
Then in Google Admin Console -> Apps-> Google Workspace and Marketplace apps-> Apps list-> Allowlisted App
Search for the name of the app, Allow users to install this app, then you can limit the app to be allowed for specific OUs or groups.
The second way which I do not recommend is to allow all marketplace apps and then use the same Allowlisted App wizard to "Block users from installing this app"
Which approach you take depends on if you are blocking everything and then poking holes (proactive) or if you are allowing everything and then patching holes (reactive). Blocking all is more secure, but harder to manage up front.
mantap bang..
Thanka