Another interesting way to blog, sheet-posting, where you blog in a Google Spread sheet. I had a quick try. I’ve messed about with using Google Sheets as a store before. Guess you alway need to remember Google could pull the sheet from under your feet. I also remember when you could stick a webpage in google docs (or dropbox) and it would be served. The Sheets-Posting site is made with glitch.

Replied to A Generator for Martin (CogDogBlog)
I saw Martin Weller’s tweet out for a randomizing text generator: He got lots of replies (which is what make twitter useful when often it can not be), though many were just offering tools, no…

Hi Alan,
Love the random. Had a wee go at forking and having a googlesheet as a source. It might be a way of folk making their own without having to edit html…

http://git.johnj.info/edtechaphors/?id=1Tk-IUE8OG_InI6KjZ4GAFMm4IyJl1PoZQYzHCbm4fN8

I’ve had a long term interest in digital ‘fridge’ poetry, making my first efforts with Flash around 15 years ago. A year or so ago I was excited by Fridge Poetry – Google Sheets as Database by Tom Woodward. There were a couple of goodies in that post, getting the word list from a google sheet and a nifty way to allow folk to easily make their own. I made a sheet and a poem and slotted the idea away.

I’ve revisited Tom’s post (and others) a few times, gathering tools 1 and wondering.

On the holiday weekend, given poor weather and a head cold, I revisited the idea and made my own Fridge.

This riffs & extends the idea a wee bit:

  1. You can add a background image to the poem, either from a built in flickr search or a local one.
  2. There is a standard common word list and a topical one from the google sheet.
  3. The words in the lists can be used more than once.
  4. I used JavaScript as opposed to php (except for proxying images to allow you to export).
  5. You can export the poem as an image.

I’ve edited Tom’s template a little, the new one:

  • Automatically generated a link to use. Tom got you to copy paste in the sheets own url and parsed that.
  • Adds a field for the image search.

Make a List this link should get you to create a copy of the list spreadsheet. You can edit the words (on the 2nd worksheet) and change the image search,  more info: Fridge Poetry.

Learning

I’ve gained a wee bit more JavaScript and jQuery. The idea of using Google sheets to populate a webpage or to display info from a sheet in a template is interesting. html2canvas is another tool that has interesting potential for storytelling on the web.

Using /copy at the end of a google sheet to allow anyone to make a copy is useful too.

Finally the ability of google sheets to get the id of the current sheet is really handy in simplifying the creation of links. This relies on a very simple script:

function getSheetID() {
  var r = SpreadsheetApp.getActiveSpreadsheet().getId();
return r;

}

you can then get the id by typing =getSheetID() in a cell.

Next

There is more help on how to make and use a wordlist here: Fridge Poetry.

Hopefully someone will find this fun of useful, if you do and create new wordlists please let me know.

NB, I made a bit of a mess of attributing on this post. An apology to @ericcurts Eric Curts |

It is National Poetry Day. When I was in class I always wanted to do something for this, but only occasionally remembered. Although I don’t have a way with words I like working with poetry in the class. I also occasionally like twitter haiku and the like.

I read Tom Woodward’s blog regularly and yesterday I noticed Fridge Poetry – Google Sheets as Database in my RSS reader. Given that I’ve messed about with fridges before 1, I took a look: Google Sheets – Fridge Poetry.

The really interesting thing 2 about this is that Tom has set it up so that it is easy to make another fridge with different sets of words. He even has a link on his post to create a copy of the google spreadsheet to make your own copy (you need a google account, a low entry bar). The sheet itself has the instructions.

Here is one with a selection of words from Scotland small? by Hugh MacDiarmid.

How do you save something like this? Take a screenshot.

What I really love about this idea, besides the sharing of how to do it, it the easy way it can be extended and used with a different set of words.

  1. That was back in 2002 when I was playing with Flash
  2. The other interesting this is the JavaScript and php stuff.