Supermetrics Support Forum

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


Thanks

Remi


2 people have this problem
  • Bump. I have a sheet running 1000 queries and it randomly stops refreshing when I try to refresh all.

  • Would this be possible?


    1 person likes this
Login to post a comment