Category: Google Apps Script

Bye-bye Protovis Twitter Community Visualizer: Hello D3 Twitter Community Visualizer with EDGESExplorer Gadget

The problem with starting my new OER Visualisation job is I’ve got less time to explorer my own little projects. This may be a blessing for some of my readers as it means I can do less waffling. So in brief: Tony came up with this brilliant solution for plotting twitter hashtag community graphs (it […]
2 Comments

Using wiki markup to format html emails in Google Apps Script using Remy Sharp’s wiki2html

One of the first tutorials I did when starting with Google Apps Script was the Simple Mail Merge tutorial. Since then some of the Google Apps Script top contributors guest posted 4 ways to do Mail Merge using Google Apps Script. Today when I was trying to solve my own html email problem I decided […]
One Comment

Updates to Twitter Archiving Google Spreadsheet v2.3 [TAGS]

Recently I’ve started exploring extended Twitter conversations using data captured from my Twitter Archiver Google Spreadsheet (think I going to rename this TAGS) and one of the problems was “The user ids in the Search API are different from those in the REST API … This defect is being tracked by Issue 214. This means […]
One Comment

Suggest an article for The GAS: Google Apps Script Scoop

For a while I’ve been curating ‘The GAS’ which is a collection of Google Apps Script examples and news pulled together using scoop.it. I started it mainly because I’m a ‘patterns programmer’, that is I have limited formal coding skills so learn and produce things from other people’s examples. Because others getting started with Apps […]
One Comment

Google Spreadsheets as a Database – INSERT with Apps Script form POST/GET submit method

Update 04/07/2014: I’ve revisited this code and made a number of improvements. Read more in Google Sheets as a Database – INSERT with Apps Script using POST/GET methods (with ajax example) Update: See comment by James to streamline this even more. I was recently rediscovering an old Hirst post on Google Spreadsheets as a Database […]
84 Comments

Using the Viralheat Sentiment API and a Google Spreadsheet of conference tweets to find out how that keynote went down

Did you tune into into Donald Clark’s “Don’t Lecture Me!” keynote at ALT-C 2010 or were you at Joe Dale’s FOTE10 presentation? These presentations have two things in common, both Donald and Joe posted their reflections of a ‘hostile’ twitter backchannel (see Tweckled at ALT! and Facing the backchannel at FOTE10) and I provided a […]
14 Comments

The art of discovery: Looking at how UK Web Focus, OUseful.info and MASHe interconnect using Google Spreadsheets and NodeXL

Moving away from social networks I wanted to discover how Brian Kelly’s UK Web Focus, Tony Hirst’s OUseful.info and my MASHe are linked together. I chose Brian’s and Tony’s blogs for this because they have highlighted my work in the past so I know I’ll get some data. The main reason for this exercise was […]
One Comment

Using Google Spreadsheet/Apps Script and Google Social Graph to get Twitter edges for visualizing in NodeXL and Gephi

One of the things I really liked about the network analysis and visualisation tool NodeXL which I wrote about last week was the built-in tools for grabbing data from Twitter. I said: The advantage of NodeXL, particularly for graphing Twitter communities, is it has built-in features for grabbing the data for you. Not only that […]
3 Comments

Some Google webinars exploring Google Apps Script in Education

If your interested in learning more about Google Apps Script in Education Google are doing some webinars as part of their Google Apps for Education series. Here are a copy of the dates/times that were emailed to me (seminar are usually delivered in the afternoon American time so if it’s past your bedtime you might […]

My #eas11 world premier: Creating personalised Google Documents from Form submissions (and some other things)

Tomorrow (Friday 26th August) for my eAssessment Scotland 2011 workshop I’ll be doing a world premier extending the form submit sheet split example to let tutors create individual student Documents from submitted data (e.g. taking a sheet like this and at a click of a button produce this document. Update: Still some refinement in the […]
One Comment
« Previous Page — Next Page »
css.php