Exporting Google Analytics Data to Google Sheets

What You Need:

  • Access the Google Analytics Accounts
  • Add Google Analytics Ad on Google Sheet
  • Go to the folder under shared folders where the sheet will be saved
  • Click the New button
  • Click Google Sheets and choose Spreadsheet
  • Create the title of the report
Managing Analytics Account
  • Click Add-ons from the Menu. A dropdown will appear and click on Google Analytics
Managing Analytics Account
  • Another dropdown menu will appear. Click on Create New Report.
Managing Analytics Account

A small window will appear on the left of the screen. Input the data needed which includes the Name of the Report, select a View which requires the Google Analytics Account and its View settings.

Managing Analytics Account

Under the third columns, choose the necessary metrics, dimensions and segments needed. Click Create Report when done.

Managing Analytics AccountA New Tab will be generated with the Name Report Configuration. Add the necessary data needed Managing Analytics Account

Go back to the Google Analytics add on and Click Run Report from the dropdown menu to generate report.

Managing Analytics Account