# How to get a value from google sheets? **URL:** \ **Category:** Questions about Thunkable X\ **Tags:** beginner\ **Created:** [June 4, 2021, 5:14am UTC](https://community.thunkable.com/t/how-to-get-a-value-from-google-sheets/1324527 "2021-06-04T05:14:46Z")\ **Posts on this page:** 18\ **Page:** 1
**Author:** ![ninja\_x](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/ninja_x/32/125825_2.png) [@ninja\_x](https://community.thunkable.com/u/ninja_x)\ **Post date:** [June 4, 2021, 5:14am UTC](https://community.thunkable.com/t/how-to-get-a-value-from-google-sheets/1324527/1 "2021-06-04T05:14:46Z")
Hi, How can I get all the values form google sheets? Like if the text = any username which is in the google sheet plz Tell me I need this so badly ---
**Author:** ![sketch](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/sketch/32/109058_2.png) [@sketch](https://community.thunkable.com/u/sketch)\ **Post date:** [June 4, 2021, 5:33am UTC](https://community.thunkable.com/t/how-to-get-a-value-from-google-sheets/1324527/2 "2021-06-04T05:33:04Z")
Go to data sources. And Use a get list of values block. And check if the list contains the text. ---
**Author:** ![ninja\_x](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/ninja_x/32/125825_2.png) [@ninja\_x](https://community.thunkable.com/u/ninja_x)\ **Post date:** [June 4, 2021, 6:25am UTC](https://community.thunkable.com/t/how-to-get-a-value-from-google-sheets/1324527/3 "2021-06-04T06:25:44Z")
It’s not working Did you meant like this? ![t](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/8/a/8ab090937d115053fc139884ede44727ed2fec2b.png) 🤔 ---
**Author:** ![sketch](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/sketch/32/109058_2.png) [@sketch](https://community.thunkable.com/u/sketch)\ **Post date:** [June 4, 2021, 6:30am UTC](https://community.thunkable.com/t/how-to-get-a-value-from-google-sheets/1324527/4 "2021-06-04T06:30:30Z")
No i mean check if the lists contains the text item. You can find that block in the list drawer. ---
**Author:** ![ninja\_x](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/ninja_x/32/125825_2.png) [@ninja\_x](https://community.thunkable.com/u/ninja_x)\ **Post date:** [June 4, 2021, 6:31am UTC](https://community.thunkable.com/t/how-to-get-a-value-from-google-sheets/1324527/5 "2021-06-04T06:31:04Z")
What is list drawer? ---
**Author:** ![ninja\_x](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/ninja_x/32/125825_2.png) [@ninja\_x](https://community.thunkable.com/u/ninja_x)\ **Post date:** [June 4, 2021, 6:31am UTC](https://community.thunkable.com/t/how-to-get-a-value-from-google-sheets/1324527/6 "2021-06-04T06:31:45Z")
How can I find it? ---
**Author:** ![ninja\_x](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/ninja_x/32/125825_2.png) [@ninja\_x](https://community.thunkable.com/u/ninja_x)\ **Post date:** [June 4, 2021, 6:32am UTC](https://community.thunkable.com/t/how-to-get-a-value-from-google-sheets/1324527/7 "2021-06-04T06:32:56Z")
I am not on the new mod. ---
**Author:** ![sketch](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/sketch/32/109058_2.png) [@sketch](https://community.thunkable.com/u/sketch)\ **Post date:** [June 4, 2021, 6:33am UTC](https://community.thunkable.com/t/how-to-get-a-value-from-google-sheets/1324527/8 "2021-06-04T06:33:54Z")
Its thiss one: ![Screenshot_20210604-083330_Chrome](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/a/c/ac0007c84683fdd8ead7d58e556407e4f9574bfc.jpeg) ---
**Author:** ![ninja\_x](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/ninja_x/32/125825_2.png) [@ninja\_x](https://community.thunkable.com/u/ninja_x)\ **Post date:** [June 4, 2021, 6:34am UTC](https://community.thunkable.com/t/how-to-get-a-value-from-google-sheets/1324527/9 "2021-06-04T06:34:52Z")
oh thanks but which block? ---
**Author:** ![ninja\_x](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/ninja_x/32/125825_2.png) [@ninja\_x](https://community.thunkable.com/u/ninja_x)\ **Post date:** [June 4, 2021, 7:10am UTC](https://community.thunkable.com/t/how-to-get-a-value-from-google-sheets/1324527/10 "2021-06-04T07:10:41Z")
@thunkabot display help ---
**Author:** ![sketch](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/sketch/32/109058_2.png) [@sketch](https://community.thunkable.com/u/sketch)\ **Post date:** [June 4, 2021, 7:15am UTC](https://community.thunkable.com/t/how-to-get-a-value-from-google-sheets/1324527/12 "2021-06-04T07:15:43Z")
Use the does list contain block ---
**Author:** ![ninja\_x](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/ninja_x/32/125825_2.png) [@ninja\_x](https://community.thunkable.com/u/ninja_x)\ **Post date:** [June 4, 2021, 7:18am UTC](https://community.thunkable.com/t/how-to-get-a-value-from-google-sheets/1324527/13 "2021-06-04T07:18:59Z")
like this? ![r](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/a/7/a7d6214fb2fff578008b79c3d57e4462c26691a3.png) loop ![5820](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/5/a/5aaf05960380279c8dd4964c43dc5612b098d827.png) ---
**Author:** ![sketch](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/sketch/32/109058_2.png) [@sketch](https://community.thunkable.com/u/sketch)\ **Post date:** [June 4, 2021, 8:08am UTC](https://community.thunkable.com/t/how-to-get-a-value-from-google-sheets/1324527/14 "2021-06-04T08:08:11Z")
Like this: ![Screenshot_20210604-100652_Chrome](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/3/c/3c1c7c6150b0562d6477d127836d2bd29352704f.jpeg) Replace the navigate to screen blocks with custom blocks. ---
**Author:** ![ninja\_x](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/ninja_x/32/125825_2.png) [@ninja\_x](https://community.thunkable.com/u/ninja_x)\ **Post date:** [June 4, 2021, 10:09am UTC](https://community.thunkable.com/t/how-to-get-a-value-from-google-sheets/1324527/15 "2021-06-04T10:09:20Z")
ok but now I want if the text is not = table plz help ---
**Author:** ![sketch](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/sketch/32/109058_2.png) [@sketch](https://community.thunkable.com/u/sketch)\ **Post date:** [June 4, 2021, 10:45am UTC](https://community.thunkable.com/t/how-to-get-a-value-from-google-sheets/1324527/16 "2021-06-04T10:45:31Z")
Add a else to the if statement. And put your code there. ---
**Author:** ![ninja\_x](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/ninja_x/32/125825_2.png) [@ninja\_x](https://community.thunkable.com/u/ninja_x)\ **Post date:** [June 4, 2021, 10:50am UTC](https://community.thunkable.com/t/how-to-get-a-value-from-google-sheets/1324527/17 "2021-06-04T10:50:57Z")
hope this one works. thanks for your time ---
**Author:** ![human](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/human/32/101416_2.png) [@human](https://community.thunkable.com/u/human)\ **Post date:** [June 4, 2021, 2:47pm UTC](https://community.thunkable.com/t/how-to-get-a-value-from-google-sheets/1324527/18 "2021-06-04T14:47:56Z")
Edit each of your posts instead of posting several questions in a row. This is supposed to be a formal (for the most part) discussion. Discourse lets you make a maximum of 3 posts in a row, so that tells you it is not a fan of continuous spamming either. As codeswept told you in another topic of yours, this is a forum, not a chat room. ---
**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:22pm UTC](https://community.thunkable.com/t/how-to-get-a-value-from-google-sheets/1324527/19 "2024-11-08T13:22:04Z")