# How to re-fetch updated google sheet data while still being in the app?

**URL:** <https://community.thunkable.com/t/how-to-re-fetch-updated-google-sheet-data-while-still-being-in-the-app/1388925>\
**Category:** Questions about Thunkable X\
**Created:** [July 10, 2021, 11:27am UTC](https://community.thunkable.com/t/how-to-re-fetch-updated-google-sheet-data-while-still-being-in-the-app/1388925 "2021-07-10T11:27:37Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![satishv.spatikat6n1a](https://avatars.discourse-cdn.com/v4/letter/s/e95f7d/32.png) [@satishv.spatikat6n1a](https://community.thunkable.com/u/satishv.spatikat6n1a)\
**Post date:** [July 10, 2021, 11:27am UTC](https://community.thunkable.com/t/how-to-re-fetch-updated-google-sheet-data-while-still-being-in-the-app/1388925/1 "2021-07-10T11:27:37Z")

</div>

Hi Thunkers,

I am using the "list of values in in " block to retrieve the data into a list and then use it (say the # of entries(rows) is 10) when the screen starts/opens and I get it perfectly working.

But when a new row is created while using the app and when still being in the app when I query again , I still see the same 10 entries and I am not able to retrieve the 11th entry which was made. If I exit the app completely and then restart, I get the 11th entry also. Is there any way while still being in the app, I can get the updated google sheet content ?

Thank you so much !!!

---

<div class="post-metadata">

**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\
**Post date:** [July 10, 2021, 12:19pm UTC](https://community.thunkable.com/t/how-to-re-fetch-updated-google-sheet-data-while-still-being-in-the-app/1388925/2 "2021-07-10T12:19:00Z")

</div>

It is better that @jane to look into this issue and comment on it as there was a similar issue of the app using cached values but it is supposed to be fixed.

---

<div class="post-metadata">

**Author:** ![satishv.spatikat6n1a](https://avatars.discourse-cdn.com/v4/letter/s/e95f7d/32.png) [@satishv.spatikat6n1a](https://community.thunkable.com/u/satishv.spatikat6n1a)\
**Post date:** [July 10, 2021, 12:52pm UTC](https://community.thunkable.com/t/how-to-re-fetch-updated-google-sheet-data-while-still-being-in-the-app/1388925/3 "2021-07-10T12:52:02Z")

</div>

Thanks Muneer ! I came up with the below work around .

Just at the start of the app alone I initialize the counter to “number of rows” in the google sheet. Then I keep on incrementing this counter each time I create a new row and then query using the count block till the latest counter value, but this is not a very good way to achieve this.

I will anyway await Jane’s response to this issue.

---

<div class="post-metadata">

**Author:** ![satishv.spatikat6n1a](https://avatars.discourse-cdn.com/v4/letter/s/e95f7d/32.png) [@satishv.spatikat6n1a](https://community.thunkable.com/u/satishv.spatikat6n1a)\
**Post date:** [July 24, 2021, 6:43am UTC](https://community.thunkable.com/t/how-to-re-fetch-updated-google-sheet-data-while-still-being-in-the-app/1388925/4 "2021-07-24T06:43:36Z")

</div>

Actually if I use Update function to update a cell in google sheet, it is still using cache value and not taking up the updated value. This is becoming a real issue. How to resolve this ?

---

<div class="post-metadata">

**Author:** ![ioannis](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/ioannis/32/146956_2.png) [@ioannis](https://community.thunkable.com/u/ioannis)\
**Post date:** [November 8, 2024, 1:19pm UTC](https://community.thunkable.com/t/how-to-re-fetch-updated-google-sheet-data-while-still-being-in-the-app/1388925/5 "2024-11-08T13:19:50Z")

</div>