Hi,
I am experienced in creating google script trigger, timely trigger such as every minute, every 30 minutes, hourly or daily. Also experienced in creating onFormsubmit trigger, let discuss further which type of trigger you prefer? Maybe a onChange trigger is needed for your case. Thanks!