There’s a apps script function I wrote, loadAccount() that moves data within multiple sheets, however Apps Script is bundling the operations in a way not optimal for user experience. Essentially what happens is that apps script is bundling everything up until the first categorySheet.getRange() call at the end. I noticed this in testing by undoing the script operation and observing that more than one undo is required to revert the changes. I want only one undo to be required to undo all changes in this function. Calling SpreadsheetApp.flush() at the end does not resolve this issue. I have another function, importData() that does not have this problem. I plan on adding more sheet operations for loadAccount() so I’d like to get to the bottom of this issue.

I’m using ImportJSON script that is well know to run an API and retrieve data.
This works fine, I’ve used it many times before.
However this particular API I’m running returns data that has different size rows, so I get the error:

I’m using ImportJSON script that is well know to run an API and retrieve data.
This works fine, I’ve used it many times before.
However this particular API I’m running returns data that has different size rows, so I get the error:

I’m using ImportJSON script that is well know to run an API and retrieve data.
This works fine, I’ve used it many times before.
However this particular API I’m running returns data that has different size rows, so I get the error:

I’m using ImportJSON script that is well know to run an API and retrieve data.
This works fine, I’ve used it many times before.
However this particular API I’m running returns data that has different size rows, so I get the error:

I have an array with three values, but when it sets values in the spreadsheet it prints the first value three times instead of printing all three of them.