Description


If you want to move Google Analytics data to a spreadsheet, use the Analytics add-on in Google Sheets. After your data’s in Sheets, you can clean it up, create graphs, and share your findings with your team.


Instructions


Get the Analytics add-on

  1. If you haven’t already, sign up to start using Analytics.
  2. In Sheets, create a new spreadsheet.
  3. Click Add-ons > Get add-ons.
  4. Search for the Google Analytics add-on and click FREE.
  5. Click Allow.


Create an Analytics report

  1. Open a spreadsheet in Sheets.
  2. Click Add-ons > Google Analytics > Create new report.
  3. Enter your information and click Create Report. Your analytics data appears in a new spreadsheet.

    For help, see Google Analytics Spreadsheet Add-On.