# \[Solved\] Obtain Row ID without Data Viewer

**URL:** <https://community.thunkable.com/t/solved-obtain-row-id-without-data-viewer/3694989>\
**Category:** Feature Requests\
**Tags:** google-sheets, auth\
**Created:** [March 27, 2025, 9:43pm UTC](https://community.thunkable.com/t/solved-obtain-row-id-without-data-viewer/3694989 "2025-03-27T21:43:04Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![krish05](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/krish05/32/200523_2.png) [@krish05](https://community.thunkable.com/u/krish05)\
**Post date:** [March 27, 2025, 9:43pm UTC](https://community.thunkable.com/t/solved-obtain-row-id-without-data-viewer/3694989/1 "2025-03-27T21:43:04Z")

</div>

I’m using an authentication process with Firebase Authentication and Google Sheets. The reason I’m using Google Sheets to obtain a name from the email entered. I want to retrieve the data through row ID, but have no idea how. I tagged it under Feature Requests in case this feature doesn’t exists. Or is there any other better, easier alternative?

Example:

```auto
// Data being entered into Google Sheets
Name: krish05
Email: test@test.com
Password: testpassword123

```

```auto
// Data being entered onto Firebase Authentication
Email: test@test.com
Provider: Email address
Password: testpassword123

```

If the authentication is valid, Firebase will grant authority into the application. Then using Google Sheets, it will find the Name using a row ID, the same one that was entered for the email.

```auto
if valid = True:
  authenticate Firebase account
  do:
    set stored variable first name to 
      col in sheet1, defaultview, names col, row id... # same rowID of email entry

```

---

<div class="post-metadata">

**Author:** ![krish05](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/krish05/32/200523_2.png) [@krish05](https://community.thunkable.com/u/krish05)\
**Post date:** [March 29, 2025, 6:51pm UTC](https://community.thunkable.com/t/solved-obtain-row-id-without-data-viewer/3694989/2 "2025-03-29T18:51:20Z")

</div>

helooooooooooooooooooooooooooooooooooooooooooo???

---

<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 1, 2025, 11:14pm UTC](https://community.thunkable.com/t/solved-obtain-row-id-without-data-viewer/3694989/3 "2025-04-01T23:14:46Z")

</div>

Hello @krish05  
To build this, you will need to create a new column in your Google Sheets to store the user ID for every user.  
When the user logs in, you could use the [get first row object from data source block](https://docs.thunkable.com/blocks/app-features/data-sources-blocks#get-row-object-from-block-overview) using the user ID as a filter.

---

<div class="post-metadata">

**Author:** ![krish05](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/krish05/32/200523_2.png) [@krish05](https://community.thunkable.com/u/krish05)\
**Post date:** [April 2, 2025, 11:08pm UTC](https://community.thunkable.com/t/solved-obtain-row-id-without-data-viewer/3694989/4 "2025-04-02T23:08:31Z")

</div>

Sorry, forgot I actually got an answer from @tatiang via another post. Thanks for all the help!

---

<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 3, 2025, 9:37am UTC](https://community.thunkable.com/t/solved-obtain-row-id-without-data-viewer/3694989/5 "2025-04-03T09:37:47Z")

</div>