I am using a shared Google account and the rest of the people with access to the account have even less programming knowledge than me. I have a custom function that greatly helps us to reduce the time we spend on a repetitive task but we need to do that task on many sheets and more sheets are continuously being added to the Drive.
They are not too comfortable with bringing up the Apps Script editor each time the code needs to be run so I have been trying to add a custom menu to the GSheets UI so the function can be run just by clicking on one button.
Is there a way for me to get this menu to appear on every single GSheet in the Drive?
I have searched high and low for the answer to this question and have been asked to use libraries and to publish the script as an add-on. I read that libraries might slow down the script execution and the editor still needs to be brought up so I tried the add-on method instead.
After spending hours navigating through the confusing maze that is the Google Cloud Platform and Google Marketplace SDK, I found out that to pass OAuth verification, I need to have my own domain and we just don't have the budget for domain hosting.
Any help or solutions offered would be greatly appreciated. Thanks.
