How to convert URLs to small images within a cell

Hello,

Long story short at least 2-3 per week I have to convert thousands of URLs to images to send to customers/vendors so they could see the item in the sheet. I'm looking to see if I could automate this process with a formula/script.

I've tried googling solutions, and the ones I’ve found do the job. However, I then run into a separate issue where the file becomes too large to send via email so I revert back to doing it manually.