So a couple of interesting observations:
I have implemented one bot with three tasks, each task refers to the same script file but executes different functions. Two of the three tasks are executed, however the third is not. I removed the 2nd script task to see if the 3rd had a problem, but then the 1st and 2nd(3rd) executed just fine. Any ideas if there is a limitation on how many successive script tasks can be executed?
I actually do run a hybrid Pro/Enterprise account under Appsheet, however my script execution time limit appears to be 360 seconds, whereas my regular GAS execution time limit is 30 minutes under any scripts not linked via Appsheet, so I assume the time limit is observed under Appsheet vs GAS.
Yes, I am using the call a script task. I will see about running async which I have not tried so far. In the mean time I am attempting to convert the existing script to bulk add via API vs adding individual rows with child rows. I encountered a limitation with this using the Appsheet database and setting [Row ID] values when generating my own row key values.