{"id":2948,"date":"2025-08-03T13:55:44","date_gmt":"2025-08-03T13:55:44","guid":{"rendered":"https:\/\/wppluginbox.com\/en\/?p=2948"},"modified":"2025-08-03T19:25:59","modified_gmt":"2025-08-03T19:25:59","slug":"how-to-turn-a-google-sheet-into-a-product-listing-table-in-wordpress","status":"publish","type":"post","link":"https:\/\/wppluginbox.com\/en\/how-to-turn-a-google-sheet-into-a-product-listing-table-in-wordpress\/","title":{"rendered":"How to Turn a Google Sheet into a Product Listing Table in WordPress"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"2948\" class=\"elementor elementor-2948\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-7fe5b84d elementor-section-full_width cexpress-header elementor-section-height-default elementor-section-height-default\" data-id=\"7fe5b84d\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-33 elementor-top-column elementor-element elementor-element-466651b3\" data-id=\"466651b3\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1bf176 express-header-img elementor-widget elementor-widget-image\" data-id=\"1bf176\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"\/\">\n\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"1454\" height=\"1282\" src=\"https:\/\/wppluginbox.com\/en\/wp-content\/uploads\/2025\/07\/WP-Plugin-Box-Logo-2.jpg\" class=\"attachment-full size-full wp-image-2461\" alt=\"WP Plugin Box Brand Logo\" srcset=\"https:\/\/wppluginbox.com\/en\/wp-content\/uploads\/2025\/07\/WP-Plugin-Box-Logo-2.jpg 1454w, https:\/\/wppluginbox.com\/en\/wp-content\/uploads\/2025\/07\/WP-Plugin-Box-Logo-2-300x265.jpg 300w, https:\/\/wppluginbox.com\/en\/wp-content\/uploads\/2025\/07\/WP-Plugin-Box-Logo-2-1024x903.jpg 1024w, https:\/\/wppluginbox.com\/en\/wp-content\/uploads\/2025\/07\/WP-Plugin-Box-Logo-2-768x677.jpg 768w, https:\/\/wppluginbox.com\/en\/wp-content\/uploads\/2025\/07\/WP-Plugin-Box-Logo-2-1200x1058.jpg 1200w\" sizes=\"(max-width: 1454px) 100vw, 1454px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-66 elementor-top-column elementor-element elementor-element-3680ee1\" data-id=\"3680ee1\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-462c30c0 elementor-widget elementor-widget-shortcode\" data-id=\"462c30c0\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"shortcode.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-shortcode\">\n<!-- Desktop Menu -->\n<nav class=\"custom-menu\">\n  <ul>\n    <li><a href=\"https:\/\/wppluginbox.com\/en\/\">Home<\/a><\/li>\n    <li class=\"has-mega-menu\">\n      <a href=\"#\">Our Plugins \u25be<\/a>\n      <div class=\"mega-menu\">\n        <div class=\"mega-column\">\n          <h4>WordPress Plugins<\/h4>\n          <ul>\n                          <li><a href=\"https:\/\/wordpress.org\/plugins\/stylish-google-sheet-reader\/\">Stylish Google Sheet Reader<\/a><\/li>\n                          <li><a href=\"https:\/\/wppluginbox.com\/en\/smc-pro-pricing\/\">Smart Mortgage Calculator<\/a><\/li>\n                          <li><a href=\"https:\/\/wordpress.org\/plugins\/smart-loan-calculator\/\">Smart Loan Calculator<\/a><\/li>\n                          <li><a href=\"https:\/\/wordpress.org\/plugins\/home-affordability-calculator\/\">Home Affordability Calculator<\/a><\/li>\n                          <li><a href=\"https:\/\/wordpress.org\/plugins\/smart-investment-calculator\/\">Smart Investment Calculator<\/a><\/li>\n                          <li><a href=\"https:\/\/wordpress.org\/plugins\/sell-btc-by-hayyatapps\/\">Sell BTC Pro<\/a><\/li>\n                          <li><a href=\"https:\/\/wordpress.org\/plugins\/stylish-order-form-builder\/\">Stylish Order Form Builder<\/a><\/li>\n                      <\/ul>\n        <\/div>\n\n        <div class=\"mega-column\">\n          <h4>Pricing<\/h4>\n          <ul>\n                          <li><a href=\"https:\/\/wppluginbox.com\/en\/stylish-google-sheet-reader-pro\">Stylish Google Sheet Reader<\/a><\/li>\n                          <li><a href=\"https:\/\/wppluginbox.com\/en\/smc-pro-pricing\">Smart Mortgage Calculator<\/a><\/li>\n                          <li><a href=\"https:\/\/wppluginbox.com\/en\/smart-loan-calculator-pro-pricing\">Smart Loan Calculator<\/a><\/li>\n                          <li><a href=\"https:\/\/wppluginbox.com\/en\/home-affordability-calculator-pro-pricing\">Home Affordability Calculator<\/a><\/li>\n                          <li><a href=\"https:\/\/wppluginbox.com\/en\/smart-investment-calculator-pro-pricing\">Smart Investment Calculator<\/a><\/li>\n                          <li><a href=\"https:\/\/wppluginbox.com\/en\/sell-btc-pro-pricing\">Sell BTC Pro<\/a><\/li>\n                          <li><a href=\"https:\/\/wppluginbox.com\/en\/stylish-order-form-builder-pro-pricing\">Stylish Order Form Builder<\/a><\/li>\n                      <\/ul>\n        <\/div>\n\n        <div class=\"mega-column\">\n          <h4>Documentation<\/h4>\n          <ul>\n                          <li><a href=\"https:\/\/wppluginbox.com\/en\/documentation-stylish-google-sheet-reader-pro\">Stylish Google Sheet Reader <\/a><\/li>\n                      <\/ul>\n        <\/div>\n      <\/div>\n    <\/li>\n\n    <li><a href=\"https:\/\/wppluginbox.com\/en\/our-portfolio\">Our Portfolio<\/a><\/li>\n    <li><a href=\"https:\/\/wppluginbox.com\/en\/contact-us\">Contact Us<\/a><\/li>\n    <li><a href=\"https:\/\/wppluginbox.com\/en\/plugin-support\">Plugin Support<\/a><\/li>\n    <li><a href=\"https:\/\/wppluginbox.com\/en\/blog\">Blog<\/a><\/li>\n\t<\/ul>\n<\/nav>\n\n<!-- =========== Mobile Nav ============ -->\n<div style=\"display: flex; justify-content: flex-end;\">\n  <div class=\"mobile-menu-toggle\" onclick=\"document.querySelector('.mobile-menu').classList.toggle('open')\">\n    <i class=\"fas fa-bars\"><\/i> Menu\n  <\/div>\n<\/div>\n\n<nav wpbox-custom-menu=\"1\" class=\"mobile-menu\">\n  <ul>\n    <li><a href=\"https:\/\/wppluginbox.com\/en\/\"><i class=\"fas fa-home\"><\/i> Home<\/a><\/li>\n\n    <li>\n      <details>\n        <summary><i class=\"fab fa-wordpress\"><\/i> Our Plugins <i class=\"fas fa-sort-down\"><\/i><\/summary>\n        <ul>\n                      <li><a href=\"https:\/\/wordpress.org\/plugins\/stylish-google-sheet-reader\/\">Stylish Google Sheet Reader<\/a><\/li>\n                      <li><a href=\"https:\/\/wppluginbox.com\/en\/smc-pro-pricing\/\">Smart Mortgage Calculator<\/a><\/li>\n                      <li><a href=\"https:\/\/wordpress.org\/plugins\/smart-loan-calculator\/\">Smart Loan Calculator<\/a><\/li>\n                      <li><a href=\"https:\/\/wordpress.org\/plugins\/home-affordability-calculator\/\">Home Affordability Calculator<\/a><\/li>\n                      <li><a href=\"https:\/\/wordpress.org\/plugins\/smart-investment-calculator\/\">Smart Investment Calculator<\/a><\/li>\n                      <li><a href=\"https:\/\/wordpress.org\/plugins\/sell-btc-by-hayyatapps\/\">Sell BTC Pro<\/a><\/li>\n                      <li><a href=\"https:\/\/wordpress.org\/plugins\/stylish-order-form-builder\/\">Stylish Order Form Builder<\/a><\/li>\n                  <\/ul>\n      <\/details>\n    <\/li>\n\n    <li>\n      <details>\n        <summary><i class=\"fas fa-tags\"><\/i> Pricing <i class=\"fas fa-sort-down\"><\/i><\/summary>\n        <ul>\n                      <li><a href=\"https:\/\/wppluginbox.com\/en\/stylish-google-sheet-reader-pro\">Stylish Google Sheet Reader<\/a><\/li>\n                      <li><a href=\"https:\/\/wppluginbox.com\/en\/smc-pro-pricing\">Smart Mortgage Calculator<\/a><\/li>\n                      <li><a href=\"https:\/\/wppluginbox.com\/en\/smart-loan-calculator-pro-pricing\">Smart Loan Calculator<\/a><\/li>\n                      <li><a href=\"https:\/\/wppluginbox.com\/en\/home-affordability-calculator-pro-pricing\">Home Affordability Calculator<\/a><\/li>\n                      <li><a href=\"https:\/\/wppluginbox.com\/en\/smart-investment-calculator-pro-pricing\">Smart Investment Calculator<\/a><\/li>\n                      <li><a href=\"https:\/\/wppluginbox.com\/en\/sell-btc-pro-pricing\">Sell BTC Pro<\/a><\/li>\n                      <li><a href=\"https:\/\/wppluginbox.com\/en\/stylish-order-form-builder-pro-pricing\">Stylish Order Form Builder<\/a><\/li>\n                  <\/ul>\n      <\/details>\n    <\/li>\n\n    <li>\n      <details>\n        <summary><i class=\"fas fa-book\"><\/i> Documentation <i class=\"fas fa-sort-down\"><\/i><\/summary>\n        <ul>\n                      <li><a href=\"https:\/\/wppluginbox.com\/en\/documentation-stylish-google-sheet-reader-pro\">Stylish Google Sheet Reader Docs<\/a><\/li>\n                  <\/ul>\n      <\/details>\n    <\/li>\n\n    <li><a href=\"https:\/\/wppluginbox.com\/en\/our-portfolio\"><i class=\"fas fa-briefcase\"><\/i> Our Portfolio<\/a><\/li>\n    <li><a href=\"https:\/\/wppluginbox.com\/en\/contact-us\"><i class=\"fas fa-envelope\"><\/i> Contact Us<\/a><\/li>\n\t  \n<li><a href=\"https:\/\/wppluginbox.com\/en\/plugin-support\"> <i class=\"fas fa-plug\"><\/i> Plugin Support<\/a><\/li>\n\n<li><a href=\"https:\/\/wppluginbox.com\/en\/blog\"> <i class=\"fas fa-lightbulb-on\"><\/i> Blog<\/a><\/li>\n\n\t  \n  <\/ul>\n<\/nav>\n<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-d0cf8e2 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d0cf8e2\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-7659e43\" data-id=\"7659e43\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-f740d62 elementor-widget elementor-widget-html\" data-id=\"f740d62\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<link rel=\"stylesheet\" type=\"text\/css\" href=\"https:\/\/wppluginbox.com\/docs\/stylish-google-sheet-reader-pro\/examples\/style.css\">\r\n\r\n<div class=\"blog-container\">\r\n\r\n  <h2>How to Turn a Google Sheet into a Product Listing Table in WordPress<\/h2>\r\n  <h3>Using WordPress Plugin \u2013 Stylish Google Sheets Reader<\/h3>\r\n\r\n  <p>\r\n    Want to display a product catalog on your WordPress site that automatically updates from a Google Sheet?  \r\n    With the <strong><a href=\"https:\/\/wordpress.org\/plugins\/stylish-google-sheet-reader\/\" target=\"_blank\">Stylish Google Sheets Reader <i class=\"fas fa-external-link\"><\/i><\/a><\/strong> plugin, you can turn a simple spreadsheet into a responsive, sortable <strong>DataTable<\/strong> \u2014 complete with product images, stock quantities, ratings, and clickable purchase links.\r\n  <\/p>\r\n\r\n  <p>\r\n    In this post, we\u2019ll use a <strong>public Google Spreadsheet<\/strong> with sample product data to demonstrate how easy it is to set up.\r\n  <\/p>\r\n\r\n  <center>\r\n    <div style=\"margin:50px;\">\r\n      <p><strong>Example Spreadsheet (Product List tab):<\/strong><br>\r\n        <a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1ljvtNZ87Dl0Cmm-xDaIx4YuSdr6Oo8zLFeXJWgjVxeE\/edit?gid=0#gid=0\" target=\"_blank\" class=\"sgsr-btn-link\">\r\n          View Google Sheet <i class=\"far fa-external-link\"><\/i>\r\n        <\/a>\r\n      <\/p>\r\n    <\/div>\r\n  <\/center>\r\n\r\n  <center>\r\n    <div style=\"margin:50px;\">  \r\n      <a href=\"https:\/\/wppluginbox.com\/docs\/stylish-google-sheet-reader-pro\/examples\/product_sheet.png\" data-lightbox=\"post-images\">\r\n        <img decoding=\"async\" class=\"example-img\" src=\"https:\/\/wppluginbox.com\/docs\/stylish-google-sheet-reader-pro\/examples\/product_sheet.png\" alt=\"Product Sheet Preview\">\r\n      <\/a>\r\n    <\/div>\r\n  <\/center>\r\n\r\n  <h3>\ud83d\udccc Supported Enhancements with Shortcodes<\/h3>\r\n\r\n  <p>\r\n    This plugin supports <strong>shortcodes in Google Sheet headers<\/strong> to convert plain URLs into clickable images, star ratings, and formatted links on the frontend.\r\n  <\/p>\r\n\r\n  <p><strong>\u26a0\ufe0f Note:<\/strong><\/p>\r\n  <ul>\r\n    <li>The plugin only processes <em>plain URLs<\/em>, not embedded hyperlinks or formulas from Google Sheets.<\/li>\r\n    <li>Shortcodes are visible only in the spreadsheet, not in the frontend table.<\/li>\r\n  <\/ul>\r\n\r\n  <p>Here\u2019s how we applied shortcodes in the sheet headers:<\/p>\r\n\r\n  <table class=\"scode\">\r\n    <thead>\r\n      <tr>\r\n        <th>Original Column Name<\/th>\r\n        <th>Modified Header (with Shortcode)<\/th>\r\n      <\/tr>\r\n    <\/thead>\r\n    <tbody>\r\n      <tr>\r\n        <td>Image<\/td>\r\n        <td><code>Image [sgsr-image w=\"80\"]<\/code><\/td>\r\n      <\/tr>\r\n      <tr>\r\n        <td>Rating<\/td>\r\n        <td><code>Rating [sgsr-rating total=\"5\" fill=\"#ffcc00\"]<\/code><\/td>\r\n      <\/tr>\r\n      <tr>\r\n        <td>Product Link<\/td>\r\n        <td><code>Product Link [sgsr-hyperlink label=\"\"]<\/code><\/td>\r\n      <\/tr>\r\n    <\/tbody>\r\n  <\/table>\r\n\r\n  <p>\r\n  These shortcode attributes control how the content appears:\r\n<\/p>\r\n<ul>\r\n  <li><strong>w<\/strong> \u2013 Sets image width in pixels.<\/li>\r\n  <li><strong>total<\/strong> \u2013 Defines the maximum rating (e.g., out of 5 stars).<\/li>\r\n  <li><strong>fill<\/strong> \u2013 Sets the star color.<\/li>\r\n  <li><strong>label<\/strong> (in <code>[sgsr-hyperlink]<\/code>) \u2013 Sets the link text; if left blank, a link icon is shown instead.<\/li>\r\n<\/ul>\r\n\r\n\r\n  <blockquote>\r\n  Need the full list of shortcodes and usage examples?\r\n  <a href=\"https:\/\/wppluginbox.com\/en\/documentation-stylish-google-sheet-reader-pro\/\" target=\"_blank\" class=\"sgsr-btn-link\">\r\n    View All Shortcodes & Guide <i class=\"far fa-external-link\"><\/i>\r\n  <\/a>\r\n<\/blockquote>\r\n\r\n\r\n  <blockquote>\r\n    \ud83d\udca1 <strong>If your data is in Excel format (.xlsx or .xls)<\/strong>, upload it to Google Drive, right-click the file,\r\n    and select \u201cOpen with \u2192 Google Sheets\u201d. Once it opens, go to the menu and choose <strong>File \u2192 Save as Google Sheets<\/strong>.\r\n    Then use the URL of the newly created Google Sheet in the plugin configuration.\r\n  <\/blockquote>\r\n\r\n  <h3>\ud83d\udccc Google Sheet Configuration Used<\/h3>\r\n\r\n  <ul>\r\n    <li><strong>Sheet Name:<\/strong> <code>Product List<\/code><\/li>\r\n    <li><strong>Range:<\/strong> <code>A:E<\/code><\/li>\r\n    <li><strong>Use First Row as Headers:<\/strong> \u2705 Yes<\/li>\r\n    <li><strong>Frontend Output:<\/strong> Sortable, paginated product listing table with images, ratings, and clickable links<\/li>\r\n  <\/ul>\r\n\r\n  <center>\r\n    <div style=\"margin:50px;\">  \r\n      <a href=\"https:\/\/wppluginbox.com\/docs\/stylish-google-sheet-reader-pro\/examples\/product_sheet_settings.png?v=1.1\" data-lightbox=\"post-images\">\r\n        <img decoding=\"async\" class=\"example-img\" src=\"https:\/\/wppluginbox.com\/docs\/stylish-google-sheet-reader-pro\/examples\/product_sheet_settings.png?v=1.1\" alt=\"Product Table Config\">\r\n      <\/a>\r\n    <\/div>\r\n  <\/center>\r\n\r\n  <h3>\ud83d\udccc Final Output Preview (Frontend Table)<\/h3>\r\n\r\n  <p>This is how the product listing table looks when rendered on your WordPress site using the plugin:<\/p>\r\n\r\n  <div class=\"shortcode-preview\">\r\n    \r\n<style type=\"text\/css\">\r\n  body{\r\n\/*    background-color: black!important;*\/\r\n  }\r\n\r\n  \r\n<\/style>\r\n\r\n<div sgsr-tab-section=\"1\" \r\nsgsr-center-txt=\"1\" \r\ntable-id=\"1\" \r\ntable-config='{&quot;no&quot;:&quot;1&quot;,&quot;project_uid&quot;:&quot;pbvjdTTeAumYO38z&quot;,&quot;sheet_id&quot;:&quot;1ljvtNZ87Dl0Cmm-xDaIx4YuSdr6Oo8zLFeXJWgjVxeE&quot;,&quot;tab_name&quot;:&quot;Product List&quot;,&quot;range&quot;:&quot;A:E&quot;,&quot;enable_search&quot;:&quot;1&quot;,&quot;enable_sorting&quot;:&quot;1&quot;,&quot;enable_data_export&quot;:&quot;0&quot;,&quot;enable_auto_refresh&quot;:&quot;0&quot;,&quot;auto_refresh_duration&quot;:&quot;15&quot;,&quot;shadow_style&quot;:&quot;s-n&quot;,&quot;theme&quot;:&quot;white&quot;,&quot;header_color&quot;:&quot;#6d78f2&quot;,&quot;header_text_color&quot;:&quot;#ffffff&quot;,&quot;custom_scrollbar&quot;:&quot;0&quot;,&quot;responsive&quot;:&quot;1&quot;,&quot;max_table_height&quot;:&quot;scrollable&quot;,&quot;enable_paging&quot;:&quot;1&quot;,&quot;page_length&quot;:&quot;10&quot;,&quot;enable_cache&quot;:&quot;0&quot;,&quot;cache_duration&quot;:&quot;5m&quot;,&quot;enable_form&quot;:&quot;0&quot;,&quot;form_main_heading&quot;:&quot;Submit Your Details&quot;,&quot;form_sub_heading&quot;:&quot;Please fill in the required details below and submit the form.&quot;,&quot;enable_row_selection&quot;:&quot;0&quot;,&quot;thank_you_msg&quot;:&quot;Thank you for your submission.&quot;,&quot;submission_email&quot;:&quot; &quot;,&quot;form_fields&quot;:&quot;&quot;}'\r\nsgsr-card=\"s-n\"\r\nsgsr-paging=\"1\" \r\nsgsr-scroll=\"scrollable\"\r\n>\r\n<!-- style=\"display: none;\">  -->\r\n<!-- ----------------------------------------------------------------- -->\r\n<div class=\"sgsr-render-error\"><\/div>\r\n<div><p class=\"sgsr-refresh sgsr-flash\"><i class=\"fas fa-sync-alt\"><\/i> Refreshing<\/p><\/div>\r\n<div class=\"sgsr-mob-msg\"><p class=\"sgsr-swipe\">Swipe sideways to see full table <i class=\"fas fa-arrows-alt-h\"><\/i><\/p><\/div>\r\n\r\n<div class=\"searc-box\">\r\n  \r\n  <input type=\"text\" class=\"searchInput\" placeholder=\"Search...\">\r\n\r\n  <!-- NEW DROPDOWN -->\r\n    <div class=\"sgsr-search-col-div\">\r\n    <select class=\"searchColumn\">\r\n        <option value=\"all\">Search All Columns<\/option>\r\n    <\/select>\r\n  <\/div>\r\n\r\n<\/div>\r\n\r\n<div class=\"sgsr-responsivess\" sgsr-card=\"0\" sgsr-tab-div=\"1\">\r\n<table sgsr-table=\"1\">\r\n  <thead>\r\n    <tr class=\"headerRow\"><\/tr>\r\n  <\/thead>\r\n  <tbody><tr><td>Loading data...<\/td><\/tr><\/tbody>\r\n<\/table>\r\n\r\n<div><p data-sgsr=\"b\"><\/p><\/div>\r\n<\/div>\r\n\r\n\r\n<div class=\"pagination-controls\" style=\"display: none;\">\r\n  <div class=\"sgsr-group-left\">\r\n    <button class=\"prevPage\">Prev<\/button>\r\n    <span class=\"pageInfo\"><\/span>\r\n    <button class=\"nextPage\">Next<\/button>\r\n  <\/div>\r\n\r\n  <div class=\"sgsr-group-center sgsr-inline-group\">\r\n    <label for=\"gotoPage\">Go to Page:<\/label>\r\n    <select class=\"gotoPage\"><\/select>\r\n  <\/div>\r\n\r\n  <div class=\"sgsr-group-right sgsr-inline-group\">\r\n    <label for=\"rowsPerPage\">Rows \/ Page:<\/label>\r\n    <select class=\"rowsPerPage\">\r\n      <option value=\"10\">10<\/option>\r\n      <option value=\"20\">20<\/option>\r\n      <option value=\"30\">30<\/option>\r\n      <option value=\"50\">50<\/option>\r\n      <option value=\"100\">100<\/option>\r\n      <option value=\"250\">250<\/option>\r\n      <option value=\"500\">500<\/option>\r\n      <!-- <option value=\"all\">Show All<\/option> -->\r\n    <\/select>\r\n  <\/div>\r\n<\/div>\r\n\r\n\r\n\r\n\r\n<!-- ----------------------------------------------------------------- -->\r\n<\/div>\r\n\r\n\r\n<div style=\"display: none;\" sgsr-submission-form=\"1\">\r\n  <form onsubmit=\"sgsr_form_submission(1);return false;\" id=\"sgsr-form-1\">\r\n        \r\n        <div class=\"sgsr-form\">\r\n         <label for=\"sgsr_field_1\" class=\"sgsr-label\">Your Name<\/label>\r\n              <input type=\"text\" class=\"sgsr-input\" name=\"sgsr_field_1\" id=\"sgsr_field_1\" placeholder=\"Enter Name\" value=\"\" required=\"\">\r\n            <\/div>\r\n          \r\n            <div class=\"sgsr-form\">\r\n              <label for=\"sgsr_field_2\" class=\"sgsr-label\">Email<\/label>\r\n              <input type=\"text\" class=\"sgsr-input\" name=\"sgsr_field_2\" id=\"sgsr_field_2\" placeholder=\"Enter Email\" value=\"\" required=\"\">\r\n            <\/div>\r\n          \r\n            <div class=\"sgsr-form\">\r\n              <label for=\"sgsr_field_3\" class=\"sgsr-label\">Phone<\/label>\r\n              <input type=\"text\" class=\"sgsr-input\" name=\"sgsr_field_3\" id=\"sgsr_field_3\" placeholder=\"Enter Phone\" value=\"\">\r\n            <\/div>         \r\n          \r\n        <input type=\"hidden\" name=\"json\" id=\"selected_items\" value=\"{}\">\r\n        <button type=\"submit\" class=\"sgsr-btn submitSelected\">Submit<\/button>\r\n      <\/form>\r\n\r\n<\/div>\r\n\r\n\r\n  <\/div>\r\n\r\n  <div style=\"height:50px;\"><\/div>\r\n  <h3>\ud83d\udccc Benefits of Using Stylish Google Sheet Reader<\/h3>\r\n  <ul>\r\n    <li><strong>Keeps original Google Sheets hidden<\/strong> \u2014 users only see the rendered table, not your backend data source<\/li>\r\n    <li>Automatically syncs live product data from Google Sheets<\/li>\r\n    <li>Responsive layout works on all devices<\/li>\r\n    <li>Supports product images, ratings, and purchase links<\/li>\r\n    <li>No coding required \u2014 just update your sheet to update your website<\/li>\r\n  <\/ul>\r\n\r\n  <h3 id=\"live-chat-for-cloud-app\">Need Similar DataTable Functionality for Wix, Squarespace, or Shopify?<\/h3>\r\n\r\n  <p>\r\n    If you're building on a platform other than WordPress \u2014 like <strong>Wix<\/strong>, <strong>Squarespace<\/strong>, or <strong>Shopify<\/strong> \u2014 you can still enjoy the same great DataTable features.\r\n  <\/p>\r\n\r\n  <p>\r\n    Get exclusive access to our <strong>cloud-based app<\/strong> that mirrors the exact functionality of the Stylish Google Sheet Reader plugin. Use it to connect your Google Sheets and generate clean, responsive <strong>HTML embed codes<\/strong> that work on any website or CMS.\r\n  <\/p>\r\n\r\n  <a href=\"#live-chat-for-cloud-app\" action=\"live-chat\" class=\"sgsr-btn-link\">\r\n    Try the Cloud App <i class=\"fas fa-cloud\"><\/i>\r\n  <\/a>\r\n\r\n<\/div>\r\n\r\n<script type=\"text\/javascript\">\r\n  jQuery(document).on('click', '[action=\"live-chat\"]', function () {\r\n    if (typeof tidioChatApi === 'undefined') {\r\n      console.warn('Tidio chat API not loaded yet');\r\n      return;\r\n    }\r\n    tidioChatApi.open();\r\n  });\r\n<\/script>\r\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-d28cff8 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d28cff8\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-0cff82a\" data-id=\"0cff82a\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-465e2e7 elementor-widget elementor-widget-shortcode\" data-id=\"465e2e7\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"shortcode.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-shortcode\"><\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-7be6597e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7be6597e\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-58e6309\" data-id=\"58e6309\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-63ce3f74 elementor-widget elementor-widget-spacer\" data-id=\"63ce3f74\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-7c9646cc elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7c9646cc\" data-element_type=\"section\" data-e-type=\"section\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-44c48b39\" data-id=\"44c48b39\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-6d1dc64 elementor-widget elementor-widget-elementskit-heading\" data-id=\"6d1dc64\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"elementskit-heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"ekit-wid-con\" ><div class=\"ekit-heading elementskit-section-title-wraper text_left   ekit_heading_tablet-   ekit_heading_mobile-text_center\"><p class=\"ekit-heading--title elementskit-section-title \">\u00a9 WP Plugin Box. All Rights Reserved.<\/p><\/div><\/div>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-2c8d708e\" data-id=\"2c8d708e\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-2cb32c07 elementor-align-right elementor-mobile-align-center ekit-has-divider-yes elementor-widget__width-inherit elementor-widget elementor-widget-elementskit-page-list\" data-id=\"2cb32c07\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"elementskit-page-list.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"ekit-wid-con\" >\t\t<div class=\"elementor-icon-list-items  elementor-inline-items\">\n\t\t\t\t\t\t\t<div class=\"elementor-icon-list-item   \">\n\t\t\t\t\t\t<a class=\"elementor-repeater-item-dfcdbc0 ekit_badge_left\" href=\"https:\/\/wppluginbox.com\/terms-of-services\/\" target=\"_blank\" rel=\"nofollow\">\n\t\t\t\t\t\t\t<div class=\"ekit_page_list_content\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">\n\t\t\t\t\t\t\t\t\t<span class=\"ekit_page_list_title_title\">Terms &amp; Conditions<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<div class=\"elementor-icon-list-item   \">\n\t\t\t\t\t\t<a class=\"elementor-repeater-item-2fae0ea ekit_badge_left\" href=\"https:\/\/wppluginbox.com\/refund-policy\/\" target=\"_blank\" rel=\"nofollow\">\n\t\t\t\t\t\t\t<div class=\"ekit_page_list_content\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">\n\t\t\t\t\t\t\t\t\t<span class=\"ekit_page_list_title_title\">Refund Policy<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t<\/div>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Turn a Google Sheet into a Product Listing Table in WordPress. Turn a simple spreadsheet into a responsive, sortable DataTable \u2014 complete with product images, stock quantities, ratings, and clickable purchase links.<\/p>\n","protected":false},"author":2,"featured_media":2962,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_canvas","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-2948","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to Turn a Google Sheet into a Product Listing Table<\/title>\n<meta name=\"description\" content=\"Learn how to create a responsive product listing table in WordPress using the Stylish Google Sheets Reader plugin. Display product images, stock levels, ratings, and purchase links directly from Google Sheets.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/wppluginbox.com\/en\/how-to-turn-a-google-sheet-into-a-product-listing-table-in-wordpress\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Turn a Google Sheet into a Product Listing Table\" \/>\n<meta property=\"og:description\" content=\"Learn how to create a responsive product listing table in WordPress using the Stylish Google Sheets Reader plugin. Display product images, stock levels, ratings, and purchase links directly from Google Sheets.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/wppluginbox.com\/en\/how-to-turn-a-google-sheet-into-a-product-listing-table-in-wordpress\/\" \/>\n<meta property=\"og:site_name\" content=\"WP Plugin Box \u2013 Custom Web Calculators &amp; WordPress Plugins\" \/>\n<meta property=\"article:published_time\" content=\"2025-08-03T13:55:44+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-03T19:25:59+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/wppluginbox.com\/en\/wp-content\/uploads\/2025\/08\/product_datatabl.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1366\" \/>\n\t<meta property=\"og:image:height\" content=\"757\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Hayyat Apps\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Hayyat Apps\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/wppluginbox.com\/en\/how-to-turn-a-google-sheet-into-a-product-listing-table-in-wordpress\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/wppluginbox.com\/en\/how-to-turn-a-google-sheet-into-a-product-listing-table-in-wordpress\/\"},\"author\":{\"name\":\"Hayyat Apps\",\"@id\":\"https:\/\/wppluginbox.com\/en\/#\/schema\/person\/7e8d1f33896d21fa38c031e8a7c7219b\"},\"headline\":\"How to Turn a Google Sheet into a Product Listing Table in WordPress\",\"datePublished\":\"2025-08-03T13:55:44+00:00\",\"dateModified\":\"2025-08-03T19:25:59+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/wppluginbox.com\/en\/how-to-turn-a-google-sheet-into-a-product-listing-table-in-wordpress\/\"},\"wordCount\":504,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/wppluginbox.com\/en\/#organization\"},\"image\":{\"@id\":\"https:\/\/wppluginbox.com\/en\/how-to-turn-a-google-sheet-into-a-product-listing-table-in-wordpress\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/wppluginbox.com\/en\/wp-content\/uploads\/2025\/08\/product_datatabl.png\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/wppluginbox.com\/en\/how-to-turn-a-google-sheet-into-a-product-listing-table-in-wordpress\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/wppluginbox.com\/en\/how-to-turn-a-google-sheet-into-a-product-listing-table-in-wordpress\/\",\"url\":\"https:\/\/wppluginbox.com\/en\/how-to-turn-a-google-sheet-into-a-product-listing-table-in-wordpress\/\",\"name\":\"How to Turn a Google Sheet into a Product Listing Table\",\"isPartOf\":{\"@id\":\"https:\/\/wppluginbox.com\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/wppluginbox.com\/en\/how-to-turn-a-google-sheet-into-a-product-listing-table-in-wordpress\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/wppluginbox.com\/en\/how-to-turn-a-google-sheet-into-a-product-listing-table-in-wordpress\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/wppluginbox.com\/en\/wp-content\/uploads\/2025\/08\/product_datatabl.png\",\"datePublished\":\"2025-08-03T13:55:44+00:00\",\"dateModified\":\"2025-08-03T19:25:59+00:00\",\"description\":\"Learn how to create a responsive product listing table in WordPress using the Stylish Google Sheets Reader plugin. Display product images, stock levels, ratings, and purchase links directly from Google Sheets.\",\"breadcrumb\":{\"@id\":\"https:\/\/wppluginbox.com\/en\/how-to-turn-a-google-sheet-into-a-product-listing-table-in-wordpress\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/wppluginbox.com\/en\/how-to-turn-a-google-sheet-into-a-product-listing-table-in-wordpress\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/wppluginbox.com\/en\/how-to-turn-a-google-sheet-into-a-product-listing-table-in-wordpress\/#primaryimage\",\"url\":\"https:\/\/wppluginbox.com\/en\/wp-content\/uploads\/2025\/08\/product_datatabl.png\",\"contentUrl\":\"https:\/\/wppluginbox.com\/en\/wp-content\/uploads\/2025\/08\/product_datatabl.png\",\"width\":1366,\"height\":757},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/wppluginbox.com\/en\/how-to-turn-a-google-sheet-into-a-product-listing-table-in-wordpress\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/wppluginbox.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Turn a Google Sheet into a Product Listing Table in WordPress\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/wppluginbox.com\/en\/#website\",\"url\":\"https:\/\/wppluginbox.com\/en\/\",\"name\":\"WP Plugin Box \u2013 Custom Web Calculators &amp; WordPress Plugins\",\"description\":\"Smart web forms, calculators &amp; lead-gen tools for WordPress, Wix, and Squarespace\",\"publisher\":{\"@id\":\"https:\/\/wppluginbox.com\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/wppluginbox.com\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/wppluginbox.com\/en\/#organization\",\"name\":\"WP Plugin Box \u2013 Custom Web Calculators &amp; WordPress Plugins\",\"url\":\"https:\/\/wppluginbox.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/wppluginbox.com\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/wppluginbox.com\/en\/wp-content\/uploads\/2025\/07\/WP-Plugin-Box-Logo-2.jpg\",\"contentUrl\":\"https:\/\/wppluginbox.com\/en\/wp-content\/uploads\/2025\/07\/WP-Plugin-Box-Logo-2.jpg\",\"width\":1454,\"height\":1282,\"caption\":\"WP Plugin Box \u2013 Custom Web Calculators &amp; WordPress Plugins\"},\"image\":{\"@id\":\"https:\/\/wppluginbox.com\/en\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/wppluginbox.com\/en\/#\/schema\/person\/7e8d1f33896d21fa38c031e8a7c7219b\",\"name\":\"Hayyat Apps\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/wppluginbox.com\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/54016c796204b6d51e8e46068f4dd5670937bdc4a1982a190be8ef133e9c6705?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/54016c796204b6d51e8e46068f4dd5670937bdc4a1982a190be8ef133e9c6705?s=96&d=mm&r=g\",\"caption\":\"Hayyat Apps\"},\"url\":\"https:\/\/wppluginbox.com\/en\/author\/hayyat\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Turn a Google Sheet into a Product Listing Table","description":"Learn how to create a responsive product listing table in WordPress using the Stylish Google Sheets Reader plugin. Display product images, stock levels, ratings, and purchase links directly from Google Sheets.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/wppluginbox.com\/en\/how-to-turn-a-google-sheet-into-a-product-listing-table-in-wordpress\/","og_locale":"en_US","og_type":"article","og_title":"How to Turn a Google Sheet into a Product Listing Table","og_description":"Learn how to create a responsive product listing table in WordPress using the Stylish Google Sheets Reader plugin. Display product images, stock levels, ratings, and purchase links directly from Google Sheets.","og_url":"https:\/\/wppluginbox.com\/en\/how-to-turn-a-google-sheet-into-a-product-listing-table-in-wordpress\/","og_site_name":"WP Plugin Box \u2013 Custom Web Calculators &amp; WordPress Plugins","article_published_time":"2025-08-03T13:55:44+00:00","article_modified_time":"2025-08-03T19:25:59+00:00","og_image":[{"width":1366,"height":757,"url":"https:\/\/wppluginbox.com\/en\/wp-content\/uploads\/2025\/08\/product_datatabl.png","type":"image\/png"}],"author":"Hayyat Apps","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Hayyat Apps","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/wppluginbox.com\/en\/how-to-turn-a-google-sheet-into-a-product-listing-table-in-wordpress\/#article","isPartOf":{"@id":"https:\/\/wppluginbox.com\/en\/how-to-turn-a-google-sheet-into-a-product-listing-table-in-wordpress\/"},"author":{"name":"Hayyat Apps","@id":"https:\/\/wppluginbox.com\/en\/#\/schema\/person\/7e8d1f33896d21fa38c031e8a7c7219b"},"headline":"How to Turn a Google Sheet into a Product Listing Table in WordPress","datePublished":"2025-08-03T13:55:44+00:00","dateModified":"2025-08-03T19:25:59+00:00","mainEntityOfPage":{"@id":"https:\/\/wppluginbox.com\/en\/how-to-turn-a-google-sheet-into-a-product-listing-table-in-wordpress\/"},"wordCount":504,"commentCount":0,"publisher":{"@id":"https:\/\/wppluginbox.com\/en\/#organization"},"image":{"@id":"https:\/\/wppluginbox.com\/en\/how-to-turn-a-google-sheet-into-a-product-listing-table-in-wordpress\/#primaryimage"},"thumbnailUrl":"https:\/\/wppluginbox.com\/en\/wp-content\/uploads\/2025\/08\/product_datatabl.png","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/wppluginbox.com\/en\/how-to-turn-a-google-sheet-into-a-product-listing-table-in-wordpress\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/wppluginbox.com\/en\/how-to-turn-a-google-sheet-into-a-product-listing-table-in-wordpress\/","url":"https:\/\/wppluginbox.com\/en\/how-to-turn-a-google-sheet-into-a-product-listing-table-in-wordpress\/","name":"How to Turn a Google Sheet into a Product Listing Table","isPartOf":{"@id":"https:\/\/wppluginbox.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/wppluginbox.com\/en\/how-to-turn-a-google-sheet-into-a-product-listing-table-in-wordpress\/#primaryimage"},"image":{"@id":"https:\/\/wppluginbox.com\/en\/how-to-turn-a-google-sheet-into-a-product-listing-table-in-wordpress\/#primaryimage"},"thumbnailUrl":"https:\/\/wppluginbox.com\/en\/wp-content\/uploads\/2025\/08\/product_datatabl.png","datePublished":"2025-08-03T13:55:44+00:00","dateModified":"2025-08-03T19:25:59+00:00","description":"Learn how to create a responsive product listing table in WordPress using the Stylish Google Sheets Reader plugin. Display product images, stock levels, ratings, and purchase links directly from Google Sheets.","breadcrumb":{"@id":"https:\/\/wppluginbox.com\/en\/how-to-turn-a-google-sheet-into-a-product-listing-table-in-wordpress\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/wppluginbox.com\/en\/how-to-turn-a-google-sheet-into-a-product-listing-table-in-wordpress\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/wppluginbox.com\/en\/how-to-turn-a-google-sheet-into-a-product-listing-table-in-wordpress\/#primaryimage","url":"https:\/\/wppluginbox.com\/en\/wp-content\/uploads\/2025\/08\/product_datatabl.png","contentUrl":"https:\/\/wppluginbox.com\/en\/wp-content\/uploads\/2025\/08\/product_datatabl.png","width":1366,"height":757},{"@type":"BreadcrumbList","@id":"https:\/\/wppluginbox.com\/en\/how-to-turn-a-google-sheet-into-a-product-listing-table-in-wordpress\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/wppluginbox.com\/en\/"},{"@type":"ListItem","position":2,"name":"How to Turn a Google Sheet into a Product Listing Table in WordPress"}]},{"@type":"WebSite","@id":"https:\/\/wppluginbox.com\/en\/#website","url":"https:\/\/wppluginbox.com\/en\/","name":"WP Plugin Box \u2013 Custom Web Calculators &amp; WordPress Plugins","description":"Smart web forms, calculators &amp; lead-gen tools for WordPress, Wix, and Squarespace","publisher":{"@id":"https:\/\/wppluginbox.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/wppluginbox.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/wppluginbox.com\/en\/#organization","name":"WP Plugin Box \u2013 Custom Web Calculators &amp; WordPress Plugins","url":"https:\/\/wppluginbox.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/wppluginbox.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/wppluginbox.com\/en\/wp-content\/uploads\/2025\/07\/WP-Plugin-Box-Logo-2.jpg","contentUrl":"https:\/\/wppluginbox.com\/en\/wp-content\/uploads\/2025\/07\/WP-Plugin-Box-Logo-2.jpg","width":1454,"height":1282,"caption":"WP Plugin Box \u2013 Custom Web Calculators &amp; WordPress Plugins"},"image":{"@id":"https:\/\/wppluginbox.com\/en\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/wppluginbox.com\/en\/#\/schema\/person\/7e8d1f33896d21fa38c031e8a7c7219b","name":"Hayyat Apps","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/wppluginbox.com\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/54016c796204b6d51e8e46068f4dd5670937bdc4a1982a190be8ef133e9c6705?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/54016c796204b6d51e8e46068f4dd5670937bdc4a1982a190be8ef133e9c6705?s=96&d=mm&r=g","caption":"Hayyat Apps"},"url":"https:\/\/wppluginbox.com\/en\/author\/hayyat\/"}]}},"_links":{"self":[{"href":"https:\/\/wppluginbox.com\/en\/wp-json\/wp\/v2\/posts\/2948","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wppluginbox.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wppluginbox.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wppluginbox.com\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/wppluginbox.com\/en\/wp-json\/wp\/v2\/comments?post=2948"}],"version-history":[{"count":25,"href":"https:\/\/wppluginbox.com\/en\/wp-json\/wp\/v2\/posts\/2948\/revisions"}],"predecessor-version":[{"id":2982,"href":"https:\/\/wppluginbox.com\/en\/wp-json\/wp\/v2\/posts\/2948\/revisions\/2982"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/wppluginbox.com\/en\/wp-json\/wp\/v2\/media\/2962"}],"wp:attachment":[{"href":"https:\/\/wppluginbox.com\/en\/wp-json\/wp\/v2\/media?parent=2948"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wppluginbox.com\/en\/wp-json\/wp\/v2\/categories?post=2948"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wppluginbox.com\/en\/wp-json\/wp\/v2\/tags?post=2948"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}