here is failsafe way to use images in google sheets
put images in a shared folder on google drive
right click images - & get sharable link
paste that link into cell - in example below column F5:F8
formula to put image in cell can be a single cell - or array formula in B5
for single image
=If(F5="",,Image("http://drive.google.com/uc?export=view&id="&mid(F5,34,33),2))
an arrayformula for a column of images
=Arrayformula(If(F5:F8="",,Image("http://drive.google.com/uc?export=view&id="&mid(F5:F8,34,33),2)))