How to work in google script with google spreadsheets protected sheets?

Question

Google

Hello.
Is it possible to somehow edit from protected google spreadsheets from google script if the script is run from a user who does not have editing rights?
Actually the purpose - the control of filling of the table. Those. it is necessary that when the user fills the table, the data is copied to a second table protected from him, which he cannot edit directly.
I wrote the script itself, it works, but only if the user has rights to edit the second table.
Maybe you can somehow temporarily remove the lock with a script? Or some other ways?

Answer 1

You need two scripts:

1. Destination server (runs as the owner of the protected range)
   
2. Initiator program (runs on behalf of the user)
   

You will need to solve several problems:

• Determining the authenticity of the initiating program on the server
  
• Command execution control
  
• Coordinated development and support of the two programs