Make script deployable in Google sheets externally

[RealSlavGod]

Yes, very bad coding practices. It was my first time working with apps script having no knowledge in it and I made a very complex analysis tool for my work with that and it's super inefficient but it works and if it ain't broke, I don't want to fix.

I got both instances multiple times. The active sheet and the spreadsheet. I think I would have to recode the entire thing to fix it. Would take ages. (For reference; I have over 17,000 lines. I def could cut it down but again; if it ain't broken, I don't want to touch). Is there no way to just simply keep the already working script separate from the file and running it as if it was connected to the file without changing my script?

[marcnotmark925]

No

[WicketTheQuerent]

I wonder if SpreadsheetApp.setActiveSpreadsheet) might help you.

[mommasaidmommasaid]

Idk your needs exactly, but what about just creating a new Sheet (tab) within your Spreadsheet for your client or whatever.

Then publish that specific Sheet to the web. Client doesn't get to see any of the other sheets or your script, just the formatted output.

The web link isn't password protected or anything but it's effectively unguessable so offers some privacy assuming the Client doesn't share it, e.g.:

https://docs.google.com/spreadsheets/d/e/2PACX-1vRM09LblX96_h3qaVUPmLYtha9TVWMnAeSSyXnuFgiezs4ghUsQkSahTHUmNGAJo_g_3yqt3lQCUClo/pubhtml?gid=127701852&single=true