# Google Sheet Bug - Cannot Get a Value Twice
**URL:** https://community.thunkable.com/t/google-sheet-bug-cannot-get-a-value-twice/2940153
**Category:** Issues / Bugs
**Created:** [April 10, 2024, 11:40pm UTC](https://community.thunkable.com/t/google-sheet-bug-cannot-get-a-value-twice/2940153 "2024-04-10T23:40:34Z")
**Posts on this page:** 8
**Page:** 1
### Author:  [@tthompson41231](https://community.thunkable.com/u/tthompson41231)
#### Post date: [April 10, 2024, 11:40pm UTC](https://community.thunkable.com/t/google-sheet-bug-cannot-get-a-value-twice/2940153/1 "2024-04-10T23:40:34Z")
In the video below you can see that I can get the value of the cell under Class Code. I can also set the value with no problem. The problem occurs when trying to get the value again. This can only be fixed by exiting the web preview or the Live App.
[https://res.cloudinary.com/dwdvpzphr/video/upload/v1712792046/Thunkable\_-\_Personal\_-\_Microsoft\_Edge\_2024-04-10\_19-32-03\_zsdkko.mp4](https://res.cloudinary.com/dwdvpzphr/video/upload/v1712792046/Thunkable_-_Personal_-_Microsoft_Edge_2024-04-10_19-32-03_zsdkko.mp4)
---
### Author:  [@wulfy\_starr](https://community.thunkable.com/u/wulfy_starr)
#### Post date: [April 11, 2024, 2:04pm UTC](https://community.thunkable.com/t/google-sheet-bug-cannot-get-a-value-twice/2940153/2 "2024-04-11T14:04:10Z")
i’m also having the same issue
---
### Author:  [@matt\_conroy](https://community.thunkable.com/u/matt_conroy)
#### Post date: [April 11, 2024, 2:31pm UTC](https://community.thunkable.com/t/google-sheet-bug-cannot-get-a-value-twice/2940153/3 "2024-04-11T14:31:25Z")
Are you using the get row object block to grab this data? There is an intended behavior to help limit API calls where grabbing data from a Google Sheets source like this will only grab the data when the app is first opened.
> [@"get row object" update only once for each row](https://community.thunkable.com/t/get-row-object-update-only-once-for-each-row/2770641/2):
>
> Hi @tokarqx2, thanks for reaching out about this. Unfortunately, this block is working as intended. To help limit API calls, we chose for the get row object block to only the first time because we don’t want to refresh the database every time a user performs this action. We do have this set as a feature request so that our product team can work to find a better solution for being able to update values like this.
---
### Author:  [@tthompson41231](https://community.thunkable.com/u/tthompson41231)
#### Post date: [April 11, 2024, 3:37pm UTC](https://community.thunkable.com/t/google-sheet-bug-cannot-get-a-value-twice/2940153/4 "2024-04-11T15:37:34Z")
I’m using the get value block.
---
### Author:  [@ioannis](https://community.thunkable.com/u/ioannis)
#### Post date: [April 11, 2024, 3:55pm UTC](https://community.thunkable.com/t/google-sheet-bug-cannot-get-a-value-twice/2940153/5 "2024-04-11T15:55:58Z")
Hello @tthompson41231 and @wulfy_starr
Thank you for sharing more information. Unfortunately, with the get value block, this is by design (i.e., we don’t want to refresh the database everytime you use the “Get value” block) since all the Data Sources (Google Sheets, Airtable, and Webflow) have limits for the number of times the API can be called.
The work-around here is to use a [Custom Data Viewer](https://docs.thunkable.com/app-design/ui-components/data-components/data-viewers/custom-data-viewer). When you use the Custom Data Viewer, you can then refresh the data using the `Refresh Data` block.
---
### Author:  [@tthompson41231](https://community.thunkable.com/u/tthompson41231)
#### Post date: [April 11, 2024, 5:27pm UTC](https://community.thunkable.com/t/google-sheet-bug-cannot-get-a-value-twice/2940153/6 "2024-04-11T17:27:19Z")
I guess I’ll have to find a workaround, but I have another question.
1: How is getting a single value from Google sheets and refreshing the whole sheet different? Aren’t they both calling the Google API?
2: What other database blocks follow this rule? List of values blocks and so on
---
### Author:  [@matt\_conroy](https://community.thunkable.com/u/matt_conroy)
#### Post date: [April 11, 2024, 6:43pm UTC](https://community.thunkable.com/t/google-sheet-bug-cannot-get-a-value-twice/2940153/7 "2024-04-11T18:43:28Z")
Hi @tthompson41231, appreciate these questions!
> [@tthompson41231](#):
>
> 1: How is getting a single value from Google sheets and refreshing the whole sheet different? Aren’t they both calling the Google API?
They’re different in that the `get value` block for updating a single value in a Google sheet and will only seek out the value for that particular cell. The Refresh Data block Ioannis mentions above literally refreshes the data source as added within Thunkable. They do both call the API in a similar way.
> [@tthompson41231](#):
>
> 2: What other database blocks follow this rule? List of values blocks and so on
The `get row object` and `get value` blocks will access the data based on when the app is opened and will not update as the data source itself is updated.
Let us know if you have any other questions!
---
### Author:  [@tthompson41231](https://community.thunkable.com/u/tthompson41231)
#### Post date: [April 11, 2024, 9:27pm UTC](https://community.thunkable.com/t/google-sheet-bug-cannot-get-a-value-twice/2940153/8 "2024-04-11T21:27:43Z")
Ok so only these two methods work for all those who want to know. I have been using Thunkable for 2 years now and I feel like this was never an issue but I can be wrong. It just doesn’t seem right.
