I have an onOpen trigger that creates a menu in the spreadsheet that allows to load and access an HTML where user can input data which will be transferred to the spreadsheet (obviously i have some scripts running behind to do that).

The spreadsheet should be not editable for all users expect myself, to prevent them from accessing the data directly, they should only use the HTML form to enter the data.

Is there a way to allow all users that access the menu under my account? I also want that the scripts that transfer the data to the spreadsheet also runs only under my authorisation.

I read a couple solutions suggesting to use web app, but as i'm completely new to it, i couldn't figure out what exactly should be done.

Would really appreciate any solution that a 6 y.o kid will understand :)