google apps script – Get the sheet not updated at once

I create a sheet that imports a large amount of data from one site. I want to do it slowly so as not to clutter the site.

onOpen function () {
var ss = SpreadsheetApp.getActiveSpreadsheet ();
var sheet = ss.getSheets ()[3];

for (var i = 1; i <39; i ++) {
var cell = sheet.getRange (1, (i * 2) -1);
cell.setValue (= QUERY (IMPORTHTML ("WEBSITE", "table", table number)), "QUERY STUFF", 0));
Utilities.sleep (10000)
}
}

All this is all dump once the loop is finished running.
So, all IMPORTHTMLs disappear at the same time. The opposite of what I would like.

I would like the sheet to update the value of the cell in loop and wait for the data to be imported (about 10 seconds) before moving on to the next iteration. Is it possible?