Google Scripting + QR Codes = Awesomeness

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:

=image(“http://chart.apis.google.com/chart?chs=150×150&cht=qr&chl=Name%3A%20″&A2&”%20″&B2&”%20DOB%3A%20″&C2&”%20Notes%3A%20″&D2&””)

 

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

 

TJ Houston

Hey everyone, My name is TJ and I am here to help you! I am a lifelong learner that strives to help others. Work: By day I work for Panasonic as the Sales Support Rep for the Midwest Region. Play: I love all things photography, videography, and tech! Home: I have a loving wife (Ashley) and an adorable German shepherd (Jynx) You can find me on twitter @tjhouston on instagram @tjshotsphotography or if you want to see some of my professional photography work check out tjshots.com. All of the views on this site are my own and do not reflect my employers.

  • Just great! Next challenge will be to get the QR code as an image into the PDF document.
    Your RSS feed is on top in my reader;-)