# How to search student details by name from Google Sheet in Thunkable?

**URL:** <https://community.thunkable.com/t/how-to-search-student-details-by-name-from-google-sheet-in-thunkable/3822460>\
**Category:** Questions about Thunkable X\
**Tags:** beginner, spreadsheets, help, search, google-sheets\
**Created:** [May 12, 2025, 3:17pm UTC](https://community.thunkable.com/t/how-to-search-student-details-by-name-from-google-sheet-in-thunkable/3822460 "2025-05-12T15:17:24Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![indilipi.info62syhc](https://avatars.discourse-cdn.com/v4/letter/i/c37758/32.png) [@indilipi.info62syhc](https://community.thunkable.com/u/indilipi.info62syhc)\
**Post date:** [May 12, 2025, 3:17pm UTC](https://community.thunkable.com/t/how-to-search-student-details-by-name-from-google-sheet-in-thunkable/3822460/1 "2025-05-12T15:17:25Z")

</div>

Hi everyone,

I’m creating an app in Thunkable that is connected to a Google Sheet containing student details. I want to implement a **search function** as follows:

- The user enters a **student’s name** in a Text Input (`TextInput_Name`).
- When the **Search Button** is clicked, the app should:
  1. Search the connected Google Sheet for a row where the “Name” column matches the input.
  2. Display that student’s **details** (such as Student Name, ID, Mob: Number, or any other columns) in separate labels below.

- If no student is found, it should display a message like “No student found”.

How can I create the blocks for this functionality?

Any help or sample blocks would be really appreciated!  
Thanks in advance.

 ![Img 01](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/c/f/cfb2b714521f48e113c7af29a4c4e9bae746826b.gif)

---

<div class="post-metadata">

**Author:** ![steve\_synopsis](https://avatars.discourse-cdn.com/v4/letter/s/48db29/32.png) [@steve\_synopsis](https://community.thunkable.com/u/steve_synopsis)\
**Post date:** [May 13, 2025, 1:36pm UTC](https://community.thunkable.com/t/how-to-search-student-details-by-name-from-google-sheet-in-thunkable/3822460/2 "2025-05-13T13:36:48Z")

</div>

Hi,

Can you share what you have done so far in Thunkable?

---

<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:** [May 16, 2025, 9:48pm UTC](https://community.thunkable.com/t/how-to-search-student-details-by-name-from-google-sheet-in-thunkable/3822460/3 "2025-05-16T21:48:58Z")

</div>

You can use the [get first row object from block](https://docs.thunkable.com/blocks/app-features/data-sources-blocks#get-first-row-object-from-block-overview)

---

<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:** [August 14, 2025, 9:49pm UTC](https://community.thunkable.com/t/how-to-search-student-details-by-name-from-google-sheet-in-thunkable/3822460/4 "2025-08-14T21:49:03Z")

</div>

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