In this video, Nick Mihailovski of the Google Analytics team demos how to quickly build a dashboard using Google Sites, Google Spreadsheets, Google Apps Script and the Google Analytics API. The script demoed in the video can be downloaded from within the Google Spreadsheets by going to Tools - Script Gallery and searching for "analytics magic"