# Finding an item in a Google Sheets list

**URL:** <https://community.thunkable.com/t/finding-an-item-in-a-google-sheets-list/2678228>\
**Category:** Questions about Thunkable X\
**Created:** [November 2, 2023, 6:12pm UTC](https://community.thunkable.com/t/finding-an-item-in-a-google-sheets-list/2678228 "2023-11-02T18:12:22Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![dragondudes](https://avatars.discourse-cdn.com/v4/letter/d/90ced4/32.png) [@dragondudes](https://community.thunkable.com/u/dragondudes)\
**Post date:** [November 2, 2023, 6:12pm UTC](https://community.thunkable.com/t/finding-an-item-in-a-google-sheets-list/2678228/1 "2023-11-02T18:12:22Z")

</div>

In the signup page of my app, I’m trying to implement a functionality that makes it so that a user can’t make an account if there is already an account with that email address, but my code isn’t working. I’m storing my user data (such as email address) in a Google sheet. Any suggestions?

 ![Screenshot 2023-11-02 at 10.57.07 AM](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/d/d/dde5b558f9466fa7d185aaf64dea911b46501b92.png)

---

<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:** [November 2, 2023, 8:28pm UTC](https://community.thunkable.com/t/finding-an-item-in-a-google-sheets-list/2678228/2 "2023-11-02T20:28:38Z")

</div>

Can you show all of your sign in blocks?

One mistake you’ve made is that the `find first occurence of item` block returns an integer value representing the row # where the search term is found or zero (0) if it doesn’t exist. So don’t compare it to true… instead check to see if the occurrence is greater than zero.

---

<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:** [January 31, 2024, 8:28pm UTC](https://community.thunkable.com/t/finding-an-item-in-a-google-sheets-list/2678228/3 "2024-01-31T20:28:39Z")

</div>

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