Insert local server images to table auto-updated from Google Sheets

Hello Brains Trust,
I have a table that utilises the TablePress AutoImport from a Google Sheet.

I have rummaged through the forum and have learned you can’t import images through Google Sheets, and I have tried adding the url of the image (in the media gallery on my website) but it simply treats the hyperlink as text and displays that (I might try adding html code but suspect that will get treated as text too with “”).

I also tried manually adding the images to the cells I’d like them, but they get overwritten by the AutoImport.

Is there any way of ‘locking’ cells so the AutoImport appends around those locked cells?

Or would importing the table in a different format achieve what I am aiming to do?

Can CSS code help modify the “” text to the hyperlink and display the image?

Thank you!

The page I need help with: [log in to see the link]

 

This site will teach you how to build a WordPress website for beginners. We will cover everything from installing WordPress to adding pages, posts, and images to your site. You will learn how to customize your site with themes and plugins, as well as how to market your site online.

Buy WordPress Transfer