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.

2 thoughts on “Frozen Words

Mentions

  • Aaron Davis

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

To respond on your own website, enter the URL of your response which should contain a link to this post's permalink URL. Your response will then appear (possibly after moderation) on this page. Want to update or remove your response? Update or delete your post and re-enter your post's URL again. (Learn More)