Start a new topic

Refresh specific queries ... through google app script

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..."



2 people have this problem
1 Comment

Bump. I have a sheet running 1000 queries and it randomly stops refreshing when I try to refresh all.

Login or Signup to post a comment