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:
- Create a new spreadsheet
- Choose Tools > Script Editor
- Create a new function
- Copy and Paste the code into the function block
- Save it
- Choose Resources > Advanced Google Services
- Turn on Google Analytics API v3
- Go to the Google Developers Console
- Turn on Analytics API
- Refresh your spreadsheet
- Enjoy!