Skip to main content

Google Introduces Analytics Spreadsheet Add-On - Schedule and Run Reports Automatically

Philip Walton, lead Google Analytics developer recently introduced the Google Analytics spreadsheet add-on that works to automate your work and saves time from manually editing analytics data in spreadsheets. It works similar to the magic script but the interface is easier to use. In fact, it is an enhancement of the older magic script. It brings you the power of the Google Analytics API combined with the power of data manipulation in Google Spreadsheets. This tool is useful for:

  • Querying data from multiple views.
  • Creating custom calculations involving several dimensions and metrics based on custom dates.
  • Create visualizations with the built-in visualization tools, and embed those visualizations on third-party websites.
  • Scheduling your reports to run at a future date automatically.
  • Enhancing privacy settings to control who can view and edit your spreadsheet.

How to Install the Google Analytics Add-On

  • Create a new Google Spreadsheet (or open an existing one).
  • Choose: Add-ons > Get Add-ons… from the menu bar. (You can also get this add-on by clicking here)
  • Find the Google Analytics Add-on from the add-ons gallery and select it.
  • Click accept when asked for permissions. A "Google Analytics" submenu should now appear in the Add-ons menu.
Have a look at the below video for easy understanding:

How to Create and Run Reports?

  1. Open spreadsheet. Click on Add-ons -> Google Analytics -> Create a New Report
  2. A right hand sidebar will appear. Provide a name for the report you wish to prepare.
  3. Select account information and choose custom metrics and dimensions.
  4. When done, click the create report button.
This will create your custom report.

Now go to "Add-ons" > "Google Analytics" > "Run Reports" to run your first report. You can also  go to "Add-ons" > "Google Analytics" > "Schedule Reports" from the menu bar. This opens a report scheduling dialog where you can schedule when your reports will run.