Google Apps Script run limits using BOT

[Massimo_Pioli]

Hi,

Hello, I have created a simple Google Apps Script that calculates the financial competence of an amount based on certain parameters. The script is executed via a BOT on records that have been “marked” for processing by another BOT. The script’s execution time is just a few seconds (about 5).

After fewer than 30 executions, AppSheet returns this error: Stop executing after step Salva nuovoFlussoDiCompetenzaAtteso e Timestamp (the last Step of the BOT), because the request took too long to process.

I don’t believe the issue lies with the operations performed by the Google Apps Script, which, as I mentioned, is very simple. Does anyone know what the limits are for automatic execution of Google Apps Script via AppSheet?

[MTBE]

Can you run the AppScript by itself, not from a BOT?  If you get the same error (Too long to process), it may be an error in the AppScript, not the BOTs.

I ran into that issue and found a recent update to the AppScript made the code run in circles...a quick fix to the AppScript and everything was fine.

[Massimo_Pioli]

Hello,

I solved the problem by following a different approach.

I published my Google Apps Script as a Webapp and I call it using a Webhook.

This way, I can achieve exceptional performance thanks to bulk writing to the Google Sheet.

My main problem was related to the slowness with which AppSheet writes to Google Sheets cells.

The Webhook, on the other hand, updates hundreds of cells in just a few seconds.

The only challenge I faced was passing parameters from AppSheet to the Webhook, particularly when dealing with arrays…

I managed to find a “trick” to make it work, but my intention is to study this area more thoroughly to avoid having to build arrays using CONCATENATE() in AppSheet.

[Massimo_Pioli]

Ciao,

I can run the AppScript by itself with no problems at all. I use the script as custom function on hundreds of rows with zero problems.