How to Turn a Google Sheet into a Product Listing Table in WordPress

Using WordPress Plugin – Stylish Google Sheets Reader

Want to display a product catalog on your WordPress site that automatically updates from a Google Sheet? With the Stylish Google Sheets Reader plugin, you can turn a simple spreadsheet into a responsive, sortable DataTable — complete with product images, stock quantities, ratings, and clickable purchase links.

In this post, we’ll use a public Google Spreadsheet with sample product data to demonstrate how easy it is to set up.

Example Spreadsheet (Product List tab):
View Google Sheet

📌 Supported Enhancements with Shortcodes

This plugin supports shortcodes in Google Sheet headers to convert plain URLs into clickable images, star ratings, and formatted links on the frontend.

⚠️ Note:

• The plugin only processes plain URLs, not embedded hyperlinks or formulas from Google Sheets.
• Shortcodes are visible only in the spreadsheet, not in the frontend table.

Here’s how we applied shortcodes in the sheet headers:

Original Column Name	Modified Header (with Shortcode)
Image	Image [sgsr-image w="80"]
Rating	Rating [sgsr-rating total="5" fill="#ffcc00"]
Product Link	Product Link [sgsr-hyperlink label=""]

These shortcode attributes control how the content appears:

• w – Sets image width in pixels.
• total – Defines the maximum rating (e.g., out of 5 stars).
• fill – Sets the star color.
• label (in [sgsr-hyperlink]) – Sets the link text; if left blank, a link icon is shown instead.

Need the full list of shortcodes and usage examples? View All Shortcodes & Guide

💡 If your data is in Excel format (.xlsx or .xls), upload it to Google Drive, right-click the file, and select “Open with → Google Sheets”. Once it opens, go to the menu and choose File → Save as Google Sheets. Then use the URL of the newly created Google Sheet in the plugin configuration.

📌 Google Sheet Configuration Used

• Sheet Name: Product List
• Range: A:E
• Use First Row as Headers: ✅ Yes
• Frontend Output: Sortable, paginated product listing table with images, ratings, and clickable links

📌 Final Output Preview (Frontend Table)

This is how the product listing table looks when rendered on your WordPress site using the plugin:

📌 Benefits of Using Stylish Google Sheet Reader

• Keeps original Google Sheets hidden — users only see the rendered table, not your backend data source
• Automatically syncs live product data from Google Sheets
• Responsive layout works on all devices
• Supports product images, ratings, and purchase links
• No coding required — just update your sheet to update your website

Need Similar DataTable Functionality for Wix, Squarespace, or Shopify?

If you're building on a platform other than WordPress — like Wix, Squarespace, or Shopify — you can still enjoy the same great DataTable features.

Get exclusive access to our cloud-based app that mirrors the exact functionality of the Stylish Google Sheet Reader plugin. Use it to connect your Google Sheets and generate clean, responsive HTML embed codes that work on any website or CMS.

Try the Cloud App