Yes, don’t use GAS if you have the possibility to avoid it.
Otherwise, do the heavy lifting somewhere else and use GAS as a very basic wrapper for your sheet.
One pattern that worked well for us in the past is to use Firebase functions (or Google Cloud Run) and leave the scripts to act as a dumb API to interact with the sheet.
Otherwise, do the heavy lifting somewhere else and use GAS as a very basic wrapper for your sheet.
One pattern that worked well for us in the past is to use Firebase functions (or Google Cloud Run) and leave the scripts to act as a dumb API to interact with the sheet.