Google Analytics for Google Spreadsheets
I have been looking to store certain data from Google Analytics in a document to show to a client. The catch being, I wanted this to be available on an ongoing basis, wanted real-time data but didn’t want to have information on there which was not of interest to them.
Happily, I found an easy way to do it thanks to Jamie Steven (@jamies). Who not only has published a tutorial on how to get real-time Google Analytics data into a Google spreadsheet to create a custom report - but he has also created a template which you can copy. Both extremely useful. (sh)