I have a google sheet where I have data on certain objects that I would like to display, such that I can layout and style the data myself.
Were the site written in React, I would do something like this:
const data = { key1: "value1", key2: "value2", key3: "value3" };
const listItems = Object.entries(data).map(([key, value]) => (
<div key={key}>
<img src="image-url.placeholder">
<p>{key}</p>
<p>{value}</p>
</div>
));
return <div>{listItems}</div>;
I am now looking for a plugin that does just that, if possible with my data from the spreadsheet. I can also export the data into say an excel spreadsheet or to a JSON Data structure.
I have tried using the “Spreadsheet Integration – Automate Google Sheets With WordPress, WooCommerce & Most Popular Form Plugins. Also, Display Google sheet as a Table.” plugin, but I have had some issues with it.