Connect Google Analytics to Google Sheets with Windsor.ai

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 Windsor.ai

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

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

 

Getting your Google Analytics data to Google Sheets

Start Windsor.ai

Add-ons → Windsor.ai→ Launch

 

Set up queries

Pick corresponding values from drop-down menus.

Example:

Data source: Google Analytics

Select view: Windsor.ai 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 windsor.ai sidebar

Click > Schedule > Add triggers

In trigger view, you can pick the frequency of updates.

Windsor.ai: 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.

insights

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.