# Functions with google shhets

**URL:** <https://community.thunkable.com/t/functions-with-google-shhets/583174>\
**Category:** Questions about Thunkable X\
**Tags:** beginner\
**Created:** [May 21, 2020, 9:12pm UTC](https://community.thunkable.com/t/functions-with-google-shhets/583174 "2020-05-21T21:12:02Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![mauron.jackpm7i](https://avatars.discourse-cdn.com/v4/letter/m/bbce88/32.png) [@mauron.jackpm7i](https://community.thunkable.com/u/mauron.jackpm7i)\
**Post date:** [May 21, 2020, 9:12pm UTC](https://community.thunkable.com/t/functions-with-google-shhets/583174/1 "2020-05-21T21:12:03Z")

</div>

Hi,  
I try to work with datas that are on a Google Sheets.  
It’s really simple to link it, thanks !

the problem is that i only get 4 possible actions with this sheet (get value, update value, create row, delete row).  
I can’t find how to get the "number of rows, or to get a “list of value” that we find by creating a local database…

Can you help me ?

 ![20200521 QuestionThunkable](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/3/d/3d2a0462cd22ebf95e4f5bd6e2ec48933d810a9f.jpeg)

---

<div class="post-metadata">

**Author:** ![paulmw](https://avatars.discourse-cdn.com/v4/letter/p/22d042/32.png) [@paulmw](https://community.thunkable.com/u/paulmw)\
**Post date:** [May 21, 2020, 9:29pm UTC](https://community.thunkable.com/t/functions-with-google-shhets/583174/2 "2020-05-21T21:29:50Z")

</div>

The “number of rows” and “list of values” blocks aren’t available for Google Sheets yet.

---

<div class="post-metadata">

**Author:** ![mauron.jackpm7i](https://avatars.discourse-cdn.com/v4/letter/m/bbce88/32.png) [@mauron.jackpm7i](https://community.thunkable.com/u/mauron.jackpm7i)\
**Post date:** [May 21, 2020, 9:31pm UTC](https://community.thunkable.com/t/functions-with-google-shhets/583174/3 "2020-05-21T21:31:38Z")

</div>

Thanks for your rapid answer !  
But then, how can i go through the datas ?

---

<div class="post-metadata">

**Author:** ![paulmw](https://avatars.discourse-cdn.com/v4/letter/p/22d042/32.png) [@paulmw](https://community.thunkable.com/u/paulmw)\
**Post date:** [May 21, 2020, 9:52pm UTC](https://community.thunkable.com/t/functions-with-google-shhets/583174/4 "2020-05-21T21:52:26Z")

</div>

Right now, you can use Google Sheets with the data viewer components. We’ll be adding the ability to use Google Sheets without the data viewer in the future.

[https://docs.thunkable.com/data-viewer-list](https://docs.thunkable.com/data-viewer-list)  
[https://docs.thunkable.com/data-viewer-grid](https://docs.thunkable.com/data-viewer-grid)

---

<div class="post-metadata">

**Author:** ![mauron.jackpm7i](https://avatars.discourse-cdn.com/v4/letter/m/bbce88/32.png) [@mauron.jackpm7i](https://community.thunkable.com/u/mauron.jackpm7i)\
**Post date:** [May 21, 2020, 9:58pm UTC](https://community.thunkable.com/t/functions-with-google-shhets/583174/5 "2020-05-21T21:58:25Z")

</div>

OK, thanks for the great job you do !

---

<div class="post-metadata">

**Author:** ![jared](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/jared/32/138473_2.png) [@jared](https://community.thunkable.com/u/jared)\
**Post date:** [May 21, 2020, 10:07pm UTC](https://community.thunkable.com/t/functions-with-google-shhets/583174/6 "2020-05-21T22:07:31Z")

</div>

YESSSS!! GSheetts is so powerful (and free!) Thanks for all the work you guys do @paulmw

---

<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, 11:29am UTC](https://community.thunkable.com/t/functions-with-google-shhets/583174/7 "2024-11-08T11:29:07Z")

</div>