How can I pause the execution of code in google script until the entire spreadsheet gets updated? -

How can I pause the execution of code in google script until the entire spreadsheet gets updated? -

i have spreadsheet lots of info , formulae. importing particular cell value spreadsheet google script. since cell not updated recent revision, script taking previous value. have given "sleep" in script temporarily stop script running wait spreadsheet updated. not sure if time gave in sleep sufficient in future info in spreadsheet increasing continuously.

i know if there way check status of spreadsheet (updated? updating? etc). run script when spreadsheet updated.

any help highly appreciated. lastly issue reckon finish task after beingness struggled in logic, code, triggers etc.

as anees mentioned in comments, flush() command looking for.

spreadsheetapp.flush();

https://developers.google.com/apps-script/reference/spreadsheet/spreadsheet-app#flush()

google-apps-script google-spreadsheet sleep