Create QR codes in Google Sheets, Docs, and Slides

Рет қаралды 8,158

Күн бұрын

Learn how to create QR Codes in Google Sheets using simple formulas. We'll use this technique to build a simple wedding invitation linked to a Google Form using the QR code we build.
In this video, we'll also learn how to transfer the QR codes into Docs and Slides (because unfortunately, a simple copy-paste won't do it).
📚 Grab the TEMPLATE for this video from the QR Resource on my website:
www.benlcollins.com/spreadshe...
✉️ Sign up for my free, weekly Google Sheets Tips Newsletter:
www.benlcollins.com/google-sh...
#googlesheets #googlesheetstutorial #spreadsheet #qrcode #qrcodes

Пікірлер: 9

@denidosh 2 күн бұрын

Thank you so much for such useful video!

@MateoLeibowitz- 10 күн бұрын

Thank you! is there any way to export the image?

@andredesjardins8256 2 ай бұрын

Thanks you bro very interesting.

@isabelsunderland693 6 ай бұрын

Hi, would you have any recommendations for bulk importing QR codes into Google slides? I want to generate about 900 QR codes to put on a name tag template I made in Google slides. So I've used a data merge extension to merge 900 names onto each page of a 8.5x11 sized google slideshow. Each slide has the info for 6 name tags and I'd like each name tag to have a QR code that's unique to the name. Is it possible to get 9 QR codes per 1 slide imported automatically for 900 QR codes?

@derrickswaim1367 2 ай бұрын

I need to be able to have a script save the images to a drive folder. The images need to be named from another cell. Any direction on that?

@user-wv6py2bt3h 6 ай бұрын

Hi, after disabling the previous Google Charts API, I'm also facing an issue with automatic QR code generation. The QR Code API you provided works well, but it doesn't always generate codes. I have a file where I generate around 800 codes at once, and in 50 cases, the generator doesn't return an image with the QR code. Could you recommend another QR code generation API service?

@benlcollins 6 ай бұрын

I haven't worked with QR codes at that scale so I don't have alternative recommendations at the moment. But if I discover anything, I'll post an update here.

@gamerzparadise2355 5 ай бұрын

You might have to create a VBA macro and call an external script written in PowerShell or Python to do what you want. Both language's do have modules for creating QR Codes. I have used both PS and Python to create QR codes from script files but not from VBA yet. I might look into this in the near future, I got a project I could use this in.