Google Apps Script Tutorial: Download Multiple Images From URLs In A Spreadsheet

A viewer sent me a comment that they have a Google Form that asks for an image upload. But rather than showing the image, the Google Sheet shows the URL of the image. In this video I show two methods of downloading the image from the URL in their Google Sheet.

Method 1 downloads the image into a cell in their Google Sheet.

Method 2 download the image into a designated folder in their Google Drive.

WANT TO SAVE MONEY USING GOOGLE WORKSPACES?

Business Starter Promotion LCWXMA4CWAEM6XN
Business Standard Promotion P7Y7AMGTQ64KP3V

[m.gloriaramos]

Hi. I found the answer in a previous reply and its working great. I cannot thank you enough for the amount of time this has saved me. Thank

[HazemAlfarra-wrec]

Awesome code, thank you. After you have downloaded the pictures to a Drive folder, can you please develop the code and show us how to insert the new Drive link of the picture in a different column?

[LucasPateCreative]

This has absolutely saved me hours and hours of work. I sincerely appreciate this very thorough tutorial and code.

[TheCoolmuslim]

This was very useful can I ask if we can add new coloumn with the a shareable google drive link for the newly downloaded images? And THANK YOU very much for this helpful tutorial 🙏🏻

[faitheyates]

Hello! This was majorly helpful!
So my question is: If the link stops working will the image in the cell still be there OR should I essentially replace the link with a link of a downloaded image in google drive?

[afcopg]

This saved us an incredible amount of time. Thank you, Joseph!

[sikamoreify]

Thanks Joseph. This was incredibly helpful, clear, and consise. Much appreciated!

[randibagley]

Absolute I can't believe you can just type the code and it works like a charm. Thank you so much, made my job way easier today.

[nikhammarberg]

I'd love to be able to rename the downloaded image files based on data in another column - to expand on your example, rename them as partnumber_01, partnumber_02... .jpg/png etc.

[Johnessy]

This video was amazing! How do you change the file name? For instance I would love to add 2 Cells as the name like 223234 - This was the best So i can sort based on number?

[TomWien]

What a great Channel/Teacher!!!
Sir, I hope you had a nice summer or even still have one ☺️
I am fascinated about the way you teach and even more about your response to comments.

May I kindly "hop in" to this topic? 😇

Is there any chance to to show us, how to render those pics to a published web-app?
Whatever I try as a "noob" to show those pics from a spreadsheet in an web-app " fails. :(((

[pikesway]

This is perfect. Thank you! I do have another question about using url images but with google slides. Can I create a new slide per row of data and save the images from the url to a slide image placeholder (using the same shape as the placeholder, meaning circle or some mask). Is this doable?

[lahnahar]

Hello! Thank you! It works. However, the images I’ve downloaded are in html format. Can you explain what possibly could be the reason?

[kishoarwasifchowdhury]

you're a freaking life-saver!!! A LIFE-SAVER!!!!

[SecondSetMaze]

This video has been a huge help and you are a wonderful teacher! I am using method 2 but my source sheet has many rows where the url field is empty. The script stops at an empty cell. How do I tell script to ignore empty cells in the url column? Many thanks!

[iBomb]

Woah, thanks Joseph! Great video, simple and easy to understand. 💪😸

[tuyoiushi]

Thanks, bro. You just solved my problem by just casting a spell like a wizard...

btw, is there any way to tell the script skip blank cells rather than reporting an error?
I saw you answered the 404 one, that helps also.
Anyways, thanks for your great help!

[varundev]

hello sir
can i also download Images from google drive link with are in Google excel sheet

[bumpersmith]

This is very helpful and explained in a very clear way as all of your videos.
Can you show the same technique instead of a URL address, using a file address on a windows 10 computer?

[thefish]

Hi, this is a really great video, but can you download images into sorted folders? For example I want some of my images to de downloaded into a folder named "1" and then have some images download into a folder named "2" and so on?