Gadgets

Using a canvas in Google Sites gadget

Originally I had figured to use HtmlService, along with an Html box, and to render the stats information using SVG. The first problem I ran into was that SVG would be stripped out by caja […]

Gadgets

Storing options and parameters

Site analytics were stored with the site and the analytics property to which they refer, and accessed through the cSiteStats library. You will need to take a copy of this so you can reference your own properties. […]

No Picture
Gadgets

Getting analytics for the site

Each night I used to run a scheduled task which takes the Google Analytics data for this Google Sites and matches it up to the site pages. At the time of writing I have 1000 […]

No Picture
Gadgets

Matching the site tree to the analytics data

This was also part of each evenings scheduled run. The site was serialized and each analytics entry was matched up to a page on the site. Some of the analytics data has variable quality of site links. Here’s how […]

No Picture
Gadgets

Database abstraction of site results

I used to abstract all database matters away from Google Apps Script with Database abstraction with google apps script. The scheduled analytics update wrote the matched site page and analytic data to an abstracted database. At […]

No Picture
Gadgets

Retrieving page data from GAS web service

As described in Database abstraction of site results, each site page has some associated analytics data stored in a database which is updated through a GAS trigger. The page gadget which displays that data is a […]

No Picture
Gadgets

Light JSONP implementation

Since we are doing a cross origin JSON request, and GAS does not support CORS, we have to use JSONP. To know more about JSONP see JSONP and JSON and Google Apps Script webapps. Here’s an […]

Gadgets

Embedding feeds in google sites

If you have a web page already built that you want to include in your site, you simply need to include an Iframe gadget and use the web page url as your iframe src. There […]

No Picture
Gadgets

Enhanced Github gadget

In Dynamic height github gadget for Google Site I showed how to display prettified source code directly from your gitHub repo on your Google Site. Here’s some enhancements to that same gadget with additional options as follows; […]

No Picture
Gadgets

Dynamic height github gadget for Google Site

I’ve used a few different techniques for embedding source code in the previous version of my site over the years. Here’s another one – this time taking source code directly from your github repo. As […]

No Picture
Gadgets

Fancy Gadgets

I’ve had a lot of fun with this topic since it combines a whole bunch of Google Apps Script things. However it was hard work, with many problems to solve. I hope you find it […]

Gadgets

Getting the pages in the site

This was also part of each evenings scheduled run. The site was serialized and each analytics entry is matched up to a page on the site. This whole project was heavily recursive, right from the site organization, […]