can I lock the G sheet and still be able to update it with appsheet?
Depends on your settings here:
“as app creator” is the default. In that case you can lock the sheet to everyone except for the account that the app is on.
Built in Seattle, WA | Copyright 2021