If you followed Do something useful with GAS in 5 minutes, you’ll already know how to use a spreadsheet as a database, and in Get analytics profiles in a sheet you found out how to get Google Analaytics properties into a sheet. To be able to get analytics data, you’ll need the id of the profile you are interested in. It’s the column named ‘id’ from Get analytics profiles in a sheet

Here’s how to get your pageviews into a Sheet. This is the second step if you are interested in Displaying analytics data on site pages, or otherwise playing around with you Analytics data.

do something in 5 with gas-5-analytics

For more like this, see Google Apps Scripts Snippets

For help and more information join our forum, follow the blog, follow me on Twitter