Wednesday, June 20, 2012

Client-side Blowfish Encryption Gadget

This gadget encapsulates the javascript encryption routine detailed here. I built it to use in Google spreadsheets as a replacement for the encryption function detailed here.  I had some reservations about that function since values are put into a cell first and then potentially saved via an AJAX call before they could be encrypted.    With this gadget, all encryption takes place client side and then it can be put into the cell.

Using the gadget is simple enough. A default key is automatically entered. Change it to a new key. Click "Set Key". Paste the text that is to be encrypted into the first text area. Click "Encode". The encrypted text will appear in the next textarea.

To decrypt text, set the proper key and post the encrypted text into the the middle textarea. Click "Decode".

To install the gadget do that following:
  1. Open the desired spreadsheet.
  2. Click "Insert" on the documents menu and then click "Gadget" from the drop down box.
  3. A dialogue box will open.
  4. Click "Custom".
  5. Paste the url into the text box labelled "URL of your own gadget".
  6. Click "Add".
  7. Click "Apply & close" on the setting dialogue box.
  8. The gadget should appear.


  1. Been using the old one for some time, appreciate it, it has worked well. But there is no "gadget" in the drop down box. Where should I go? Thanks.

  2. I also do not have a Gadget in the insert drop down box. Are you talking Google Apps i.s.o. Google Docs Spreadsheet?

  3. The gadget functionality has been deprecated and eventually removed: