Hey Ahmed Welcome to Kodular,
As per your given information, you are trying to save data in Google Sheets and later retrieve it to show in your app.
This one is a little advanced so, if you are a beginner don’t click on the link given below, after getting knowledge of Google Sheets, web components especially API calls and app scripts you can visit this.
If you are a beginner use this:-
It contains everything you need, a little hard to set up but after that, you will be doing fine.
You can also search on YouTube for tutorials.
But I will recommend you to use one of the following databases:-
- Firebase - It’s costly very costly
- Airtable - It’s okay and easy to use
- You can use baserow also
An extension of each of the three is available just search on the community.
Thanks for reading