Global Constant
Steve Nay's ramblings

The beginnings of a Google Docs spreadsheet KRL module

KRL modules are just too much fun. I’ve written the basics of one for reading and writing to Google Docs spreadsheets. It’s based heavily on an example by Sam Curren. There are two things that you must do to use the app:

  • Publish the spreadsheet. This is one of the options under the “Share” button in the upper-right corner of Google Docs. This will make the data accessible for read operations.
  • Create a form and make it active. This is under the “Form” menu, and it allows the module to write new rows into the spreadsheet.

Find information about this module in the new Kynetx module listing.

The current version (still in its infancy) only supports writing one field with the submitsingle action. Eventually you’ll be able to pass an array of values and have those submitted, but I’m not there yet. In addition, that is the only way to write to the spreadsheet. You can’t, for example, update a cell. Yet.

I’d like to make this work with non-public spreadsheets, but those details get a little hairy, since authentication is involved. All in good time.