show a processing status in a cell when looping through rows in google sheets using google apps script.
When working with small batches of data it can be useful to show the user that the data is being processed. Here is an example script from Sourabh Choraria which use
SpreadsheetApp.flush() to force write updates to a Google Sheet. As this method relies on
.setValue() instead of
.setValues() it’s worth keeping in mind for bigger data sets that using HTMLService and a custom dialog or
.flush() Al from coda has provided this gist
To make this work, you need to add a Sparkline() function to your Google Sheet that references a hidden “For progress” column: pic.twitter.com/jk87wvuuyj
— Al (@bigal123) April 13, 2021