Hello redrazormedia.

Thank you for your purchase.

I was able to create a table using the link provided, however, it inserted only the first column because you're missing column headers.

I used the IMPORTRANGE function you added to one of my Google Spreadsheet tables, and added column names from A - G, and it inserted all of them, but unfortunately it failed to import those images you inserted in those cells.

My guess is that it's being disregarded, because it is not formatted as an image column. So, you'd have to create a table by importing data from Google Spreadsheet (once you add column headers), and then make those columns' types be "Image" and manually insert images in cells.

This is one of the limitations when working with Google Spreadsheets, and we are sorry for any inconvenience it may cause.

Best regards.

Hello redrazormedia.

In order to use those images in wpDataTables, they have to be configured either as Image type columns, or string columns, and have the correct values in cells, but Google Spreadsheet's formula:

=image("url-link-to-the-image", 1)

cannot be recognized in wpDataTables. That's why the images are not being shown.

You can take a look at our documentation to see how you can make image column.

And here is the live example of the image column in spreadsheet:

https://docs.google.com/spreadsheets/d/1w_W43gUB435xw9wFWsQ-CHYMZXCn5e3P0Uvo77FD_nU/edit#gid=0

You can paste this link when you create a new table linked to Google Spreadsheets, and change the "Image" column's type to "Image" under settings/data of that column (alternately, you can also change the "text" column's type to URL Link, if you wish to see how that's being generated).

An example of what the cell content looks like for an image column in Google Spreadsheets is:

https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcQDA4Jhlt2TGWKs8hSYa4yLTv26x7UqLoVtCbcbh1KNxPjbuo8Ibw

So, a simple link to the image will suffice, and changing the column's type to "Image" shows the image in wpDataTables. Same goes for excel - the data inside the cell has to be written in that way so wpDataTables can recognize it.

The other way of adding images in wpDataTables would be to change the image cell value in Google Spreadsheet, so it looks like this:

<img src="https://www.iconsdb.com/icons/preview/green/checkmark-xxl.png" height="10" width="10">

When you paste this in Google Spreadsheet, you need to set the column's type in wpDataTables to "String" and it'll show the image.

Also, please go through our documentation about using Google Spreadsheets. I'll paste here some of the most important parts, for your awareness:

Please note: Once you create a table from a Google Spreadsheet, changes in the core file from which a table is created, like:

• Changing the column’s name,
• Changing the column’s order,
• Deleting the column, and
• Adding a new column.

are highly not recommended, because the old table will not work, at the moment. If you make any of these changes, please recreate the table again.

• Keep in mind that wpDataTables doesn’t support Google Spreadsheet with merged cells.
• Also, don’t apply any formatting in this new sheet. You can make whatever adjustment you may need in WpDataTables.

Best regards.