SEO Tool with Excel is not download the image

Support
#1

Dear Team,

Thanks for your tool.

I tried this tool to Download the Image linked in Google Drive. The function is running without error. but the image file is not downloading.

DownloadFile(B2,"D:\Photos",F2)

Can you Please help me to clear this.

#2

Sample Link...

https://drive.google.com/file/d/11R-FQv-3jSq5IxkfZUNDmROFGquoUcrA/view?usp=drive_link
https://drive.google.com/file/d/1fTrteH9C1Wfi8gekrtEReQNCrVWIukqo/view?usp=drive_link
https://drive.google.com/file/d/1qBNtdtv_SzNnZi64ksAHydGDyYsSFG_J/view?usp=drive_link
https://drive.google.com/file/d/11e1GEaAFlpSuRgB-QylkMp_CPyFDDnIS/view?usp=drive_link

#3

The Google Drive links you supplied are not links to the images directly, that's why you can't download. A solution is to extract the link id, then create a new url with this syntax:
https://drive.google.com/uc?id=

Here is the guide I used:
https://www.labnol.org/google-drive-image-hosting-220515

formula to extract id:
=RegexpFind(B1;"\/d\/(.*?)\/";1)

Formula to create new URL:
="https://drive.google.com/uc?id=" & C1