{"id":189603,"date":"2024-05-06T04:26:38","date_gmt":"2024-05-06T04:26:38","guid":{"rendered":"https:\/\/wordpress.org\/plugins\/sheet-to-table-live-sync-from-google-sheet\/"},"modified":"2025-04-21T13:11:32","modified_gmt":"2025-04-21T13:11:32","slug":"sheet-to-wp-table-for-google-sheet","status":"publish","type":"plugin","link":"https:\/\/fr-be.wordpress.org\/plugins\/sheet-to-wp-table-for-google-sheet\/","author":13614411,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_crdt_document":"","version":"1.0.3","stable_tag":"1.0.3","tested":"6.8.5","requires":"4.0.0","requires_php":"7.2","requires_plugins":null,"header_name":"Sheet to Table Live Sync for Google Sheet","header_author":"Saiful Islam","header_description":"Sync Google Sheets live on WordPress. Lightning-fast, cached tables using shortcodes or the intuitive Dashboard interface. Effortlessly display dynamic data, enhancing your site's functionality.","assets_banners_color":"3f8b68","last_updated":"2025-04-21 13:11:32","external_support_url":"","external_repository_url":"","donate_link":"https:\/\/donate.stripe.com\/4gw2bB2Pzdjd8mYfYZ","header_plugin_uri":"https:\/\/codeastrology.com\/sheet-to-table-live-sync-from-google-sheet\/","header_author_uri":"https:\/\/profiles.wordpress.org\/codersaiful\/#content-plugins","rating":5,"author_block_rating":0,"active_installs":100,"downloads":2958,"num_ratings":1,"support_threads":0,"support_threads_resolved":0,"author_block_count":0,"sections":["description","installation","faq","changelog"],"tags":{"1.0.0":{"tag":"1.0.0","author":"codersaiful","date":"2024-05-15 12:22:08"},"1.0.1":{"tag":"1.0.1","author":"codersaiful","date":"2024-08-13 12:36:30"},"1.0.2":{"tag":"1.0.2","author":"codersaiful","date":"2024-08-13 12:36:30"},"1.0.3":{"tag":"1.0.3","author":"codersaiful","date":"2025-04-21 13:11:32"}},"upgrade_notice":[],"ratings":{"1":0,"2":0,"3":0,"4":0,"5":1},"assets_icons":{"icon-128x128.png":{"filename":"icon-128x128.png","revision":3267449,"resolution":"128x128","location":"assets","locale":""},"icon-256x256.png":{"filename":"icon-256x256.png","revision":3267449,"resolution":"256x256","location":"assets","locale":""}},"assets_banners":{"banner-1544x500.png":{"filename":"banner-1544x500.png","revision":3267449,"resolution":"1544x500","location":"assets","locale":""},"banner-772x250.png":{"filename":"banner-772x250.png","revision":3267449,"resolution":"772x250","location":"assets","locale":""}},"assets_blueprints":{},"all_blocks":[],"tagged_versions":["1.0.0","1.0.1","1.0.2","1.0.3"],"block_files":[],"assets_screenshots":{"Screenshot-1.png":{"filename":"Screenshot-1.png","revision":3240926,"resolution":"1","location":"assets","locale":""},"Screenshot-11.png":{"filename":"Screenshot-11.png","revision":3278184,"resolution":"11","location":"assets","locale":""},"Screenshot-2.png":{"filename":"Screenshot-2.png","revision":3240926,"resolution":"2","location":"assets","locale":""},"Screenshot-3.png":{"filename":"Screenshot-3.png","revision":3240926,"resolution":"3","location":"assets","locale":""},"Screenshot-4.png":{"filename":"Screenshot-4.png","revision":3240927,"resolution":"4","location":"assets","locale":""}},"screenshots":{"1":"Getting Start","2":"Add new Table","3":"Table on Frontend from Sheet"},"jetpack_post_was_ever_published":false},"plugin_section":[],"plugin_tags":[73181,227380,227379],"plugin_category":[],"plugin_contributors":[144129],"plugin_business_model":[],"class_list":["post-189603","plugin","type-plugin","status-publish","hentry","plugin_tags-bulk-edit-product","plugin_tags-google-sheet-sync","plugin_tags-stoc-sync-with-google-sheet","plugin_contributors-codersaiful","plugin_committers-codersaiful","plugin_support_reps-bizzplugin","plugin_support_reps-bmnazmul","plugin_support_reps-sarmina5"],"banners":{"banner":"https:\/\/ps.w.org\/sheet-to-wp-table-for-google-sheet\/assets\/banner-772x250.png?rev=3267449","banner_2x":"https:\/\/ps.w.org\/sheet-to-wp-table-for-google-sheet\/assets\/banner-1544x500.png?rev=3267449","banner_rtl":false,"banner_2x_rtl":false},"icons":{"svg":false,"icon":"https:\/\/ps.w.org\/sheet-to-wp-table-for-google-sheet\/assets\/icon-128x128.png?rev=3267449","icon_2x":"https:\/\/ps.w.org\/sheet-to-wp-table-for-google-sheet\/assets\/icon-256x256.png?rev=3267449","generated":false},"screenshots":[{"src":"https:\/\/ps.w.org\/sheet-to-wp-table-for-google-sheet\/assets\/Screenshot-1.png?rev=3240926","caption":"Getting Start"},{"src":"https:\/\/ps.w.org\/sheet-to-wp-table-for-google-sheet\/assets\/Screenshot-2.png?rev=3240926","caption":"Add new Table"},{"src":"https:\/\/ps.w.org\/sheet-to-wp-table-for-google-sheet\/assets\/Screenshot-3.png?rev=3240926","caption":"Table on Frontend from Sheet"},{"src":"https:\/\/ps.w.org\/sheet-to-wp-table-for-google-sheet\/assets\/Screenshot-4.png?rev=3240927","caption":""},{"src":"https:\/\/ps.w.org\/sheet-to-wp-table-for-google-sheet\/assets\/Screenshot-11.png?rev=3278184","caption":""}],"raw_content":"<!--section=description-->\n<p>Elevate your WordPress site's functionality with our innovative plugin, Sheet to Table Live Sync for Google Sheet. Seamlessly synchronize Google Sheets in real-time and enjoy the benefits of a cached feature that ensures lightning-fast table loading directly from your site \u2013 no constant syncing with Google servers required.<\/p>\n\n<p><strong>Key Features:<\/strong><\/p>\n\n<ul>\n<li><strong>Live Google Sheet Sync:<\/strong> Stay connected with your Google Sheets effortlessly. Sync in real-time to ensure your WordPress tables are always up-to-date.<\/li>\n<li><strong>Smart Caching for Instant Loading:<\/strong> Optimize performance with our intelligent caching feature. Your tables load instantly from your site, eliminating the need for continuous syncing with Google servers. Experience unparalleled speed and efficiency.<\/li>\n<li><strong>Intuitive Shortcodes:<\/strong> Easy implementation with customization options.<\/li>\n<li><strong>Dashboard Ease:<\/strong> Create and customize tables effortlessly from your WordPress dashboard.<\/li>\n<li><strong>Table Design:<\/strong> Customize your table design, Specially table template.<\/li>\n<\/ul>\n\n<p><strong>Easy Shortcode Integration:<\/strong><\/p>\n\n<p>Effortlessly display your Google Sheet data on your WordPress site using our simple shortcodes. Choose from two convenient methods<\/p>\n\n<p><strong>Method 1: (Dashboard Deligh)<\/strong><\/p>\n\n<ul>\n<li>Navigate to your WordPress Dashboard &gt; Sheet to Table &gt; Add New.<\/li>\n<li>Enter your Google Sheet URL in the 'Sheet URL' field.<\/li>\n<li>Customize settings and preview your table.<\/li>\n<li>Publish your post to generate a shortcode like [STWT_Sheet_Table id='2560' name='Table Title'].<\/li>\n<li>id: it's post id of that table.<\/li>\n<li>name: it's optional. To identify shortcode. No need for Display Sheet table.<\/li>\n<\/ul>\n\n<p><strong>Method 2: (Shortcode Magic)<\/strong><\/p>\n\n<ul>\n<li>Use the shortcode [STWT_Sheet_Table sheet_url='google_sheet_url' refresh='86400'].<\/li>\n<li>Replace 'google_sheet_url' with your Google Sheet URL.<\/li>\n<li>Set the refresh attribute to determine how frequently your table syncs with Google servers (in seconds).<\/li>\n<\/ul>\n\n<p><strong>How to Get Started:<\/strong>\n* Install the \"Sheet to Table Live Sync for Google Sheet\" plugin.\n* Connect your Google Sheets effortlessly.\n* Choose your preferred shortcode integration method.\n* Enjoy real-time updates and lightning-fast table loading on your WordPress site.<\/p>\n\n<p><strong>Why Choose<\/strong><\/p>\n\n<ul>\n<li><strong>Efficiency:<\/strong> No more delays in data updates. Our plugin ensures real-time synchronization with Google Sheets.<\/li>\n<li><strong>Speed:<\/strong> Experience blazing-fast table loading directly from your site, thanks to our smart caching feature.<\/li>\n<li><strong>User-Friendly:<\/strong> Intuitive shortcodes and an easy-to-navigate dashboard make integrating and customizing tables a breeze.<\/li>\n<\/ul>\n\n<p>Ensure a smooth setup process by following these steps to connect your WordPress site with Google Sheets using our plugin.\nPlease follow, following steps:<\/p>\n\n<ul>\n<li><a href=\"https:\/\/codeastrology.com\/sheet-to-table-live-sync-from-google-sheet\/\">Tutorial - Setup Guideline<\/a> - Checkout and follow step by step guideline. How can connect.<\/li>\n<li><a href=\"https:\/\/docs.google.com\/spreadsheets\/\">Link Google Sheet<\/a> - Create new spreadsheet or use existing. In the plugin settings, find the section to link your Google Sheet. Provide the required Google Sheet URL and configure additional settings as needed.<\/li>\n<\/ul>\n\n<p><strong>Credits<\/strong><\/p>\n\n<p>We believe in giving credit where it's due. Our plugin utilizes the following third-party resources to enhance its functionality:<\/p>\n\n<ul>\n<li>DataTables: Effortlessly display dynamic data, enhancing your site's functionality, Thanks to <a href=\"https:\/\/datatables.net\/\">DataTables<\/a><\/li>\n<li>Fontello Icons: We express our gratitude to <a href=\"https:\/\/github.com\/fontello\/fontello#developers-api\">Fontello<\/a> for providing the icon font used in our plugin's user interface. Beautiful and customizable icons make the user experience more visually appealing.<\/li>\n<li>Google Sheet API: A big thank you to the <a href=\"https:\/\/developers.google.com\/sheets\/api\/reference\/rest\">Google Sheets API<\/a> for enabling seamless integration between our plugin and Google Sheets. This API plays a pivotal role in automating the synchronization of product data.<\/li>\n<li><a href=\"https:\/\/wordpress.org\/\">WordPress<\/a>: We are indebted to the WordPress platform for providing the framework that powers our plugin. Its open-source nature and extensive community support make it an ideal environment for creating powerful and customizable solutions.<\/li>\n<\/ul>\n\n<p>These entities have significantly contributed to the functionality, aesthetics, and overall success of our plugin. We are proud to acknowledge and appreciate their role in making our plugin a reality.<\/p>\n\n<p><strong>Important Links<\/strong><\/p>\n\n<ul>\n<li><a href=\"https:\/\/support.google.com\/docs\/answer\/2494822?hl=en\">Share your sheet PUBLIC<\/a><\/li>\n<li><a href=\"https:\/\/cloud.google.com\/workflows\/docs\/reference\/googleapis\/sheets\/Overview\">Google Sheets API Connector Overview<\/a><\/li>\n<\/ul>\n\n<!--section=installation-->\n<ol>\n<li>Upload 'sheet-to-wp-table-for-google-sheet' to the '\/wp-content\/plugins\/' directory<\/li>\n<li>Activate the plugin through the 'Plugins' menu in WordPress<\/li>\n<li>Connect with Google Sheet by Publish Share permission.<\/li>\n<\/ol>\n\n<!--section=faq-->\n<dl>\n<dt id='menu%20location'><h3>Menu Location<\/h3><\/dt>\n<dd><p>\ud83d\udd05 Dashboard -&gt; Sheet to Table<\/p><\/dd>\n<dt id='do%20i%20need%20to%20sheet%20will%20be%20public%3F'><h3>Do I need to sheet will be public?<\/h3><\/dt>\n<dd><p>\ud83d\udd05 Yes, You have to share your table public with view permision only.<\/p><\/dd>\n\n<\/dl>\n\n<!--section=changelog-->\n<h4>1.0.2<\/h4>\n\n<ul>\n<li>Sheet URL and GID empty issue has been solved. <\/li>\n<li>Now you can use shortcode to display table from any where.<\/li>\n<li>Design has been improved.<\/li>\n<li>Table Design has been improved.<\/li>\n<li>Tested with latest WordPress.<\/li>\n<li>Bug fixed<\/li>\n<\/ul>\n\n<h4>1.0.1<\/h4>\n\n<ul>\n<li>sheet url and gid empty issue has been solved. <\/li>\n<\/ul>\n\n<h4>1.0.0<\/h4>\n\n<ul>\n<li>Primary released.<\/li>\n<\/ul>","raw_excerpt":"Sync Google Sheets live on WordPress. Lightning-fast, cached tables using shortcodes or the intuitive Dashboard interface.","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/fr-be.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin\/189603","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fr-be.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin"}],"about":[{"href":"https:\/\/fr-be.wordpress.org\/plugins\/wp-json\/wp\/v2\/types\/plugin"}],"replies":[{"embeddable":true,"href":"https:\/\/fr-be.wordpress.org\/plugins\/wp-json\/wp\/v2\/comments?post=189603"}],"author":[{"embeddable":true,"href":"https:\/\/fr-be.wordpress.org\/plugins\/wp-json\/wporg\/v1\/users\/codersaiful"}],"wp:attachment":[{"href":"https:\/\/fr-be.wordpress.org\/plugins\/wp-json\/wp\/v2\/media?parent=189603"}],"wp:term":[{"taxonomy":"plugin_section","embeddable":true,"href":"https:\/\/fr-be.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_section?post=189603"},{"taxonomy":"plugin_tags","embeddable":true,"href":"https:\/\/fr-be.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_tags?post=189603"},{"taxonomy":"plugin_category","embeddable":true,"href":"https:\/\/fr-be.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_category?post=189603"},{"taxonomy":"plugin_contributors","embeddable":true,"href":"https:\/\/fr-be.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_contributors?post=189603"},{"taxonomy":"plugin_business_model","embeddable":true,"href":"https:\/\/fr-be.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_business_model?post=189603"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}