Google Spreadsheets: Script to check for completion of ImportHTML -

Google Spreadsheets: Script to check for completion of ImportHTML -

i trying scrape info of website 1 time day automatically. in google spreadsheets, utilize =importhtml() function import info tables, , extract relevant info =query(). these functions take between 10 , 30 seconds finish calculation, every time open spreadsheet.

i utilize scheduled google apps script, re-create info different sheet (where stored, can run statistics) every day.

my problem having problem create script wait calculations finished, before info copied. result script copies error message "n/a".

i tried adding utilities.sleep(60000);, didn't work.

is possible create loop, checks calculation finish? tried without success:

function checkforerror() { var spreadsheet = spreadsheetapp.getactive(); var source = spreadsheet.getrange ("today!a1"); if (source = "n/a") { utilities.sleep(6000); checkforerror(); } else { movevaluesonly(); } }

locks this. lock services in docs. utilize public lock.

google-apps-script google-spreadsheet scrape