To include a QR Code in a Sheet, we usually use an image. The process gets tedious if we want to generate dynamic QR Code as the values in our sheets change.
Hence, I have created a simple REST service which takes in the text and outputs a QR Image. By updating the text, the QR Image gets updated.
Source https://github.com/seeya/TextToQr
Sheets Integration
Using the =IMAGE formula we set the REST api endpoint and pass in the text we want. In the example below, we take the value from A1 . The image in B1 is generated from the REST service with the contents of A1.
=IMAGE("https://texttoqr.herokuapp.com/?text="&ENCODEURL(A1), 1)Service Hosting
Heroku provides a free tier and it’s more than enough for a simple service like this. All you need to do is to clone my github repository and import it in heroku. Then update the url to your own and you’re good.
