Get analytics profiles in a sheet

If you followed Do something useful with GAS in 5 minutes, you'll already know how to use a spreadsheet as a database. Here's how to use that along with Google Analytics to get all your profile data into a sheet.. This is the first step if you are interested in Displaying analytics data on site pages, or otherwise playing around with your Analytics data.

do something in 5 with gas-4-anltycs


For more snippets like this see Google Apps Scripts snippets
For help and more information join our forum, follow the blog, follow me on twitter
You want to learn Google Apps Script?
Learning Apps Script, (and transitioning from VBA) are covered comprehensively in my my book, Going Gas - from VBA to Apps script, available All formats are available now from O'Reilly,Amazon and all good bookshops. You can also read a preview on O'Reilly. 
If you prefer Video style learning I also have two courses available. also published by O'Reilly.
 Google Apps Script for Developers and Google Apps Script for Beginners.



Comments