How to use Google Analytics add-on for Google Sheets

Google add-ons is a feature of Google Sheets that allows you to turbocharge the way you use spreadsheets. Most of the add-ons that we feature on the blog are 3rd party developers. Offering features like task automation or software integration. This add-on is developed by Google, which means it runs seamlessly with Google products, is intuitive to use, and of course, free! Let’s get you started with a basic primer on how to use the Google Analytics add-on to improve the way you report and share your website data!

How to Access the Google Analytics Add-on

It is really simple to get add-ons for Sheets! The fastest way to get this add-on is to click this link that will take you directly to the web store. Simply click the Free button and the add-on will be added to your Google Sheets account.

Alternatively, you can get the add-on by following these steps:

  1. Open a spreadsheet
  2. Click the add-ons button in the navigation menu
  3. Click the Get add-ons button
  4. A window will pop up for you to browse
  5. Type “Google Analytics” in the search box. There are a lot of add-ons for Google Analytics, but the one you are looking for should be #1.
  6. Click the Free button to get the add-on

You are ready to start using Google Analytics!

Options in The Main Toolbar

To begin using the Google Analytics add-on, Click Add-ons → Google Analytics. When you hover over the Google Analytics button, you will see three options:

  • Create a new report: creating reports is not necessary, but it’s a good step for users who are new to the add-on. If you click this option, a sidebar will appear on the right side of the sheet to help you automatically create a new report. As you become a more advanced user, you might just create these reports yourself.
  • Run reports: when you select this option, the add-on will run all of the reports you have created. You can choose to have the output data go into the current sheet you are on or a new sheet of your choice. If there are reports you don’t want to run, get around the add-on by simply deleting the name of the report. Because of the way the add-on is designed, it won’t be able to run reports without names.
  • Schedule reports: ever a fan of automation, scheduling reports is one of my favorite ways to improve workflows. You can schedule your reports to run hourly, daily, weekly, or monthly from the sidebar that appears when you select this option.

 

Let’s Create a Report

For this tutorial, we will start by creating a new report. Select this option to make the sidebar for this feature appear. To run reports, you need to be the owner of the analytics account, and ideally, have some basic knowledge of Google Analytics terminology. Although this add-on is meant to make using Analytics easier, you will still need to have some basic knowledge. Fortunately, using this add-on will give you a greater understanding of your Analytics data, and you can use the Google Analytics Academy for free if you need to brush up on your skills.

  1. Name your report: Ours is Sample Report 1
  2. Select a view: Choose your Account name, Property name, and the View from the drop-down options. Most of you will probably just have one analytics account, but if you are managing multiple websites, you will need to be sure to choose the correct values.
  3.  Choose configuration options: Here you will customize the reports. This tool is great because it can help novice users learn what sort of metrics will be most valuable for providing insights into their traffic.
  4. When you are finished choosing the conditions for your first report click Create Report and the add-on will create a report template for you. You can continue to create new reports, and they will be displayed sequentially on the same sheet.

use google analytics add-on

 

Run Reports

Now that we have created some reports using the toolbar, let’s use the add-on to run some reports. Select the second options from the menu by clicking Add-ons →  Google Analytics → Run Reports. That’s all you need to do! The add-on will begin to work automatically and will create a new sheet for each report. So, my sheets are titled “Sample Report 1, Sample Report 2, Sample Report 3”. After you set up your report, you can choose the third option and schedule your reports to run automatically. Use your Google sharing settings to share the results with the whole team!