Google Apps Script Examples is a site with several powerful tools for Google Apps - including Awesome Tables for Google Sites.  See these examples, then head over to the site to see what else is there.  Don't miss the Advanced Summary of responses for a Google Form survey.  

The gadget's documentation is helpful.