Create QR codes in Google Sheets, Docs, and Slides

ΠŸΠΎΠ΄Π΅Π»ΠΈΡ‚ΡŒΡΡ
HTML-ΠΊΠΎΠ΄
  • ΠžΠΏΡƒΠ±Π»ΠΈΠΊΠΎΠ²Π°Π½ΠΎ: 8 июл 2024
  • 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
  • НаукаНаука

ΠšΠΎΠΌΠΌΠ΅Π½Ρ‚Π°Ρ€ΠΈΠΈ • 7

  • @andredesjardins8256
    @andredesjardins8256 2 мСсяца Π½Π°Π·Π°Π΄

    Thanks you bro very interesting.

  • @isabelsunderland693
    @isabelsunderland693 5 мСсяцСв Π½Π°Π·Π°Π΄

    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
    @derrickswaim1367 ΠœΠ΅ΡΡΡ† Π½Π°Π·Π°Π΄

    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
    @user-wv6py2bt3h 6 мСсяцСв Π½Π°Π·Π°Π΄ +2

    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
      @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
      @gamerzparadise2355 5 мСсяцСв Π½Π°Π·Π°Π΄ +1

      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.