Update (May 30th 2014) The new Google spreadsheets have replaced the script gallery with add-ons, so you won’t be able to install the Magic script from Gdocs. You’ll need to copy paste the original script which can be found here into your script editor.
Even if you’re not familiar with the Google Analytics API, chances are that you’ve probably needed access. Maybe it’s because you need 5000 results from the GA interface, but your browser keeps crashing. Maybe you need more than 5000 URLs and you’re not in the mood to hack the URL in order to get it. Or maybe you just wish that you could perform month over month growth calculations quick and easily.
Well, today’s tutorial is about showing you how to get the data you need quick and easily - even if you don’t know your variables from your arrays.