Hello dear nomicers,
First of all thanks a bunch for letting us to use your data over free plan.
I tried to use google sheets to retrieve data with importdata function and set timely-driven triggers using following api;
it seems to me that google sheets cache the retrieved results ?. for ex even at my local hour 10:39 pm, hour of the prices retrieved from api are from 10:09 pm.
when I use desktop ms office excel to retrieve data, it brings much fresher data.
do you know how to get fresher data on google sheets ?