Google Analytics Magic Script + New Spreadsheets

If you’re like me, you love(d) using Nick Mihailovski’s Google Analytics Report Automation (Magic Script) for automating your data pulls from Google Analytics. As of April 2014, Google launched an Add-On’s feature which includes an awesome, upgraded version of Nick’s Google Analytics magic script. The only problem is that you can no longer automate your reports.

This is a huge problem, especially if you have clients who require daily (or even up-to-the-minute) data updates like me. The good news is, you can still install the Magic Script yourself. Just download it here: Google Analytics Report Automation (Magic Script)

To install it, follow these steps:

  1. Create a new spreadsheet
  2. Choose Tools > Script Editor
  3. Create a new function
  4. Copy and Paste the code into the function block
  5. Save it
  6. Choose Resources > Advanced Google Services
  7. Turn on Google Analytics API v3
  8. Go to the Google Developers Console
  9. Turn on Analytics API
  10. Refresh your spreadsheet
  11. Enjoy!

Download Google Analytics (Magic Script) .txt