# How to filter information using Google Sheets

**URL:** https://community.thunkable.com/t/how-to-filter-information-using-google-sheets/2953922
**Category:** Questions about Thunkable X
**Created:** [April 18, 2024, 1:22pm UTC](https://community.thunkable.com/t/how-to-filter-information-using-google-sheets/2953922 "2024-04-18T13:22:09Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![luiz.primaz2ddpyu](https://avatars.discourse-cdn.com/v4/letter/l/e9a140/32.png) [@luiz.primaz2ddpyu](https://community.thunkable.com/u/luiz.primaz2ddpyu)
#### Post date: [April 18, 2024, 1:22pm UTC](https://community.thunkable.com/t/how-to-filter-information-using-google-sheets/2953922/1 "2024-04-18T13:22:10Z")

</div>

Good morning, I want information from this Google Sheets spreadsheet to appear in a Data Viewer List in Thunkable, but I don’t want it to show all the lists, is there a way to filter? Example, I wanted it to show only the lines that have the Profissional “Ariane”?

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

Example:

![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/b/4/b45d374e2ba03b9e4874c0ef0bc8cdd42a56d79a.png)

---

<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: [April 18, 2024, 3:06pm UTC](https://community.thunkable.com/t/how-to-filter-information-using-google-sheets/2953922/2 "2024-04-18T15:06:22Z")

</div>

Hello @luiz.primaz2ddpyu  
The blocks you will need are mentioned in the following post and are the same for the Google Sheet data source:

> [@Help with displaying airtable data that contains the words filtered with the search engine](https://community.thunkable.com/t/help-with-displaying-airtable-data-that-contains-the-words-filtered-with-the-search-engine/2786316/2):
>
> Hello @jccarbonerog and welcome to the community tada To build this you will need to connect a Data Viewer List with a local table. Each time that you will open the screen, the old data will be deleted from the local table and the new data will be saved to the local table if the condition is true. You can see the example below.

---

<div class="post-metadata">

### Author: ![luiz.primaz2ddpyu](https://avatars.discourse-cdn.com/v4/letter/l/e9a140/32.png) [@luiz.primaz2ddpyu](https://community.thunkable.com/u/luiz.primaz2ddpyu)
#### Post date: [April 19, 2024, 11:24am UTC](https://community.thunkable.com/t/how-to-filter-information-using-google-sheets/2953922/3 "2024-04-19T11:24:15Z")

</div>

This way he only listed one, I want him to list all that have the Profissional information as “Ariane”

![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/2/f/2f6705ac8116f223e2bb996a39c24fbddb42d6f6.png)

---

<div class="post-metadata">

### Author: ![luiz.primaz2ddpyu](https://avatars.discourse-cdn.com/v4/letter/l/e9a140/32.png) [@luiz.primaz2ddpyu](https://community.thunkable.com/u/luiz.primaz2ddpyu)
#### Post date: [April 19, 2024, 11:26am UTC](https://community.thunkable.com/t/how-to-filter-information-using-google-sheets/2953922/4 "2024-04-19T11:26:53Z")

</div>

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

---

<div class="post-metadata">

### Author: ![luiz.primaz2ddpyu](https://avatars.discourse-cdn.com/v4/letter/l/e9a140/32.png) [@luiz.primaz2ddpyu](https://community.thunkable.com/u/luiz.primaz2ddpyu)
#### Post date: [April 19, 2024, 2:04pm UTC](https://community.thunkable.com/t/how-to-filter-information-using-google-sheets/2953922/5 "2024-04-19T14:04:06Z")

</div>

I think it would be better with user code? (Código)

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/7/7/77dfecc2d7b4af2b43b1b9af338c5ec0b7026bef.png)

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/f/0f59f292712368bce16ff80133ae10de8a6f27e8.png) [@system](https://community.thunkable.com/u/system)
#### Post date: [July 18, 2024, 2:05pm UTC](https://community.thunkable.com/t/how-to-filter-information-using-google-sheets/2953922/6 "2024-07-18T14:05:01Z")

</div>

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.