# Search keywords from google sheet not working **URL:** \ **Category:** Questions about Thunkable X\ **Tags:** help\ **Created:** [September 24, 2025, 9:20pm UTC](https://community.thunkable.com/t/search-keywords-from-google-sheet-not-working/4107665 "2025-09-24T21:20:27Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![robert.lundelli4pcye](https://avatars.discourse-cdn.com/v4/letter/r/f08c70/32.png) [@robert.lundelli4pcye](https://community.thunkable.com/u/robert.lundelli4pcye)\ **Post date:** [September 24, 2025, 9:20pm UTC](https://community.thunkable.com/t/search-keywords-from-google-sheet-not-working/4107665/1 "2025-09-24T21:20:27Z")
Hi I am trying to run a test to see if my app is searching my google sheet. I would like it to display if it finds the keyword or not. Here is the block logic. Could anyone tell me what I am doing wrong here? ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/6/f/6fbe7041c286f88bf3973eb3e8dc9b6840a6a5b8.png) ---
**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:** [September 25, 2025, 12:45pm UTC](https://community.thunkable.com/t/search-keywords-from-google-sheet-not-working/4107665/2 "2025-09-25T12:45:24Z")
Hello @robert.lundelli4pcye The issue is the variable selected on the following blocks: ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/e/f/ef3029c71a8fdc2bd52818afcc4178a1ed683a3c.png) Also, the lowercase block should be used on the text, not on the list. You can find more examples in our community: [https://community.thunkable.com/t/new-way-to-add-search-and-filtering-feature-in-to-your-app/3939241](https://community.thunkable.com/t/new-way-to-add-search-and-filtering-feature-in-to-your-app/3939241) [https://community.thunkable.com/t/local-dataviewer-search/4107613](https://community.thunkable.com/t/local-dataviewer-search/4107613) ---
**Author:** ![robert.lundelli4pcye](https://avatars.discourse-cdn.com/v4/letter/r/f08c70/32.png) [@robert.lundelli4pcye](https://community.thunkable.com/u/robert.lundelli4pcye)\ **Post date:** [September 25, 2025, 1:00pm UTC](https://community.thunkable.com/t/search-keywords-from-google-sheet-not-working/4107665/3 "2025-09-25T13:00:38Z")
Thank you for answering. I worked on it a bit more and got some of it to work. I now have a button that change the text and are clickable to open the link in the sheet. Next step is to have the full google sheet at the homepage as a data viewer list. I am trying to filter the list so that only the links connected to the keyword is viewed. Something like the one you created. I am this far in the block logic. Any suggestions on the next step? ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/e/0e0e2edc9b79ff7fe5aa137a6c9003df41dc3dd7.png) ---
**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:** [September 25, 2025, 1:36pm UTC](https://community.thunkable.com/t/search-keywords-from-google-sheet-not-working/4107665/4 "2025-09-25T13:36:06Z")
Which method are you going to use of the link I shared in the previous message? Are you going to create an extra table or create a filter view? ---
**Author:** ![robert.lundelli4pcye](https://avatars.discourse-cdn.com/v4/letter/r/f08c70/32.png) [@robert.lundelli4pcye](https://community.thunkable.com/u/robert.lundelli4pcye)\ **Post date:** [September 26, 2025, 7:42am UTC](https://community.thunkable.com/t/search-keywords-from-google-sheet-not-working/4107665/5 "2025-09-26T07:42:48Z")
First I was thinking just a searchbar like the one with the fruits. But really liked the one you had created with the filter options. So I think I will dig in to that. Can I set it up as the one with fruits and go from there and add the filters you created after? ---
**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:** [September 26, 2025, 9:00am UTC](https://community.thunkable.com/t/search-keywords-from-google-sheet-not-working/4107665/6 "2025-09-26T09:00:39Z")
Hi @robert.lundelli4pcye Yes, you can implement the filter view way for the searching without adding the filters. The only issue with this method is that “contain” doesn’t exist as a filter. If you add an equal condition on the table and you need to display all the data in the beginning then you need to add an extra column and condition. Here is an example: [Strict Dataviewer Search - Tutorials and DIY Guides - Community](https://community.thunkable.com/t/strict-dataviewer-search/4107613) The only issue with the method above is that you need to type the exact item in the search. Another variation of this method is below and solves this issue using greater and lower on the conditions, but it fails for items with multiple words: [Dynamic Dataviewer Search - Tutorials and DIY Guides - Community](https://community.thunkable.com/t/dynamic-dataviewer-search/4107667) ---
**Author:** ![robert.lundelli4pcye](https://avatars.discourse-cdn.com/v4/letter/r/f08c70/32.png) [@robert.lundelli4pcye](https://community.thunkable.com/u/robert.lundelli4pcye)\ **Post date:** [September 26, 2025, 9:58am UTC](https://community.thunkable.com/t/search-keywords-from-google-sheet-not-working/4107665/7 "2025-09-26T09:58:08Z")
Thank you for taking the time to explain. I will look in to all this examples! Again thanks! ---
**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:** [December 25, 2025, 9:58am UTC](https://community.thunkable.com/t/search-keywords-from-google-sheet-not-working/4107665/8 "2025-12-25T09:58:48Z")
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.