Followed the instructions <a href="https://greenido.wordpress.com/2013/12/16/big-query-and-google-spreadsheet-intergration/" 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.
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.