# Google sheets text

**URL:** <https://community.thunkable.com/t/google-sheets-text/3425184>\
**Category:** Questions about Thunkable X\
**Tags:** beginner, help\
**Created:** [December 19, 2024, 5:29pm UTC](https://community.thunkable.com/t/google-sheets-text/3425184 "2024-12-19T17:29:45Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![mbp117](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/mbp117/32/191104_2.png) [@mbp117](https://community.thunkable.com/u/mbp117)\
**Post date:** [December 19, 2024, 5:29pm UTC](https://community.thunkable.com/t/google-sheets-text/3425184/1 "2024-12-19T17:29:45Z")

</div>

how do i get a text input that says words say that something contains it using google sheets? rightnow all it can say is yes or no but I want it to say what words it contained

---

<div class="post-metadata">

**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\
**Post date:** [December 19, 2024, 11:28pm UTC](https://community.thunkable.com/t/google-sheets-text/3425184/2 "2024-12-19T23:28:52Z")

</div>

I’m not sure I understand your question. Can you give a few examples?

---

<div class="post-metadata">

**Author:** ![mbp117](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/mbp117/32/191104_2.png) [@mbp117](https://community.thunkable.com/u/mbp117)\
**Post date:** [December 22, 2024, 5:46pm UTC](https://community.thunkable.com/t/google-sheets-text/3425184/3 "2024-12-22T17:46:29Z")

</div>

i want it to show text from an input in the app and say that it contains certain words and those certain words are in a google sheet

---

<div class="post-metadata">

**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\
**Post date:** [December 22, 2024, 6:13pm UTC](https://community.thunkable.com/t/google-sheets-text/3425184/4 "2024-12-22T18:13:11Z")

</div>

Okay but that’s a description of what you want. An example would be like this:

**My Google Sheet has values including:**  
apple  
orange  
banana

**If the text input is:**  
ban

**Then a label will display:**  
banana

Is that what you mean?

---

<div class="post-metadata">

**Author:** ![mbp117](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/mbp117/32/191104_2.png) [@mbp117](https://community.thunkable.com/u/mbp117)\
**Post date:** [December 26, 2024, 10:35pm UTC](https://community.thunkable.com/t/google-sheets-text/3425184/5 "2024-12-26T22:35:15Z")

</div>

kinda i just need a join thing so it says “it contains banana”

---

<div class="post-metadata">

**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\
**Post date:** [December 26, 2024, 11:07pm UTC](https://community.thunkable.com/t/google-sheets-text/3425184/6 "2024-12-26T23:07:17Z")

</div>

You’re not providing enough information but maybe you’re just looking for the [Join](https://docs.thunkable.com/blocks/blocks/text#join) block?

---

<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:** [March 26, 2025, 11:08pm UTC](https://community.thunkable.com/t/google-sheets-text/3425184/7 "2025-03-26T23:08:03Z")

</div>

Closed on March 26, 2025, 11:08pm UTC

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