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 you!!!!!
@LucasPateCreative
Жыл бұрын
This has absolutely saved me hours and hours of work. I sincerely appreciate this very thorough tutorial and code.
@jsphpalumbo
Жыл бұрын
Glad it helped!
@afcopg4285
4 ай бұрын
This saved us an incredible amount of time. Thank you, Joseph!
@randibagley
8 ай бұрын
Absolute legend!!!!!!!!!!!!!!!!!!!!!!!!!! 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.
@jsphpalumbo
8 ай бұрын
Glad I could help! And I've had a lot practice writing code for Apps Script, so not as impressive as you might think ;)
@kishoarwasifchowdhury4839
4 ай бұрын
you're a freaking life-saver!!! A LIFE-SAVER!!!!
@sikamoreify
Жыл бұрын
Thanks Joseph. This was incredibly helpful, clear, and consise. Much appreciated!
@MK-jn9uu
3 ай бұрын
OMG IT WORKED!!! Thank you! ♥♥
@HazemAlfarra-wr7ec
Жыл бұрын
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?
@faitheyates1396
2 жыл бұрын
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?
@TheCoolmuslim
2 жыл бұрын
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 🙏🏻
@iBomb24
Жыл бұрын
Woah, thanks Joseph! Great video, simple and easy to understand. 💪😸
@nikhammarberg
4 ай бұрын
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.
@ZeeJayFilms
Жыл бұрын
Is it possible In the mean time when the photo is being downloaded IT ALSO RENAME THE IMAGES WITH CUSTOM NAMES. For example cell A1 ==> "CUSTOM NAME" cell B2==> "IMAGE URL" when I run the download script the image will be downloaded with the renamed text which was listed in A1. Please Help me
@boper9116
Жыл бұрын
Thanks for the video! I am getting TypeError: folder.createFile is not a function. Not sure what is happening?
@JonDellosa
3 ай бұрын
can you set images' file name on download with corresponding cell in the sheet?
@lahnahar
4 ай бұрын
Hello! Thank you! It works. However, the images I’ve downloaded are in html format. Can you explain what possibly could be the reason?
@m.gloriaramos354
7 күн бұрын
I tried this script and the images downloaded to the spreadsheet without issue. When I ran the download image script, they all saved as untitled.jpeg. How can I fix it so they have unique file names???
@pikesway
2 ай бұрын
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?
@varundev2866
Жыл бұрын
hello sir can i also download Images from google drive link with are in Google excel sheet
@mxtw7910
7 ай бұрын
Brilliant work, thanks!
@travisabernathy7955
2 жыл бұрын
Getting "Error retrieving image from URL or bad URL" when I try to retrieve images from a google drive folder. I have a form that automatically saves images in a google drive folder but when i use the drive link to the image, I keep getting this error. Anyone else having this problem?
@assitantrevenueofficerjawa4052
Жыл бұрын
i have also same problem has your issue resolved??????
@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?
@theproductivemanager
Жыл бұрын
Thank you so much!! This was super helpful 🙏😊
@jsphpalumbo
Жыл бұрын
You're so welcome!
@about9Aa
2 жыл бұрын
Thank you Sir. This is very helpful
@thefish7872
8 ай бұрын
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?
@fevziyenurylmaz9389
2 жыл бұрын
How can we give the downloaded file a specific name from a column?
@AndrePiazza
Жыл бұрын
Place the name on the third column and replace the loop code for this: for (let i = 0; i < lastRow-1; i++) { let url = sheet.getRange(2+i,1).getValue(); let name = sheet.getRange(2+i,3).getValue(); let blob = UrlFetchApp.fetch(url).getBlob(); folder.createFile(blob).setName(name); }
@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!
@jsphpalumbo
Жыл бұрын
Hi there, glad this tutorial was helpful. To prevent your script from stopping on blank cells, I would add an IF statement that says something like if ( cellValue != "") { Do Something}. This will allow your script to skip over any blank cells without stopping.
@SecondSetMaze
Жыл бұрын
Thanks and I have it working@@jsphpalumbo but the sheet is over a thousand rows and taking longer to finish than the 6 min allotment of time. So that's what I am working on now. Thanks again for your help and expertise!
@jordanbouerat9981
11 ай бұрын
@@jsphpalumbo Hello, I would like to implement this function, but where exactly should I put it? Here's what I did but it doesn't work. function insertImage() { let sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(); let lastRow = sheet.getLastRow(); for (i = 0; i < lastRow-1; i++) { let url = sheet.getRange(2+i,1).getValue(); let image = SpreadsheetApp.newCellImage().setSourceUrl(url); sheet.getRange(2+i,2).setValue(image); } } function downloadImage() { let sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(); let lastRow = sheet.getLastRow(); let folder = DriveApp.getFolderById("1W4pv0RW7DB_yh8pqChc8YPNyq0ETQ_1m"); for (i = 0; i < lastRow-1; i++) { let url = sheet.getRange(2+i,1).getValue(); let name = sheet.getRange(2+i,3).getValue(); let blob = UrlFetchApp.fetch(url).getBlob(); folder.createFile(blob).setName(name); if (cellValue != "") Do something; } } Can you help me ?
@jordanbouerat9981
11 ай бұрын
Hello Joseph Can you help me ? I really need to make the script work even when there is an empty cell. Thanks a lot for your help !
@fabiolando8714
Жыл бұрын
Amazing perfect saved loads of time.
@jsphpalumbo
Жыл бұрын
Glad this was useful!!
@TomWien
2 жыл бұрын
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. :(((
@jsphpalumbo
2 жыл бұрын
Hi Thomas, thanks for the kind words. And I'm always happy to help solve problems. Can you give me a little more information as to what kind of web app you want to publish to?
@TomWien
2 жыл бұрын
@@jsphpalumbo good afternoon, thx for your kind response and sorry for my delay (struggled a bit due to COVID) Well, my main target is to display/render a image. My cause I want to "create" a CRUD App for my garden. Nothing commercial!!! I want to keep track, what I did, when to fertilize again, etc.... Therefore i would "implement" pictures/images which would be stored in a different folder at my Google drive. A little hint/snippet how to render those pics would be nice. Imagine a spreadsheet like this: Id - name - description - pic - Link (where the image is stored) Who to render those in a list or even a "card"(Grid)?
@gregbetts1672
11 ай бұрын
Great video, followed along, copied the code, and I get a getactivesheet error stopping the script immediately. Do I need to grant access to the sheet?
@QuyPham-l5p
Жыл бұрын
Awesome code, thank u. I want to ask u for another way to one click for download all pictures 🤔
@hazemalfarra
Жыл бұрын
Hello Joseph, after you have downloaded the pictures to a Drive folder, can you show us how to insert the new Drive link of the picture in a different column?
@fatikchandradas9059
Жыл бұрын
Very nice video. Please help > google sheet text & image link data multiple invoice/marksheets/student result/others create pdf file.
@JacquieShetter
Жыл бұрын
i am trying to do this for videos but when it downloads to my folder it shows as view.html or edit.html depending on what i have past the code. When I remove view or edit it still does the same. Any help here?
@calmcottage6743
Жыл бұрын
problem solved , thanks
@H2OnlineShopBD
Жыл бұрын
Error TypeError: Cannot read properties of null (reading 'getActiveSheet') how to fix this..?
@techyminion4605
Жыл бұрын
Hi, I am getting just open.html instead of every image. Please help.
@afrosoul4eva
Жыл бұрын
Wow... this was very helpful
@jsphpalumbo
Жыл бұрын
Glad you think so!
@bumpersmith
2 жыл бұрын
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?
@jsphpalumbo
2 жыл бұрын
Hi Garry, thanks for the comment. I've never done that before, but let me dig into that for you. Stay tuned.
@surspiri07
Жыл бұрын
@joseph, please help Getting "Error retrieving image from URL or bad URL" when I try to retrieve images from a google drive folder. Link i'm using int sheets is a dropBox link
@danielmachuca6507
5 ай бұрын
can u add to downlowd to multiple folders
@danielmachuca6507
5 ай бұрын
i have the column A with some codes and need to download the pictures into the folder with the code name
@NOUARIMOHAMED
2 жыл бұрын
Thank you for all your tutorials. Can you please show us how to download the images to our laptop. Thank you
@sookiemiller9017
Жыл бұрын
After following the second half of the tutorial, you can just download the google drive folder onto your computer
@BrijeshKumar-ev4bg
Жыл бұрын
Its work Thank you sir
@about9Aa
2 жыл бұрын
Hello Please help me, in function download image , how can i auto rename the files
@AndrePiazza
Жыл бұрын
Place the name on the third column and replace the loop code for this: for (let i = 0; i < lastRow-1; i++) { let url = sheet.getRange(2+i,1).getValue(); let name = sheet.getRange(2+i,3).getValue(); let blob = UrlFetchApp.fetch(url).getBlob(); folder.createFile(blob).setName(name); }
@franciscotecocoatzi9128
Жыл бұрын
@@AndrePiazza THANKS BRO!
@GVLakerSam
2 жыл бұрын
Hi, Joseph, this is great! Do you know of a way to then take the images that have been pulled into the cell and have them inserted into a google docs template using tags?
@mereyustaad
Жыл бұрын
check this kzitem.info/news/bejne/uqKa2513n5qZeoY will help you
@onuronal2876
Жыл бұрын
Hello, when I try to run the code I get an error message saying "TypeError: Cannot read property 'getLastRow' of null." How can I solve this issue? Thanks.
@sookiemiller9017
Жыл бұрын
I keep getting this too:/
@LeonidRudnitsky-r3s
Жыл бұрын
I think I'm doing something wrong, it's not working :(
@jeetuagr
Жыл бұрын
Joseph - How can we give the downloaded file a specific name from a column?
@AndrePiazza
Жыл бұрын
Place the name on the third column and replace the loop code for this: for (let i = 0; i < lastRow-1; i++) { let url = sheet.getRange(2+i,1).getValue(); let name = sheet.getRange(2+i,3).getValue(); let blob = UrlFetchApp.fetch(url).getBlob(); folder.createFile(blob).setName(name); }
@nishanpriyadarshana4130
Жыл бұрын
This is really helpful. I have encountered an error in line 3 (Code.gs:3) which says that paranthesis after getactivespreadsheet as null. Do you have any solution for this?
@jsphpalumbo
Жыл бұрын
Hi Nishan, my first guess is that you're not calling the spreadsheet correctly. To grab the active spreadsheet should look like this let ss = SpreadsheetApp.getActiveSpreadsheet();
@alonsovindas9411
Жыл бұрын
Hi, Joseph. Thanks a lot, this video is great. I was wondering if you could add a few things, I have this column with links, that now with your video i can download, but, I want to download each of them in to different folders and with specific names, let said we have three columns: the image links, the folder name and the image name I need for each image. Is that possible? Im sure is not a problem for you! Thanks in advance!
@AndrePiazza
Жыл бұрын
Place the name on the third column and replace the loop code for this: for (let i = 0; i < lastRow-1; i++) { let url = sheet.getRange(2+i,1).getValue(); let name = sheet.getRange(2+i,3).getValue(); let blob = UrlFetchApp.fetch(url).getBlob(); folder.createFile(blob).setName(name); }
@sujitsaha1985
2 жыл бұрын
can you make a video for how to get data from gmail inbox to Google sheet.
@jsphpalumbo
2 жыл бұрын
Hi Sujit. I can definitely make that video. What kind of data do you want to pull into a sheet?
@ConsulthinkProgrammer
2 жыл бұрын
Nice :)
@jsphpalumbo
2 жыл бұрын
Thanks!
@messem78
2 жыл бұрын
Thank you for this usefull script ! Is there a way to make the script continue even if some URL return 404 ?
@jsphpalumbo
2 жыл бұрын
Hi Joachim, and thank you for your question. Yes, you can can set muteHttpExceptions to TRUE in the HTTP request to suppress these errors. It should look like this: ``` var response = UrlFetchApp.fetch("yourdomain.com/404", {muteHttpExceptions: true}); if ( response.getResponseCode() == 404 ) { Logger.log("Webpage not found"); ``` Let me know if that helps.
@fowas.p.a.9194
10 ай бұрын
This has absolutely saved me hours and hours of work! thank you so much! But i have a question.. My google sheet contains more than 3000 images. How can i eliminate the runtime error of 6 minutes? much appreciated.
@jsphpalumbo
10 ай бұрын
This is a tough one. There are 3 things you can do: 1. Refactor your code to run more efficiently by optimizing the code to run within 6 minutes. 2. Convert your script to run as a batch operation, where the script's process is spread out over multiple executions, where the time slice for each execution is under the 6 minute limit. Time-based triggers should help with this. 3. Offload the time-intensive parts of the process to a 3rd party service; and have your script call out to it with the appropriate parameters.
@ZeeJayFilms
Жыл бұрын
Is it possible In the mean time when the photo is being downloaded IT ALSO RENAME THE IMAGES WITH CUSTOM NAMES. For example cell A1 ==> "CUSTOM NAME" cell B2==> "IMAGE URL" when I run the download script the image will be downloaded with the renamed text which was listed in A1. Please Help me
@mereyustaad
Жыл бұрын
kzitem.info/news/bejne/1a9typlsZmideqA this will solve your prblm
@hargeart
7 ай бұрын
Thank you sir! I need to add a script that i want. i would like to see shared google drive urls in the third columbs for each downloaded images. can you describe?
@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!
@harishsekar4315
Жыл бұрын
how to adding an image in a cell of google sheet and display it in website by search engine via app script??????????? pls make a video for it
Пікірлер: 88