hi Matias,

Google Sheets only pulls data once per hour, not once per opening the Google Sheet. (If you open the Sheet after 1h it should reload the data)

Sync Tables -> Sheets with IMPORTDATA()

Besides, the API was built to be cached on a CDN, for a certain period of time, not really as a real time API.

(Right now it’s updating data every 5 minutes)

Some people might write some javascript code to force the CDN to fetch new data by appending querystring parameters to bust the cache.

See https://www.keycdn.com/support/what-is-cache-busting

You can try to find or write some solution by yourself.