Thanks.
I was able to make it work by using 30 seconds timeout. Guess i’ll have to use a spinner to entertain the users.
BTW, I checked the google sheets API V4 API explorer sample that seems to show very quick loads even from complicated sheets.
https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets.values/batchGet
Not sure if it helps you, but if it does, great.
Thanks again.
