Extensions
> Apps Script
.ImportJSON.gs
.AutoRefresh
.AutoRefresh.gs
. Paste in this following code.The idea of this script is to generate a random number to the AutoRefresh sheet, which is then appended to the end of the ImportJSON request.Google Sheets only performs a new request if it detects that a formula has changed.
Triggers
> Add Trigger
at the left panel. AutoRefresh
, event source as Time Driven
, time based trigger to Minutes Timer
and minute interval to Every Minute
. /result
or /result/SafeGasPrice
noInherit
, noTruncate
, rawHeaders
, noHeaders
or allHeaders