How to beautifully insert working links to an image in a Google spreadsheet?

Question

Google Sheets

How to insert links to images so as not to upload them via Google Drive each separately? The file is large and it will take more than one day to download all the photos and then insert them into the desired cell. I am attaching a spreadsheet link for clarity https://docs.google.com/spreadsheets/d/1rDn8OdIBVX...

Answer 1

import csv with URLs to images
convert URL to IMAGE according to the formula from here
https://support.google.com/docs/thread/8108818/she...