Variables suddenly start getting posted on new row in Sheets

Seems like every now and again, the variables from a Storyline course switch to the following line in Google Sheets.
This breaks it for us.

Might be related to crossing a batch of 500 API calls though not sure. Calls are also very slow.

Any advice very welcome please,
thanks!

August 10, 2021, 8:15 am

Click for thumbs down.0Click for thumbs up.0#1

The speed problem is just how Google works, there's nothing you can do here. This is well-documented online, for example, you can see this thread: https://support.google.com/docs/thread/42793831/script-function-in-sheets-are-very-slow?hl=en where Google's product expert states that "Google Apps Script is pretty fast, but calls to the SpreadsheetApp API are very slow." If speed is a critical issue, I would recommend switching to Data Cloud.

I'll see if I can find anything out about the 500 record threshold.

 

August 10, 2021, 8:25 am

Click for thumbs down.0Click for thumbs up.0#2

Ok, thank you very much!

August 13, 2021, 1:38 am

Click for thumbs down.0Click for thumbs up.0#3