Obtain Row ID without Data Viewer

Questions about Thunkable Feature Requests
,
1

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:

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

// 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.

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
2

helooooooooooooooooooooooooooooooooooooooooooo???

3

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 using the user ID as a filter.