# Working with Google Sheet

**URL:** <https://community.thunkable.com/t/working-with-google-sheet/1067002>\
**Category:** Questions about Thunkable X\
**Created:** [January 25, 2021, 2:41am UTC](https://community.thunkable.com/t/working-with-google-sheet/1067002 "2021-01-25T02:41:35Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![darrickloh](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/darrickloh/32/94339_2.png) [@darrickloh](https://community.thunkable.com/u/darrickloh)\
**Post date:** [January 25, 2021, 2:41am UTC](https://community.thunkable.com/t/working-with-google-sheet/1067002/1 "2021-01-25T02:41:35Z")

</div>

Hi, I am new and noob to thunkable.

I am doing data processing (some calculation) in a Google sheet where I will “update” a value to it, and after processing by the sheet, I would like to “get” the value to be display in the app.

So far the very first instance of these operation works fine. But not after I try to “update” another value to the app. It will only work again only I restart the app again.

Any advise will be very much appreciated. TIA.

---

<div class="post-metadata">

**Author:** ![virajkhanna4ade](https://avatars.discourse-cdn.com/v4/letter/v/5e9695/32.png) [@virajkhanna4ade](https://community.thunkable.com/u/virajkhanna4ade)\
**Post date:** [January 25, 2021, 3:23am UTC](https://community.thunkable.com/t/working-with-google-sheet/1067002/2 "2021-01-25T03:23:33Z")

</div>

Hi @darrickloh, Welcome to the community.

> [@darrickloh](#):
>
> Any advise will be very much appreciated.

Maybe you can try Realtime DB by Google Firebase. It also works. You can store many values in it and it’s in Realtime. You can use the DataChanged and Add Listener Block to detect new values. I Hope I Helped You.

---

<div class="post-metadata">

**Author:** ![darrickloh](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/darrickloh/32/94339_2.png) [@darrickloh](https://community.thunkable.com/u/darrickloh)\
**Post date:** [January 25, 2021, 9:16am UTC](https://community.thunkable.com/t/working-with-google-sheet/1067002/3 "2021-01-25T09:16:56Z")

</div>

Thank you. I am looking for a solution just to read one cell or value from the sheet.

---

<div class="post-metadata">

**Author:** ![virajkhanna4ade](https://avatars.discourse-cdn.com/v4/letter/v/5e9695/32.png) [@virajkhanna4ade](https://community.thunkable.com/u/virajkhanna4ade)\
**Post date:** [January 25, 2021, 9:35am UTC](https://community.thunkable.com/t/working-with-google-sheet/1067002/4 "2021-01-25T09:35:00Z")

</div>

Oh Ok.

---

<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:** [January 25, 2021, 9:47am UTC](https://community.thunkable.com/t/working-with-google-sheet/1067002/5 "2021-01-25T09:47:50Z")

</div>

You will need this

 ![get_value](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/9/d/9dfe6979f134fa870e4dc2bab83ed137a3b7f336.png)

To read a single cell.

---

<div class="post-metadata">

**Author:** ![darrickloh](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/darrickloh/32/94339_2.png) [@darrickloh](https://community.thunkable.com/u/darrickloh)\
**Post date:** [January 26, 2021, 1:10am UTC](https://community.thunkable.com/t/working-with-google-sheet/1067002/6 "2021-01-26T01:10:19Z")

</div>

Thanks muneer. I did just that, but it works for the first time or every time the app startup but not after that when I updated to another value.

---

<div class="post-metadata">

**Author:** ![darrickloh](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/darrickloh/32/94339_2.png) [@darrickloh](https://community.thunkable.com/u/darrickloh)\
**Post date:** [January 26, 2021, 1:29am UTC](https://community.thunkable.com/t/working-with-google-sheet/1067002/7 "2021-01-26T01:29:07Z")

</div>

This is my test project here:  
[https://x.thunkable.com/projects/600f6d9160d50f0011502133/9f1c88b4-7c81-4490-90e1-b6367dd7704d/designer](https://x.thunkable.com/projects/600f6d9160d50f0011502133/9f1c88b4-7c81-4490-90e1-b6367dd7704d/designer)

 ![Screenshot 2021-01-26 092800](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/b/9/b98ce1305f6e920a99dafd1e9a3cad3d246d26ab.png)

Appreciate any advise. Thank you again.

---

<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:** [January 26, 2021, 10:31am UTC](https://community.thunkable.com/t/working-with-google-sheet/1067002/8 "2021-01-26T10:31:53Z")

</div>

I made some test and what you are saying is correct. The block does not retrieve the updates.

However, when I tested with this block

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/1/01683db7eba64b73499d4283043dc9181e1a6a37.png)

I was able to read the updates multiple times.

Maybe someone from Thunkable [@staff](https://community.thunkable.com/groups/staff) could give a better solution / explanation.

---

<div class="post-metadata">

**Author:** ![darrickloh](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/darrickloh/32/94339_2.png) [@darrickloh](https://community.thunkable.com/u/darrickloh)\
**Post date:** [January 27, 2021, 11:11am UTC](https://community.thunkable.com/t/working-with-google-sheet/1067002/9 "2021-01-27T11:11:21Z")

</div>

Dear Mr Muneer,

That block works! Thank you so much!

---

<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:30pm UTC](https://community.thunkable.com/t/working-with-google-sheet/1067002/10 "2024-11-08T13:30:30Z")

</div>


