Google Scripting + QR Codes = Awesomeness

June 25, 2013

Todays post came from a comment from a reader who asked about inserting QR codes into Google Spreadsheets. There are a few things that this can be used for such as ticketing for an event, etc. Its not exactly what the reader asked for but its a step in the right direction. Screen Shot 2013-06-24 at 3.12.35 PM

Below you will see the end result of what we are doing:

Screen Shot 2013-06-24 at 3.13.23 PM

So after some time playing with the URL and encoding (reference here: http://www.w3schools.com/tags/ref_urlencode.asp) I found that I could bring in values from different columns and insert them into a QR code.


All we are doing in our cell is using the =image formula and making a call to the chart API (https://developers.google.com/chart/ )


Here is an example of what we are doing:

Api Call:



You can find the example spreadsheet here: https://docs.google.com/spreadsheet/ccc?key=0At-tnrDq1KRmdGdISXZrZ0dHQW9fMlRQNmxaNXdmMVE&usp=sharing