Exporting Google Analytics Data to Google Sheets

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

Click Add-ons from the Menu. A dropdown will appear and click on Google Analytics

Another dropdown menu will appear. Click on Create New Report.

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.

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

Name Report Configuration. Add the necessary data needed

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