Publish as a private add-on to avoid granting permission on copies of gsheets

Question

I have a similar question to both of the questions below. I have a script bound to a google sheets, and I use this sheet as template. However I'm looking for an option to not have to grant permission each time I copy the file. From reading the answers in the questions below, I understand I have to publish a standalone script as an add-on. However, reading this answer, I see that I need to create a Cloud Platform Dashboard and all bunch of stuff which looks pretty messy to me, such as google reviewing process. Again, it is only for personal use... Is there a way I can privately publish it as an add-on, without having to go through all the process? Thank you

What is the best way to create Container-bound Scripts that can be cloned? Grant permissions on open for first time for a bound script in Google Sheets

You can always use a standalone script, if you don't want spreadsheet hook triggers like onEdit or button or anything else. Write a standalone script which loops through your spreadsheets doing what's needed. — TheMaster, Dec 16 '20 at 17:50
if you have your own domain you can publish a domain-wide addon without going through the verification process. — Ninca Tirtil, Dec 16 '20 at 19:53

score 0 · Answer 1 · answered Dec 17 '20 at 06:48

0

If you don't want spreadsheet hook triggers like onEdit or button or anything else, You can use a standalone script.

A standalone script can be written, which loops through your spreadsheets doing what's needed based on a time trigger.

answered Dec 17 '20 at 06:48

TheMaster

45,448
6
62
85

Ok, thank you. Is there a way, however, to get a time triggered standalone script to loop through the spreadsheet of only one google drive folder? – Loïc Chabut Dec 22 '20 at 18:54
@LoïcChabut Yes That is possible – TheMaster Dec 22 '20 at 19:26

score 0 · Answer 2 · answered Dec 17 '20 at 10:08

Adding to the already existing answer

Publishing a private add-on does not require going through the Google Review process, especially since it is for personal use only.

Therefore, the situations below do not require verification:

If you want to deploy the add-on solely for internal use which means that the add on will be used only by people in your Google Workspace or Cloud Identity organization.
If you want to use the add-on domain wide which means that the add on will be used only by Google Workspace enterprise users within the domain.

For the whole list of exceptions from the verification process, you can check this here.

Reference

OAuth API verification FAQs.

Publish as a private add-on to avoid granting permission on copies of gsheets

2 Answers2

Reference