We have some Google Spreadsheets that use the
ImportHtml() to pull in some real messy tables. Then on on an alternate page we access the above data and pull it into a nice cleanly formatted table via spreadsheet
QUERY() and other functions so that subsequently a batch process from our database can import it.
Our problem is that we need the Google Spreadsheets to refresh and populate without manually opening them because if not, the database batch import fails.
We know that there are probably more robust ways to do this but it makes it easy enough for our less tech proficient people to do because it liberates them to build these type of data tools themselves.
From what we've read, running
SpreadsheetApp.flush() via a G-Apps Script might not force all the pages to recalculate.
Is there another way to easily do it?