I created a panel using doGet (HTML panel), linked to a spreadsheet. It adds data to the spreadsheet, and also extracts data from it when selecting from a drop-down list the name of people.
The drawback I have is that I must give people permission to edit the file (even if they do it from the HTML panel), and the idea is that those people can not see the file, except for a few data. The file can be shared to the organization without people noticing, but when they load data through the html panel, the file appears in the Drive in the "Recent" section. A form is not useful for me because it does not extract data from a spreadsheet dynamically.
I tried adding an interphase type file, but the change must be done manually to execute an activator, and for a time the minimum is 1 minute, and it is too much, since the load of the sheet must be automatic. calculation to the html panel.