Generating QR Codes in Google Sheets

I'm a full-stack developer from South Africa 🇿🇦. I love writing about JavaScript, HTML and CSS.
Search for a command to run...

I'm a full-stack developer from South Africa 🇿🇦. I love writing about JavaScript, HTML and CSS.
Most of you know me for my consistency, a golden arrow in my blog series. I've written 1000 articles in 1008 days! Almost an article a day, and my honeymoon was the only holiday I ever took. I'm super proud of this achievement; it has been a fantasti...

It's not the first time I'll be talking about community. I think it's an essential aspect of any successful tool. This shows in my previous explorations of Astro, Medusa, and now Vendure as well. All these products thrive in a super open, welcoming, ...

The cool part about Vendure is how easy it is to set up and how abstract each layer is. Basically, we get the following elements: External database Server Worker Admin UI Frontend While this is amazing, it also brings a bit of complexity when it co...

The previous article looked at customizing Vendure on a data and process level. In this article, we'll look at customizing emails, as they are often a big part of a webshop system. We'll be looking at two different layers of customization for customi...

Even though Vendure is a pretty significant project out of the box, in some cases, we might want to go in and modify some elements to work to our specific use case. In this article, I'll take a high-level look at some elements we can customize within...

Being a developer comes down to using the right tool for the right job. And sometimes, it can be a Google sheet or Excel sheet that can automate a simple task for you.
Have you ever needed to generate QR codes from a whole list of URL's for instance?
Well, Google has your back on that. Today we'll be using Google Sheets and Google Charts to generate QR Codes!

Google Charts is an amazing tool that can generate several types of charts for us. One of the charts we can generate is a QR code.
The benefit of this is that we get a dynamic endpoint where we can change the encoded QR element to be something variable.
Read more on the Google Chart QR Code
If you are following along with my article, this is the end URL we will be using.
https://chart.googleapis.com/chart?chs=200x200&cht=qr&chl=https://daily-dev-tips.com
Where the variables we use are:
chs: Chart size, we defined a 200x200 squarecht: Chart type, in our case QRchl: This is the data we want to encodeIf we use that URL as an image, we get the following result.
Now that we know about creating QR codes let's put this into action as we generate them dynamically in Google Sheets.
Open up a new Google Sheets and fill out column A with random websites.
Then in column B, we will add the following formula.
=IMAGE("https://chart.googleapis.com/chart?chs=200x200&cht=qr&chl="&A1&"")
Then we can drag this formula down to the other cells!
Make the rows a bit bigger so you can see the image correctly. And that's it we now have a dynamic QR generator in Google Sheets.
You can view the Google QR Sheet here.
Thank you for reading my blog. Feel free to subscribe to my email newsletter and connect on Facebook or Twitter