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.
Add Triggerat the left panel.
AutoRefresh, event source as
Time Driven, time based trigger to
Minutes Timerand minute interval to