Author: khyzer

How to Create an Order Form in WordPress Using Google Sheets

With Built-in Form Submissions from Stylish Google Sheets Reader

Want to collect product orders or customer inquiries directly from a Google Sheet? With the Stylish Google Sheets Reader plugin, you can now create a fully functional order form that supports product images, dropdowns, input fields, checkboxes, and textareas — all synced from your Google Sheet and displayed as a responsive DataTable.

In this post, we’ll demonstrate how to set up a Google Sheet-powered order form using shortcodes for form elements.

Example Spreadsheet (Order Form tab):
View Google Sheet

📌 Using Shortcodes for Form Elements

The new version of Stylish Google Sheet Reader supports form shortcodes directly in your Google Sheet headers. These shortcodes turn plain columns into interactive form fields on the frontend.

Column	Shortcode in Header	Frontend Result
Quantity	[sgsr-short-input-field type="number" placeholder="Qty"]	Number input for customers to choose product quantity
Engraving Text	[sgsr-short-input-field type="text" placeholder="Enter Text"]	Single-line text field (e.g., custom engraving)
Delivery Time (Days)	[sgsr-dropdown]	Dropdown with numeric range (1–25 days). Since our column has range values in format (n1–n2 so we dont need to include "delimiter" attribute in shortcode.
Size	[sgsr-dropdown delimiter=","]	Dropdown with custom options. Our options are seperated with "," so we used delimiter as "," in shortcode.
Color	[sgsr-dropdown delimiter=","]	Dropdown with color choices
In Stock	[sgsr-checkbox]	Checkbox (TRUE/FALSE from Google Sheet)
Customer Note	[sgsr-long-input-field placeholder="Add note"]	Textarea for longer customer messages

Default Behavior: Input fields automatically take the value written in the sheet cell. Dropdowns display the first option as selected by default.

📌 Final Output: Order Form in WordPress

When rendered on your WordPress site, the plugin transforms the Google Sheet into an interactive order form that customers can use to select items, add custom details, and submit directly:

📌 Benefits of the Form Submission Feature

• Customers can select products and submit orders directly from your site
• All submissions are captured and linked with your Google Sheet
• No need for separate form builders — everything is managed in one place
• Perfect for e-commerce catalogs, event registrations, service bookings, and more

Use the Same Order Form on Wix, Squarespace, or Shopify

Not using WordPress? No problem! With our cloud-based app, you can connect your Google Sheets and generate responsive HTML embed codes that work seamlessly on Wix, Squarespace, Shopify, or any CMS.

Try the Cloud App

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

How to Create a Leaderboard Table from Google Sheets in WordPress

Using WordPress Plugin – Stylish Google Sheets Reader

Want to display a dynamic leaderboard on your WordPress site using a spreadsheet? With the Stylish Google Sheets Reader plugin, you can easily transform a Google Sheet into a visually rich, responsive DataTable — complete with player images, medals, scores, and star ratings.

In this post, we'll demonstrate this using a public Google Spreadsheet containing 30+ player records.

Example Spreadsheet (Leaderboard tab):
View Google Sheet

📌 Supported Enhancements with Shortcodes

This plugin supports shortcodes in Google Sheet headers to convert plain text links into images, ratings, and other visual content 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)
Medal	Medal [sgsr-image w="50"]
Headshot	Headshot [sgsr-image w="50"]
Rating	Rating [sgsr-rating total="5" fill="#ffcc00"]

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.

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: Leaderboard
• Range: A:E
• Use First Row as Headers: ✅ Yes
• Frontend Output: Paginated, sortable leaderboard table with images and ratings

📌 Final Output Preview (Frontend Table)

This is how the leaderboard 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 leaderboard data from Google Sheets
• Responsive layout works great on all devices
• Supports player images, medal icons, and custom ratings
• Perfect for contests, competitions, rankings, and eLearning

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

How to Display Stock Data from Spreadsheets as Responsive DataTables

Using WordPress Plugin – Stylish Google Sheets Reader

Want to showcase dynamic stock market data on your website using a spreadsheet? With the Stylish Google Sheets Reader WordPress plugin, you can convert a Google Sheet into a clean, sortable, searchable, and responsive DataTable — without writing code.

In this post, we'll demonstrate this using a public Google Spreadsheet containing 50+ stock entries.

Example Spreadsheet (Stocks tab):
View Google Sheet

📌 Supported Enhancements with Shortcodes

This plugin supports shortcodes in Google Sheet headers to convert plain text links (such as image URLs or hyperlinks) into rich frontend content like images or formatted values.

⚠️ 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)
Brand Logo	Brand Logo [sgsr-image w="50"]
Change (%)	Change (%) [sgsr-updown criteria="0"]
Trend	Trend [sgsr-hide]
Trend Logo	Trend Logo [sgsr-image w="50"]

The [sgsr-hide] shortcode hides a column from the frontend output. In the example, the Trend column is hidden, while conditional logic in the Google Sheet is used to generate up/down values, which are shown as icons in the Trend Logo column.

Key shortcode attributes and their functions:

• w – Sets the image width in pixels (used with [sgsr-image]).
• criteria – Defines the threshold for showing up/down indicators in [sgsr-updown]. For example, criteria="0" shows an up arrow if the value is greater than 0 and a down arrow if less.
• total – Defines the maximum rating value (e.g., out of 5 stars in [sgsr-rating]).
• fill – Sets the star fill color for ratings (e.g., #ffcc00 for yellow stars).

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: stocks
• Range: A:H
• Use First Row as Headers: ✅ Yes
• Frontend Output: Searchable, sortable, paginated stock table

📌 Final Output Preview (Frontend Table)

This is how the stock data 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 stock data from Google Sheets
• Responsive on mobile and desktop
• Supports image rendering, up/down trends, sorting, pagination
• Works with plain Google Sheets, no need for advanced coding

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