Google-sheets – Linking a photograph to the Google Sheets or a link to the Google Drive

I am building a catalog of products for our business, I would like to have an option where as you roll over the item a photo of the product will appear, in the same way 'add note' works but with a picture instead of just writing.

I understand how to add links to websites of similar things, but none of which are quite right or what I want. I also know how to add a photo, but I don't want them on all the time, just when you scroll past it or click on it.

I can add a link from my Google Drive but it results in having to click on it and opening another webpage, I was hoping to just have it as a pop up but if that's all I can do I will have to live with it.

I think maybe its a really simple solution that I am just either missing or haven't worked out yet but any pointers would be a great help.