Connect to google sheet to call data?

[Marie]

Hi coders, I made an application with google sheet as a database.
The user is asked to connect with his name and registration number already registered in the database and which I provided to him. If the name and registration number are correct, another Screen opens and displays the desired data in labels (Example: his photo, his name, note1, note2).
Screen 1 consists of two TextBoxes and a Button.
Screen 2 consists of image and labels.
How to code this. Who can help me?
THANKS

[Didyme_Apps]

You can search in the Kodular community. There are countless posts that talk about this issue. For example, this one

[FREE/PAID API] Advance Google SpreadSheet Extension with SQL Query

[FREE/PAID API] Advance Google SpreadSheet Extension with SQL Query This extension allow you to get full control of Google SpreadSheet Functions with API Key. It doesn’t require any Script just Create API Key and Connect Google Spreadsheet. Google Spreadsheet Extension is Free for first 100 Users with 1 Year Validity. Step1: How to Create API Key for Google SpreadSheet Extension. Step2: How to Connect Google SpreadSheet with Kodular. Google SpreadSheet Extension Blocks Google Spre…

Or another one,

Google Sheets and Apps Script

Disclaimer. My english sucks. Because I WANT to use Google Sheets !!! When I think about using Google sheets along with my application, I want a few basic things. They are adding (and possibly removing) rows and columns, reading (and possibly replacing) values ​​in the required cells, and doing these things from my app. Yes, I want custom API for my app, with blackjack and hookers! Is it really that hard? It took me a week to find answers and compile all information, i want to share with you n…

I always recomemded to looking for in the community.

[Marie]

I’m starting programming: I’m still a beginner.
I’ve already done the project with “FireBase” and I’m doing it again with “Google Sheet”.
Here is the code I used in the “login” screen:

and this is the code used in the “note” screen (screen 2) which displays the student’s notes.

I want the same job but with “Google sheet” this time on a practical level: blocks of code.
If there is a tutorial or someone can help me to do the code, I will be grateful.
THANKS