Is Google Sheets designed for this sort of usage? I would have been worried about hitting some undisclosed limits with the service.

A single dedicated server is not that big of an expense either. The site probably could even run on a single high end server as it is now? I guess I wouldn't have considered using something like Sheets given that. Neat idea though.