This popped in my recommendations when I just needed it! Thanks, dude!

I find this tutorial too useful. I suggest a second part where you can show us the usefulness of this powerful tool. Thank you, teacher.

A very clear tutorial!! Thanks!

Thanks a lot. Very good method of generating qr codes in larger quantities.

Man, this video is really awesome!! Very handy! Will be nice to see more, how can I say, integrations (?!?) like this one. Thank you!

Nice demo, thanks, really enjoying your videos! Have you ever thought of doing a google sheets/script for implementing a bot for MediaWiki servers? I can think of some cool applications for being able to script updates to a wiki page for example.

Excellent as always, very useful

You are awesome, I am really grateful for your all videos.

Using array formula will be awesome..Thanks Ben Collins

Thank you very much !!!

superb teacher..thanks a lot !

Thank you very much for making a video on generating the bulk QR code in a single go. The video is simple with minimum steps. Will you please let me know whether there is any provision to add two/three/four columns instead of one. If yes, will you post the formula here?

Very good video. Kindly make a video on How to Scan Barcode or QR Code and send it back to Google Sheets for real time updates. Also guide how to generate a QR code in sheets having a picture inside it.

Always good info from you - thanks. Q1: The new-ish 'insert > image in cell' function is more useful (as can take our own google images instead of .jpg links) but is there a way to code it rather than using mouse clicks? (next video...? ;) And could it then be put into an array formula to read addresses from one column and automatically insert images into another column? thanks again :)

Love your videos and I highly recommend them ! :) I was wondering if there is a way or how would I go about making a chrome extension that saves data on google sheets?? I already know how to make extensions and store with local storage chrome API (chrome.storage.local.set). I just don't know how I would go about linking the chrome local storage into a spread sheet ?

Great video. Is there anyway we can generate an image directly within a custom function using app script without the need of an external server service and return it as an image object just like image() does? Or perhaps there may be some javascript that can be called upon to generate the image with in the app script? (The reason behind this is that Google Chart function really need a lot of improvement)

Dude you are absolutely amazing. I feel like writing a whole paragraph about how you helped me solve most of my problems but there's no point in that. Thanks man.

Thank you for your tutorials, it really helped me a lot. Please if you're looking for requests can you make a tutorial on how i can scan QR codes and encodes to google sheet. TIA

thank you

👍👍👍

it works ty - Hans

Hi! Good Video. Time ago, you could do this work using Google Api Chart, but no more... It's deprecated.

Hello sir ive trying your json Google sheet tutorial with google book api but it doesn't work it returns undefined because the json is complicated can u do a tutorial about that please please

Great tutorial!, Thanks. How do you export those QR codes as images, ideally named after the value of one of the cells..

Waiting for your video

Thanks bro!!

@jowhr99

3 жыл бұрын

image function doesn't work with me

Can you also tell us how to download the qr codes that have been generated using these formulas?

Thank you very much for this very informative video. But how do I save the images into my disk?

@ExcelGoogleSheets

4 жыл бұрын

I have an upcoming video for those who need actual image files. Should be live on the channel next week.

@mastatekniks2653

4 жыл бұрын

@@ExcelGoogleSheets Great! Thanks a ton. I will tune in for that definitely.

How can I send email with attachment img code?

Parcipate photo including add print certificate please tell me sir

I'm wondering if it would be possible to add control characters like Tab and Enter with this method. Regular escape sequences like \t and don't work. I also tried ~d009 and ~d013 without success. By the way... I'm a fan of your channel. Thanks for sharing these amazing classes.

@ExcelGoogleSheets

3 жыл бұрын

I'm not sure I understand. What are you trying to escape?

@nerearita

2 жыл бұрын

cell values: &ENCODEURL(A3) spaces blanks between words: &"%20" line breaks between sentences: &"%0A" values ​​written manually in the function: &"Text"

@luciolibanori

2 жыл бұрын

@@nerearita That works!!!! Thank you so much for your help.

@nerearita

2 жыл бұрын

@@luciolibanori Glad I was able to help: D

how to copy the qr code image to another spreadsheet?

How would I estimate cost to generate one qr code with API

what if I use TEXT in column A instead of URL, how to adjust the formula ? many thanks for your help

@ExcelGoogleSheets

4 жыл бұрын

Same should work, no?

how can link a image file location with a fixed QR code...so if the image is chnaged...Scan result should show new image....any idea how to do

Can I download those images (QR Codes) as separate Image files ? Can those images (QR Codes image files) have the respective name from which they are generated ?

@ExcelGoogleSheets

4 жыл бұрын

Use node kzread.info/dash/bejne/h55-tax6fcaqZJc.html

How to add two or more column data like A3 A4 etc?

@nerearita

2 жыл бұрын

&ENCODEURL(A3)&ENCODEURL(A4) spaces blanks between words: &"%20" line breaks between sentences: &"%0A" values ​​written manually in the function: &"Text"

Thanks for a very useful tip. However I am failing to transfer it to Docs and then to a pdf document. I am using Google App Script to work in a spreadsheet and make a pdf from the information. I am trying to make a qr code with that information. I tried to to do a copy paste special too. I also tried to paste it in slides. Please help me.

@ExcelGoogleSheets

2 жыл бұрын

You'll need to add the image directly to your Doc. Something like. const blob = UrlFetchApp.fetch("imgasite.com/locnameofimage.png").getBlob() const cursor = doc.getCursor() cursor.insertInlineImage(blob);

@ManojGuptahome

2 жыл бұрын

@@ExcelGoogleSheets Thank you very much. I cant open the link, however I have a hint and I will try to do it.

where is or code link

what if you don't have a url but you just want text could that work?

@ExcelGoogleSheets

2 жыл бұрын

Yes

What about the Google QR Code API?

@ExcelGoogleSheets

4 жыл бұрын

It's being discontinued.

How can I add additional information to the qr code so my google app scripts can grab the data from the URL ? I want the link to be https.....data=url/helloworld/. How do I add "helloworld" to the qr code link and then later grab it from Google app scripts? Your videos have been immense help. Thanks!

@nerearita

2 жыл бұрын

&"helloworld"

it didn't generate an image for me, everything is okay but in vain