Hi closinggoals, welcome to Thunkable! 
Be sure to check out How to ask Great Questions v2.0, the Community Guidelines, and our Getting Started Guide to make the best of your Thunkable Community experience!
Google Sheets data will not reflect in real time. This means that when you update the Google Sheets through blocks and you try to get the data, it won’t be the value you just pushed up. All the data that will show will be the data from the Google Sheet on the first load of the app.
If you want real-time data, then I would suggest either:
- using a different data source
- have a local data source and fill it with the data from the Google sheet. When you update the data in the local data table, also update the Google one in parallel. This isn’t the most optimal, but that’s the core of the idea