Hacker News new | ask | show | jobs
by throwaway295729 825 days 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?

1 comments

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.