How to use dynamic text based on user information?

Hi guys,

What a great product this looks to be! Have tried a lot of solutions, but this is just outstanding.

Anyway: I want to create a webapp, where certain content changes based on user information.

I host the info on a spreadsheet and via a spreadsheet-to-API program, make the imports.
The spreadsheets looks like this:
Row 1: “User ID” - “User Email” - “User First Name” - “Soup of the day”
Row 2: “1” - “youremail@hotmail.com” - “Rick” - “tomato soup”
Row 3: “2” - “myemail@hotmail.com” - “Scott” - “chicken soup”

The import of this data is successful, but now I want texts and list items to be adjusted, based on the email someone logs in with.

Example:
When youremail@hotmail.com logs in, I want the title to say “Hi Rick”
When myemail@hotmail.com logs in, I want the title to say “Hi Scott”

When youremail@hotmail.com logs in, I want my first list items to say: “tomato soup”
When myemail@hotmail.com logs in, I want my first list items to say: “chicken soup”

Thanks for your help!

this is really easy. When user is logging in with email. Fetch the User first name and soup of the day. And save them in page or app variable and map user first name with title and do same with soup of the day with list items. ping me if more help needed. Thanks

Could you elaborate on the whole authentication process on Appgyvver and how to then fetch the data from the API?
I am new here, and the documentation is not really clear to me either