Connect Google Analytics to Google Sheets with

google analytics 1


google sheets

Finally, all your website and analytics data from Google Analytics available in Google Sheets

About Google Analytics

Google Analytics is the worlds most used Web Analytics platform and offers its users detailed insights into website traffic, conversions, sales and other customisable dimensions and metrics. It is available in 40 languages and has a market share of 82%.

About Google Sheets

Google Sheets is a web based spreadsheet tool. It allows end users to create spreadsheets, pivot tables, charts and run Google App Script code to automate various functions.

Connecting data from Google Analytics to Google Sheets

Step 1 – Open a fresh tab in your browser, login to Google Sheets

Step 2 – Go to Add-ons  > Get Add-ons >  Install

The second option is to install directly from the Google Workplace Marketplace. Search for and install

Once the installation is over, you can search for under the ADD-ONS menu in your Google sheet


Getting your Google Analytics data to Google Sheets


Add-ons →→ Launch


Set up queries

Pick corresponding values from drop-down menus.


Data source: Google Analytics

Select view: blog

Select date: Year to date

Select metrics: Pageviews

Split by dimensions: Page path vs. Year & month

Filter: Switzerland, let’s say total page views


Setting up automatic refreshes

You can also set up triggers (an automatic refresh) if you are running the same query.

On the sidebar

Click > Schedule > Add triggers

In trigger view, you can pick the frequency of updates. Connecting all marketing data

See the value and return on every marketing touchpoint

data warehouse

Providing 50+ marketing data streams, we make sure that all the data we integrate is fresh and accessible by marketeers, whenever they want.


Spend less time on manual data loading and spreadsheets. Focus on delighting your customers.

Start a free trial today.

Integrate all your data and measure what matters.