How to minimize the code for retrieving the data from Google Sheet?


Good day Thunkers! How to solve this kind of code to minimize the way retrieving the data from Google Sheets to faster response? I try the [get all row] code in spreadsheets but the response is [object Object] .

Is there is another way to correct the code? Thank you so much in advance!

2 Likes

Use GetAllRows and then read the data as a list of objects that has column names and values.

2 Likes