Turning GoogleSpreadSheets into an entity/database

Hello, I am trying to connect my spreadsheet to my application. I manged the get the rows of my sheet with an api call:

 


I managed to get the data in this form :

I want to turn it to a legitimate database and i would like to make querys and such on it. Does anybody have an idea or example with an oml how to do this?

Thank u very much:)

I addition i theoretically want to make this api call every hour and update my database.


Hello Roy 

Can you please share the screenshot of the Server Action and Value Assignment Please?

Hello, the server action is a function that i imported from another dependency but it works its not the problem.

I need to figure out how to make this list of list of items where each item represents a row in my sheet to a database. Thank u very much

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.