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.