Google Sheets data source doesn't update every time

[jared]

@matt_conroy

The original intention for these blocks was to only retrieve the value of the data when the app opens. They are not intended to refresh the database each time the block is called. The reason they display the cached data is that removing it would likely cause creators to hit their rate limits on cloud services. That is something we do not want.

@tatiang i hate the idea of google sheets or airtable as the database for any real production app. The data blocks are not useable imo because they only interact with those 2 data stores. I’d use Firebase, xano, or supabase. Not much else…. Maybe aws but it’s a pain in the ass. Maybe google cloud sql with Firebase functions and auth.