Hello i run a heavy Supermetrics Spreadsheet on Google Sheets and sometimes the queries stop at Refreshing...
When this happens, i need to manually go inside each of the queries and refresh them one by one.
Is there a way that i can refresh a specific query through Google App script ? this way i could create a Google App Script Trigger and run the refresh procedure on all queries that have been stucked at "Refreshing..."
Bump. I have a sheet running 1000 queries and it randomly stops refreshing when I try to refresh all.
Would this be possible?