6 ms·
Looks great! Is there a rate limit? Will changed to the sheet instantly go live? Or is that a manual process to clear cache?
by throwaway295729 3y ago
Looks great!
Is there a rate limit?
Will changed to the sheet instantly go live? Or is that a manual process to clear cache?
- tarasyarema 3y agoI 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.