Calling an API for each row data vs caching the data for the entire table for apps script web app
I have a CRUD web application running on apps script that connects to a google sheet.
When the app starts, the entire table is loaded using an API, that takes around 15-20s.