I have developed a google sheet apps script based data collection tool. To give a simplified context, I have a modal form for lets say user registration where users who are given edit access to the sheet can submit data through the form.