Category: Google Apps Script

Registering blog addresses and generating a OPML file (Notes on FeedWordPress and MOOC-In-a-Box)

Last week I got a number of enquiries about using Google Forms. One of these was a question from Martin Weller (OU) who is in the process of setting up H817 which is an Open University open course (MOOC) on Openness in Education. He asked: how do I go from this [Google Form] to an […]

4 Comments

Keep your Twitter Archive fresh on Google Drive using a bit of Google Apps Script

A soon as you download your Twitter Archive it immediately becomes stale. To save having to request fresh copies this post shows you how you can not only keep your archive fresh on Google Drive but also share it to the world.

171 Comments

Analysing WordPress post velocity and momentum stats with Google Sheets (Spreadsheet)

Like other wordpress.com and self-hosted wordpress blogs using Jetpack I got my annual report. This left some questions about the posts made later in the year that hadn’t had time to collect views so I’ve created a Google Spreadsheet template which reveals some more answers.

2 Comments

Backup Twitter Status Updates to a Google Spreadsheet

It looks like Twitter are finally rolling out the option to download all your tweets. If you are still itching to get your data this Google Spreadsheet template should help.

5 Comments

Guest Post for Big Data Week #bdw13: Getting Creative with Big Data and Google Apps

I was recently asked to write a guest post for Big Data Week on using Google Apps as an interface for Big Data. For the post I decided to revisit an old recipe which uses Google Sheets (Spreadsheets) and Google Apps Script to interface the Twitter and Google Analytics API

2 Comments

Mozilla Open Badges Issuer Gadget for Google Sites (and issuing Badges using a Google Spreadsheet)

Want to issue badges in Google Sites? That was the challenge I set myself. My solution is the Open Badges Issuer Gadget for Google Sites. This post outlines my solution and even lets you recieve a badge issued via a Google Form.

9 Comments

Summary of social monitoring tools and recipes I use at JISC CETIS

Tools and recipes I use for monitoring and reporting impact. All of the tools use Google Spreadsheets/Apps Script which is free for anyone to use with a Google account, and all the recipes use free tools (the exception being owning a copy of Excel).

2 Comments

Any Questions? Filtering a Twitter hashtag community for questions and responses [situational awareness] #CFHE12

I believe a key aspect of cMOOCs is how they agregrate content. In this post a present a new tool I created which extracts possible questions tweeted in a hashtag community, agregregating some of the responses and providing an interface to mkae it easy for others in the community respond.

9 Comments

Converting blog post urls into MS Word documents using Google Apps Script #oerri

Outlining some Google Apps Script code I’ve written that takes some blog post urls and makes a downloadable html/.doc report

5 Comments

[Failed] Embedding live data from Google Spreadsheet with Apps Script ContentService in PowerPoint using oomfo

I came, I saw, I failed. This was a potentially promising hack that didn’t work out. Hopefully you’ll get as much benefit from failure, as from success. Today I can across oomfo (from the same makers as FusionCharts): oomfo is a plug-in for Microsoft PowerPoint that brings all the awesomeness of FusionCharts Suite XT to […]

6 Comments
« Previous Page — Next Page »
css.php