{"id":36860,"date":"2015-06-16T18:40:15","date_gmt":"2015-06-16T18:40:15","guid":{"rendered":"https:\/\/wordpress.org\/plugins-wp\/sheets2table\/"},"modified":"2015-06-23T23:21:48","modified_gmt":"2015-06-23T23:21:48","slug":"sheets2table","status":"closed","type":"plugin","link":"https:\/\/ur.wordpress.org\/plugins\/sheets2table\/","author":14453407,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_crdt_document":"","version":"0.4.1","stable_tag":"0.4.1","tested":"4.2.39","requires":"3.9.0","requires_php":"","requires_plugins":"","header_name":"Sheets2Table","header_author":"Tony Hetrick","header_description":"","assets_banners_color":"","last_updated":"2015-06-23 23:21:48","external_support_url":"","external_repository_url":"","donate_link":"http:\/\/dev.tonyhetrick.com\/donations\/","header_plugin_uri":"","header_author_uri":"http:\/\/www.tonyhetrick.com","rating":5,"author_block_rating":0,"active_installs":20,"downloads":3018,"num_ratings":2,"support_threads":0,"support_threads_resolved":0,"author_block_count":0,"sections":["description","installation","faq","changelog"],"tags":[],"upgrade_notice":{"":"<p>We recommend upgrading to the latest version.<\/p>"},"ratings":{"1":0,"2":0,"3":0,"4":0,"5":"2"},"assets_icons":[],"assets_banners":[],"assets_blueprints":{},"all_blocks":[],"tagged_versions":["0.4.0","0.4.1"],"block_files":[],"assets_screenshots":{"screenshot-1.jpg":{"filename":"screenshot-1.jpg","revision":"1182060","resolution":"1","location":"assets"},"screenshot-2.jpg":{"filename":"screenshot-2.jpg","revision":"1182060","resolution":"2","location":"assets"},"screenshot-3.jpg":{"filename":"screenshot-3.jpg","revision":"1182060","resolution":"3","location":"assets"},"screenshot-4.jpg":{"filename":"screenshot-4.jpg","revision":"1182060","resolution":"4","location":"assets"},"screenshot-5.jpg":{"filename":"screenshot-5.jpg","revision":"1182060","resolution":"5","location":"assets"},"screenshot-6.jpg":{"filename":"screenshot-6.jpg","revision":"1182060","resolution":"6","location":"assets"},"screenshot-7.jpg":{"filename":"screenshot-7.jpg","revision":"1182060","resolution":"7","location":"assets"}},"screenshots":{"1":"[Settings - Get CSV file from Google Sheet] (screenshots\/screenshot-1.jpg)","2":"[Settings - Configure the shortcode] (screenshot-3.jpg)","3":"[Sheets2Table render using default settings and theme styles] (screenshot-6.jpg)","4":"[Sheets2Table render using a custom shortcode and FooTable styles] (screenshot-7.jpg)"},"jetpack_post_was_ever_published":false},"plugin_section":[],"plugin_tags":[567,25296,19199,2289],"plugin_category":[],"plugin_contributors":[90919],"plugin_business_model":[],"class_list":["post-36860","plugin","type-plugin","status-closed","hentry","plugin_tags-csv","plugin_tags-google-sheets","plugin_tags-html-table","plugin_tags-table","plugin_contributors-tonyh-1","plugin_committers-tonyh-1"],"banners":[],"icons":{"svg":false,"icon":"https:\/\/s.w.org\/plugins\/geopattern-icon\/sheets2table.svg","icon_2x":false,"generated":true},"screenshots":[{"src":"https:\/\/ps.w.org\/sheets2table\/assets\/screenshot-1.jpg?rev=1182060","caption":"[Settings - Get CSV file from Google Sheet] (screenshots\/screenshot-1.jpg)"},{"src":"https:\/\/ps.w.org\/sheets2table\/assets\/screenshot-2.jpg?rev=1182060","caption":"[Settings - Configure the shortcode] (screenshot-3.jpg)"},{"src":"https:\/\/ps.w.org\/sheets2table\/assets\/screenshot-3.jpg?rev=1182060","caption":"[Sheets2Table render using default settings and theme styles] (screenshot-6.jpg)"},{"src":"https:\/\/ps.w.org\/sheets2table\/assets\/screenshot-4.jpg?rev=1182060","caption":"[Sheets2Table render using a custom shortcode and FooTable styles] (screenshot-7.jpg)"},{"src":"https:\/\/ps.w.org\/sheets2table\/assets\/screenshot-5.jpg?rev=1182060","caption":""},{"src":"https:\/\/ps.w.org\/sheets2table\/assets\/screenshot-6.jpg?rev=1182060","caption":""},{"src":"https:\/\/ps.w.org\/sheets2table\/assets\/screenshot-7.jpg?rev=1182060","caption":""}],"raw_content":"<!--section=description-->\n<p>Building an HTML table is not rocket science, but keeping the HTML table data up to date is cumbersome and can be time consuming or error prone when making frequent updates. An easier solution is to keep the data in a format and platform that is designed for data entry and collaboration and then dynamically render that data as HTML. Sheets2Table creates a snapshot of a Google Sheet and then dynamically displays the tabular data as an HTML table in WordPress. Using the FooTable plugin, the table is made responsive.<\/p>\n\n<p>Sheets2Table provides flexibility by allowing a WordPress admin the ability to save a snapshot of the Google Sheet to a user-defined file name. Using the shortcode configuration tool, the admin can display specific columns and rename the column headers. The admin can create the snapshot manually or set the option so that the current data residing in the Google sheet is displayed on the page.<\/p>\n\n<p><a href=\"https:\/\/dev.tonyhetrick.com\/sheets2table\/\">Sheets2Table WordPress Homepage<\/a> |\n<a href=\"https:\/\/dev.tonyhetrick.com\/sheets2table-help\/\">Sheets2Table WordPress Documentation<\/a> |<\/p>\n\n<h4>Features<\/h4>\n\n<ul>\n<li>Import a CSV file from a Google Sheet only using the document ID<\/li>\n<li>Create a snapshot of the Google Sheet manually, or automatically<\/li>\n<li>Automated tool to build shortcodes<\/li>\n<li>Basic file operations to download or delete CSV files<\/li>\n<li>Multiple CSV files and shortcodes support for limitless tables and combinations<\/li>\n<li>Responsive table by installing the  FooTable plugin<\/li>\n<li>A file-based plugin that does not use database integration<\/li>\n<\/ul>\n\n<!--section=installation-->\n<p><strong>Preferred installation<\/strong><\/p>\n\n<ol>\n<li>Navigate to the plugins page in your Wordpress admin panel<\/li>\n<li>Click on <em>Plugins &gt; Add New<\/em><\/li>\n<li>Search for <em>Sheets2Table<\/em> and press the <em>Install Now<\/em> button<\/li>\n<\/ol>\n\n<p><strong>Manual Installation<\/strong><\/p>\n\n<ol>\n<li>Download the plugin via WordPress.org<\/li>\n<li>Upload the ZIP file through the <em>Plugins &gt; Add New &gt; Upload<\/em> screen in your WordPress dashboard<\/li>\n<li>Activate the plugin through the <em>Plugins<\/em> menu in WordPress<\/li>\n<\/ol>\n\n<!--section=faq-->\n<dl>\n<dt>How can the changes in my Google Spreadsheet automatically be displayed in my Wordpress site?<\/dt>\n<dd><p>As of version 0.4.1, a shortcode option now exists that will always get the current data in the Google Sheet.<\/p>\n\n<ul>\n<li>Naviage to the Shortcodes tab<\/li>\n<li>Click on <em>Customize<\/em> for the shortcode you wish to display<\/li>\n<li>Select the columns to display<\/li>\n<li>Under Other Options, select <em>get-latest-data<\/em>.<\/li>\n<\/ul><\/dd>\n\n<\/dl>\n\n<!--section=changelog-->\n<h4>0.4.1<\/h4>\n\n<ul>\n<li>Added a option to always get the latest tabular data from the Google Sheet instead of having to manually create a snapshot.<\/li>\n<\/ul>\n\n<h4>0.4.0<\/h4>\n\n<ul>\n<li>Initial release<\/li>\n<\/ul>","raw_excerpt":"A simple to use plugin that builds an HTML table from a Google Sheet.","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/ur.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin\/36860","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ur.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin"}],"about":[{"href":"https:\/\/ur.wordpress.org\/plugins\/wp-json\/wp\/v2\/types\/plugin"}],"replies":[{"embeddable":true,"href":"https:\/\/ur.wordpress.org\/plugins\/wp-json\/wp\/v2\/comments?post=36860"}],"author":[{"embeddable":true,"href":"https:\/\/ur.wordpress.org\/plugins\/wp-json\/wporg\/v1\/users\/tonyh-1"}],"wp:attachment":[{"href":"https:\/\/ur.wordpress.org\/plugins\/wp-json\/wp\/v2\/media?parent=36860"}],"wp:term":[{"taxonomy":"plugin_section","embeddable":true,"href":"https:\/\/ur.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_section?post=36860"},{"taxonomy":"plugin_tags","embeddable":true,"href":"https:\/\/ur.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_tags?post=36860"},{"taxonomy":"plugin_category","embeddable":true,"href":"https:\/\/ur.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_category?post=36860"},{"taxonomy":"plugin_contributors","embeddable":true,"href":"https:\/\/ur.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_contributors?post=36860"},{"taxonomy":"plugin_business_model","embeddable":true,"href":"https:\/\/ur.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_business_model?post=36860"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}