I keep wanting to love Google Sheets as a building block for creating rich applications, but Apps Script is so painful to use and my complex sheets are almost a

I keep wanting to love Google Sheets as a building block for creating rich applications, but Apps Script is so painful to use and my complex sheets are almost always full of cells that are stuck at "Loading..." If you can solve the former I would be grateful. Solving the latter is a much bigger challenge.