| A | B | C | |
|---|---|---|---|
1 | HOW TO DOWNLOAD IMAGES FROM URL ON GOOGLE SHEETS - Made by One Scales | USE -> =INDEX(SPLIT(INDEX(SPLIT(A3, "/"), 0, COUNTA(SPLIT(A3, "/"))), "?"), 0, 1) | (MAC OS) USE -> ="curl '"&A3&"' -o "&B3 file.sh -> #!/usr/bin/env bash chmod +x file.sh (WINDOWS) USE -> ="curl "&B3&" -o "&A3 file.bat |
2 | URL | Filename | Download |
3 | https://www.google.com/images/branding/googlelogo/2x/googlelogo_light_color_272x92dp.png | googlelogo_light_color_272x92dp.png | curl googlelogo_light_color_272x92dp.png -o https://www.google.com/images/branding/googlelogo/2x/googlelogo_light_color_272x92dp.png |
4 | https://cdn.shopify.com/s/files/1/0698/1274/8583/articles/error-1005.jpg?v=1686941271 | error-1005.jpg | curl error-1005.jpg -o https://cdn.shopify.com/s/files/1/0698/1274/8583/articles/error-1005.jpg?v=1686941271 |
5 | https://cdn.shopify.com/s/files/1/0698/1274/8583/articles/Screenshot_2023-06-18_at_11.11.27_AM.png?v=1687075909 | Screenshot_2023-06-18_at_11.11.27_AM.png | curl Screenshot_2023-06-18_at_11.11.27_AM.png -o https://cdn.shopify.com/s/files/1/0698/1274/8583/articles/Screenshot_2023-06-18_at_11.11.27_AM.png?v=1687075909 |
6 | https://cdn.shopify.com/s/files/1/0698/1274/8583/articles/Screenshot_2023-06-18_at_11.10.02_AM.png?v=1687075811 | Screenshot_2023-06-18_at_11.10.02_AM.png | curl Screenshot_2023-06-18_at_11.10.02_AM.png -o https://cdn.shopify.com/s/files/1/0698/1274/8583/articles/Screenshot_2023-06-18_at_11.10.02_AM.png?v=1687075811 |
7 | https://cdn.shopify.com/s/files/1/0698/1274/8583/articles/Screenshot_2023-06-19_at_12.15.20_PM.png?v=1687166205 | Screenshot_2023-06-19_at_12.15.20_PM.png | curl Screenshot_2023-06-19_at_12.15.20_PM.png -o https://cdn.shopify.com/s/files/1/0698/1274/8583/articles/Screenshot_2023-06-19_at_12.15.20_PM.png?v=1687166205 |
8 | https://cdn.shopify.com/s/files/1/0698/1274/8583/articles/Screenshot_2023-06-19_at_12.23.56_PM.png?v=1687166642 | Screenshot_2023-06-19_at_12.23.56_PM.png | curl Screenshot_2023-06-19_at_12.23.56_PM.png -o https://cdn.shopify.com/s/files/1/0698/1274/8583/articles/Screenshot_2023-06-19_at_12.23.56_PM.png?v=1687166642 |