# How do I set a label's text to a row/column in a google sheet and get updated
**URL:** https://community.thunkable.com/t/how-do-i-set-a-labels-text-to-a-row-column-in-a-google-sheet-and-get-updated/3145436
**Category:** Questions about Thunkable X
**Created:** [August 17, 2024, 7:46pm UTC](https://community.thunkable.com/t/how-do-i-set-a-labels-text-to-a-row-column-in-a-google-sheet-and-get-updated/3145436 "2024-08-17T19:46:03Z")
**Posts on this page:** 14
**Page:** 1
### Author:  [@jake-cohen](https://community.thunkable.com/u/jake-cohen)
#### Post date: [August 17, 2024, 7:46pm UTC](https://community.thunkable.com/t/how-do-i-set-a-labels-text-to-a-row-column-in-a-google-sheet-and-get-updated/3145436/1 "2024-08-17T19:46:03Z")
When I set label text to get value from a google sheet, and even when I put this block in a timer and when screen opens thee label still doesn’t update if the google sheet updates
---
### Author:  [@brianl](https://community.thunkable.com/u/brianl)
#### Post date: [August 19, 2024, 6:16pm UTC](https://community.thunkable.com/t/how-do-i-set-a-labels-text-to-a-row-column-in-a-google-sheet-and-get-updated/3145436/2 "2024-08-19T18:16:30Z")
The data viewer will not update dynamically when the data changes. You will have to use the [refresh data block](https://docs.thunkable.com/app-design/ui-components/data-components/data-viewers/data-viewer-grid#block-in-data-viewer-grid-call-refresh-data) to have it show the new changes.
---
### Author:  [@jake-cohen](https://community.thunkable.com/u/jake-cohen)
#### Post date: [August 19, 2024, 6:36pm UTC](https://community.thunkable.com/t/how-do-i-set-a-labels-text-to-a-row-column-in-a-google-sheet-and-get-updated/3145436/3 "2024-08-19T18:36:35Z")
I am talking about using just a regular label not a data viewer
---
### Author:  [@brianl](https://community.thunkable.com/u/brianl)
#### Post date: [August 19, 2024, 6:56pm UTC](https://community.thunkable.com/t/how-do-i-set-a-labels-text-to-a-row-column-in-a-google-sheet-and-get-updated/3145436/4 "2024-08-19T18:56:07Z")
My apologies, I had misread your post. Could you share the blocks you have set up?
---
### Author:  [@jake-cohen](https://community.thunkable.com/u/jake-cohen)
#### Post date: [August 19, 2024, 8:10pm UTC](https://community.thunkable.com/t/how-do-i-set-a-labels-text-to-a-row-column-in-a-google-sheet-and-get-updated/3145436/5 "2024-08-19T20:10:03Z")
I am not currently home/ with a computer and won’t be for a while. Bassicly what I just did is when screen opens, I set a label to get value of a certain column and row from a google sheet. I also added a timer that fires every 30 min (but for testing purposes I set it to every minute) and when it fires it does the same thing with setting it to the value from the google sheet. I previously had looked up how to do this, because it doesn’t update after first being set and it said there is not fix, from what I was seeing.
---
### Author:  [@jake-cohen](https://community.thunkable.com/u/jake-cohen)
#### Post date: [August 19, 2024, 10:42pm UTC](https://community.thunkable.com/t/how-do-i-set-a-labels-text-to-a-row-column-in-a-google-sheet-and-get-updated/3145436/6 "2024-08-19T22:42:52Z")
I just found out that labels to update with the get value block from a google sheet but only if you close the app and re-open it, not while the app is open which is some cases can be problematic is there any way to get around this?
---
### Author:  [@brianl](https://community.thunkable.com/u/brianl)
#### Post date: [August 21, 2024, 12:41am UTC](https://community.thunkable.com/t/how-do-i-set-a-labels-text-to-a-row-column-in-a-google-sheet-and-get-updated/3145436/7 "2024-08-21T00:41:15Z")
So I checked with my team and it looks like currently with Google Sheets, the data is cached so any changes will not reflect on your app because it still pulls from the cached data. This is something that I made the team aware of and will potentially look into a better solution in the future; however, for now, I would recommend using a different data source if you need to grab data that is constantly changing.
---
### Author:  [@jake-cohen](https://community.thunkable.com/u/jake-cohen)
#### Post date: [August 21, 2024, 12:53am UTC](https://community.thunkable.com/t/how-do-i-set-a-labels-text-to-a-row-column-in-a-google-sheet-and-get-updated/3145436/8 "2024-08-21T00:53:06Z")
ok thanks but is this true? just want to make sure its not a bug or testing only thing:
I just found out that labels to update with the get value block from a google sheet but only if you close the app and re-open it, not while the app is open
---
### Author:  [@brianl](https://community.thunkable.com/u/brianl)
#### Post date: [August 21, 2024, 5:55pm UTC](https://community.thunkable.com/t/how-do-i-set-a-labels-text-to-a-row-column-in-a-google-sheet-and-get-updated/3145436/9 "2024-08-21T17:55:19Z")
Yes. I have confirm with our engineering team as well. As of right now, it will only read from the cached information.
---
### Author:  [@jake-cohen](https://community.thunkable.com/u/jake-cohen)
#### Post date: [August 23, 2024, 7:03pm UTC](https://community.thunkable.com/t/how-do-i-set-a-labels-text-to-a-row-column-in-a-google-sheet-and-get-updated/3145436/10 "2024-08-23T19:03:52Z")
Another question, does this also apply to images? Like I have a URL to an image stored in Cloudinary on my Google Sheet. So does the same thing apply that the image component/thunkable will only read the cached info and not if the link URL gets deleted/ changed?
---
### Author:  [@brianl](https://community.thunkable.com/u/brianl)
#### Post date: [August 23, 2024, 7:11pm UTC](https://community.thunkable.com/t/how-do-i-set-a-labels-text-to-a-row-column-in-a-google-sheet-and-get-updated/3145436/11 "2024-08-23T19:11:15Z")
If the URL exists on Google Sheets, then it will only read from the cached Google Sheet which would include the URL link. The alternative would be to use another data source or to use FIrebase if you want to fetch the live data everytime.
---
### Author:  [@jake-cohen](https://community.thunkable.com/u/jake-cohen)
#### Post date: [August 25, 2024, 5:38am UTC](https://community.thunkable.com/t/how-do-i-set-a-labels-text-to-a-row-column-in-a-google-sheet-and-get-updated/3145436/12 "2024-08-25T05:38:22Z")
Is airtable cached (like google sheets) or is it fine to use to live update labels and images?
---
### Author:  [@brianl](https://community.thunkable.com/u/brianl)
#### Post date: [August 26, 2024, 6:51pm UTC](https://community.thunkable.com/t/how-do-i-set-a-labels-text-to-a-row-column-in-a-google-sheet-and-get-updated/3145436/13 "2024-08-26T18:51:49Z")
Airtable is fine to use for live updates. It will require the use of the [refresh data viewer block](https://docs.thunkable.com/app-design/ui-components/data-components/data-viewers/data-viewer-list#block-in-data-viewer-list-call-refresh-data) to see any new changes.
---
### Author:  [@system](https://community.thunkable.com/u/system)
#### Post date: [November 24, 2024, 6:52pm UTC](https://community.thunkable.com/t/how-do-i-set-a-labels-text-to-a-row-column-in-a-google-sheet-and-get-updated/3145436/14 "2024-11-24T18:52:09Z")
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.