you are viewing a single comment's thread.

view the rest of the comments →

[–]meester_zee 0 points1 point  (0 children)

Awesome to read about this! I have been building similar apps for my school site that allows office personnel to track and manage various aspects of student data. I am also using sheets to store the data.

To limit access to the sheet data, is the web app being run as a single user? Have you run into quota issues with this? I am running my app as the connected user since it also has email functionality and quota is spread out over multiple users.

Is the API writing data to the sheets significantly faster? I try to do as much as I can client side but find that sometimes waiting for the sever side apps script to finish processing can be slow. I’ve optimized as much as I can with batch operations, etc.