I have the GCP sheet basic read quota limit, which is something I need to investigate if I can make it higher.
Also, in theory right now once you use a sheet once it will cache the version so that subsequent queries are faster, and in theory if you change the sheet it will check for that and use the live data if it got updated in the meantime.
Nevertheless, it might take a minute or so sometimes.
Also, in theory right now once you use a sheet once it will cache the version so that subsequent queries are faster, and in theory if you change the sheet it will check for that and use the live data if it got updated in the meantime.
Nevertheless, it might take a minute or so sometimes.