Automatically updating google spreadsheet with data from bigquery


Staff member
Followed the instructions <a href="" rel="nofollow">here</a> and integrated a google spreadsheet with bigQuery. My query pulls data from the past hour, so it is important to keep the spreadsheet updated.

Is there a way for the sheet to automatically run the script and update the data on refreshing the page? Right now, I need to perform a few clicks to do it.