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