{"id":112747,"date":"2019-11-22T00:00:38","date_gmt":"2019-11-22T00:00:38","guid":{"rendered":"https:\/\/wordpress.org\/plugins\/wp-simple-spreadsheet-fetcher-for-google\/"},"modified":"2020-12-15T13:52:37","modified_gmt":"2020-12-15T13:52:37","slug":"wp-simple-spreadsheet-fetcher-for-google","status":"publish","type":"plugin","link":"https:\/\/as.wordpress.org\/plugins\/wp-simple-spreadsheet-fetcher-for-google\/","author":15521368,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_crdt_document":"","version":"0.7.9","stable_tag":"0.7.9","tested":"5.6.17","requires":"5.3","requires_php":"","requires_plugins":"","header_name":"WP Simple Spreadsheet Fetcher for Google","header_author":"Naoki Ohashi","header_description":"Simple plugin to fetch data from google spreadsheet.","assets_banners_color":"c4dacc","last_updated":"2020-12-15 13:52:37","external_support_url":"","external_repository_url":"","donate_link":"","header_plugin_uri":"https:\/\/github.com\/naogify\/wp-simple-google-sheets-fetcher","header_author_uri":"https:\/\/naoki-is-me","rating":4.1,"author_block_rating":0,"active_installs":100,"downloads":7135,"num_ratings":7,"support_threads":0,"support_threads_resolved":0,"author_block_count":0,"sections":["installation","changelog","description"],"tags":{"0.2.2":{"tag":"0.2.2","author":"naoki0h","date":"2019-11-22 00:16:49"},"0.2.3":{"tag":"0.2.3","author":"naoki0h","date":"2019-11-30 14:14:15"},"0.2.4":{"tag":"0.2.4","author":"naoki0h","date":"2019-11-30 15:06:09"},"0.2.5":{"tag":"0.2.5","author":"naoki0h","date":"2019-12-03 15:50:36"},"0.2.6":{"tag":"0.2.6","author":"naoki0h","date":"2019-12-04 01:54:15"},"0.2.7":{"tag":"0.2.7","author":"naoki0h","date":"2019-12-04 02:25:48"},"0.3.0":{"tag":"0.3.0","author":"naoki0h","date":"2019-12-13 15:53:34"},"0.3.1":{"tag":"0.3.1","author":"naoki0h","date":"2019-12-18 08:54:22"},"0.3.2":{"tag":"0.3.2","author":"naoki0h","date":"2019-12-20 00:43:28"},"0.3.3":{"tag":"0.3.3","author":"naoki0h","date":"2019-12-27 05:16:10"},"0.3.4":{"tag":"0.3.4","author":"naoki0h","date":"2019-12-28 13:20:53"},"0.3.5":{"tag":"0.3.5","author":"naoki0h","date":"2019-12-29 22:42:47"},"0.3.6":{"tag":"0.3.6","author":"naoki0h","date":"2019-12-30 01:45:41"},"0.3.7":{"tag":"0.3.7","author":"naoki0h","date":"2020-01-05 17:12:07"},"0.3.8":{"tag":"0.3.8","author":"naoki0h","date":"2020-01-07 14:48:24"},"0.3.9":{"tag":"0.3.9","author":"naoki0h","date":"2020-01-07 14:54:18"},"0.4.0":{"tag":"0.4.0","author":"naoki0h","date":"2020-01-07 23:55:11"},"0.4.1":{"tag":"0.4.1","author":"naoki0h","date":"2020-01-08 00:14:43"},"0.4.8":{"tag":"0.4.8","author":"naoki0h","date":"2020-01-08 14:18:32"},"0.4.9":{"tag":"0.4.9","author":"naoki0h","date":"2020-01-08 14:26:42"},"0.5.0":{"tag":"0.5.0","author":"naoki0h","date":"2020-01-08 14:43:29"},"0.5.1":{"tag":"0.5.1","author":"naoki0h","date":"2020-01-10 04:56:31"},"0.5.2":{"tag":"0.5.2","author":"naoki0h","date":"2020-01-10 14:41:39"},"0.6.0":{"tag":"0.6.0","author":"naoki0h","date":"2020-02-09 13:56:49"},"0.6.1":{"tag":"0.6.1","author":"naoki0h","date":"2020-02-10 15:47:40"},"0.6.2":{"tag":"0.6.2","author":"naoki0h","date":"2020-03-08 06:12:25"},"0.6.3":{"tag":"0.6.3","author":"naoki0h","date":"2020-03-08 06:25:48"},"0.6.4":{"tag":"0.6.4","author":"naoki0h","date":"2020-04-11 07:41:29"},"0.6.5":{"tag":"0.6.5","author":"naoki0h","date":"2020-04-11 07:44:02"},"0.6.6":{"tag":"0.6.6","author":"naoki0h","date":"2020-04-11 07:46:38"},"0.6.7":{"tag":"0.6.7","author":"naoki0h","date":"2020-04-11 08:28:11"},"0.6.7.2":{"tag":"0.6.7.2","author":"naoki0h","date":"2020-04-11 08:45:14"},"0.6.7.5":{"tag":"0.6.7.5","author":"naoki0h","date":"2020-04-11 16:11:11"},"0.6.8":{"tag":"0.6.8","author":"naoki0h","date":"2020-04-12 00:38:59"},"0.6.9":{"tag":"0.6.9","author":"naoki0h","date":"2020-05-24 01:30:00"},"0.7.0":{"tag":"0.7.0","author":"naoki0h","date":"2020-05-27 14:57:05"},"0.7.1":{"tag":"0.7.1","author":"naoki0h","date":"2020-05-27 15:05:41"},"0.7.2":{"tag":"0.7.2","author":"naoki0h","date":"2020-05-29 13:57:47"},"0.7.3":{"tag":"0.7.3","author":"naoki0h","date":"2020-05-29 15:31:19"},"0.7.5":{"tag":"0.7.5","author":"naoki0h","date":"2020-07-16 03:51:58"},"0.7.6":{"tag":"0.7.6","author":"naoki0h","date":"2020-11-03 07:23:11"},"0.7.7":{"tag":"0.7.7","author":"naoki0h","date":"2020-11-25 16:10:02"},"0.7.8":{"tag":"0.7.8","author":"naoki0h","date":"2020-11-28 03:30:45"},"0.7.9":{"tag":"0.7.9","author":"naoki0h","date":"2020-12-15 13:52:37"}},"upgrade_notice":{"0.1.0":"<p>First commit.<\/p>"},"ratings":{"1":1,"2":0,"3":1,"4":0,"5":5},"assets_icons":{"icon-128x128.png":{"filename":"icon-128x128.png","revision":2211637,"resolution":"128x128","location":"assets","locale":""}},"assets_banners":{"banner-772x250.png":{"filename":"banner-772x250.png","revision":2211649,"resolution":"772x250","location":"assets","locale":""}},"assets_blueprints":{},"all_blocks":{"wp2s2fg\/fetcher":{"name":"wp2s2fg\/fetcher","title":"Table"},"wp2s2fg\/fetcher-advanced":{"name":"wp2s2fg\/fetcher-advanced","title":"Advanced (Deprecated in next update)"},"wp2s2fg\/fetcher-item":{"name":"wp2s2fg\/fetcher-item","title":"Fetcher Item"},"wp2s2fg\/fetcher-chart":{"name":"wp2s2fg\/fetcher-chart","title":"Chart"}},"tagged_versions":["0.2.2","0.2.3","0.2.4","0.2.5","0.2.6","0.2.7","0.3.0","0.3.1","0.3.2","0.3.3","0.3.4","0.3.5","0.3.6","0.3.7","0.3.8","0.3.9","0.4.0","0.4.1","0.4.8","0.4.9","0.5.0","0.5.1","0.5.2","0.6.0","0.6.1","0.6.2","0.6.3","0.6.4","0.6.5","0.6.6","0.6.7","0.6.7.2","0.6.7.5","0.6.8","0.6.9","0.7.0","0.7.1","0.7.2","0.7.3","0.7.5","0.7.6","0.7.7","0.7.8","0.7.9"],"block_files":[],"assets_screenshots":{"screenshot-2.png":{"filename":"screenshot-2.png","revision":2439863,"resolution":"2","location":"plugin"},"screenshot-1.png":{"filename":"screenshot-1.png","revision":2439863,"resolution":"1","location":"plugin"}},"screenshots":{"1":"Fetch and display data from Google Sheets."},"jetpack_post_was_ever_published":false},"plugin_section":[],"plugin_tags":[1556,56998,25296],"plugin_category":[],"plugin_contributors":[156356],"plugin_business_model":[],"class_list":["post-112747","plugin","type-plugin","status-publish","hentry","plugin_tags-api","plugin_tags-fetcher","plugin_tags-google-sheets","plugin_contributors-naoki0h","plugin_committers-naoki0h"],"banners":{"banner":"https:\/\/ps.w.org\/wp-simple-spreadsheet-fetcher-for-google\/assets\/banner-772x250.png?rev=2211649","banner_2x":false,"banner_rtl":false,"banner_2x_rtl":false},"icons":{"svg":false,"icon":"https:\/\/ps.w.org\/wp-simple-spreadsheet-fetcher-for-google\/assets\/icon-128x128.png?rev=2211637","icon_2x":false,"generated":false},"screenshots":[{"src":"https:\/\/ps.w.org\/wp-simple-spreadsheet-fetcher-for-google\/trunk\/screenshot-1.png?rev=2439863","caption":"Fetch and display data from Google Sheets."},{"src":"https:\/\/ps.w.org\/wp-simple-spreadsheet-fetcher-for-google\/trunk\/screenshot-2.png?rev=2439863","caption":""}],"raw_content":"<!--section=installation-->\n<ol>\n<li>Download the zip, extract it and upload the extracted folder to your-wp-directory\/wp-content\/plugins\/<\/li>\n<li>Go to the plugins administration screen in your WordPress admin and activate the plugin.<\/li>\n<\/ol>\n\n<!--section=changelog-->\n<h4>0.7.9<\/h4>\n\n<ul>\n<li>Tested up to WordPress 5.6.<\/li>\n<\/ul>\n\n<h4>0.7.8<\/h4>\n\n<ul>\n<li>[Feature][Table] remove auto convert url to link feature.<\/li>\n<\/ul>\n\n<h4>0.7.7<\/h4>\n\n<ul>\n<li>[Feature][Table] enable to fetch HTML from Google Sheets.<\/li>\n<\/ul>\n\n<h4>0.7.6<\/h4>\n\n<ul>\n<li>Fix bug, and add validation message.<\/li>\n<\/ul>\n\n<h4>0.7.5<\/h4>\n\n<ul>\n<li>Fix bug.<\/li>\n<\/ul>\n\n<h4>0.7.3<\/h4>\n\n<ul>\n<li>Add notification for turning on sharing setting.<\/li>\n<\/ul>\n\n<h4>0.7.2<\/h4>\n\n<ul>\n<li>Translate button text in api key setting page.<\/li>\n<\/ul>\n\n<h4>0.7.1<\/h4>\n\n<ul>\n<li>Introduce Chart block.<\/li>\n<li>Change minimum required version 5.0 to 5.3.<\/li>\n<\/ul>\n\n<p>= 0.6.8=\n- Add css backward compatibility.<\/p>\n\n<h4>0.6.4<\/h4>\n\n<ul>\n<li>Fix sidebar css for WordPress5.4<\/li>\n<li>Simplify sidebar UI.<\/li>\n<li>Fix RangeControl bug in WordPress5.4.<\/li>\n<\/ul>\n\n<h4>0.6.1<\/h4>\n\n<ul>\n<li>Fix css.<\/li>\n<\/ul>\n\n<h4>0.6.0<\/h4>\n\n<ul>\n<li>Add sidebar settings to customize table style<\/li>\n<li>Deprecated css style.<\/li>\n<\/ul>\n\n<h4>0.5.2<\/h4>\n\n<ul>\n<li>Fix version.<\/li>\n<\/ul>\n\n<h4>0.5.1<\/h4>\n\n<ul>\n<li>Fix to load translation file for text in javascript.<\/li>\n<\/ul>\n\n<h4>0.4.9<\/h4>\n\n<ul>\n<li>Fix version.<\/li>\n<\/ul>\n\n<h4>0.4.8<\/h4>\n\n<ul>\n<li>Fix version.<\/li>\n<\/ul>\n\n<h4>0.4.7<\/h4>\n\n<ul>\n<li>Fix version.<\/li>\n<\/ul>\n\n<h4>0.4.6<\/h4>\n\n<ul>\n<li>Fix version.<\/li>\n<\/ul>\n\n<h4>0.4.2<\/h4>\n\n<ul>\n<li>Fix version.<\/li>\n<li>Fix develop tool.<\/li>\n<\/ul>\n\n<h4>0.4.1<\/h4>\n\n<ul>\n<li>Fix version.<\/li>\n<\/ul>\n\n<h4>0.4.0<\/h4>\n\n<ul>\n<li>Fix version.<\/li>\n<\/ul>\n\n<h4>0.3.9<\/h4>\n\n<ul>\n<li>Fix version.<\/li>\n<\/ul>\n\n<h4>0.3.7<\/h4>\n\n<ul>\n<li>Fix text message in fecher advanced block<\/li>\n<li>Fix css.<\/li>\n<li>Fix CSRF.<\/li>\n<\/ul>\n\n<h4>0.3.6<\/h4>\n\n<ul>\n<li>Add japanese translation for text in javascript.<\/li>\n<\/ul>\n\n<h4>0.3.4<\/h4>\n\n<ul>\n<li>Fix text and i18n.<\/li>\n<\/ul>\n\n<h4>0.3.3<\/h4>\n\n<ul>\n<li>Fix text and i18n.<\/li>\n<\/ul>\n\n<h4>0.3.2<\/h4>\n\n<ul>\n<li>Fix user interface.<\/li>\n<\/ul>\n\n<h4>0.3.1<\/h4>\n\n<ul>\n<li>Fix user interface.<\/li>\n<\/ul>\n\n<h4>0.3.0<\/h4>\n\n<ul>\n<li>Fix user interface<\/li>\n<li>Enable to set sheet id from each fetcher block.<\/li>\n<\/ul>\n\n<h4>0.2.7<\/h4>\n\n<ul>\n<li>Bug fix.<\/li>\n<\/ul>\n\n<h4>0.2.6<\/h4>\n\n<ul>\n<li>Bug fix.<\/li>\n<\/ul>\n\n<h4>0.2.5<\/h4>\n\n<ul>\n<li>Delete parser block, add fetcher and fetcher advanced blocks.<\/li>\n<li>Fix some.<\/li>\n<\/ul>\n\n<h4>0.2.4<\/h4>\n\n<p>Just fix text.<\/p>\n\n<h4>0.2.3<\/h4>\n\n<p>Fix the description, and add event register layout.<\/p>\n\n<h4>0.2.0<\/h4>\n\n<p>Fix to register wordpress.org.<\/p>\n\n<h4>0.1.0<\/h4>\n\n<p>First commit.<\/p>\n\n<!--section=description-->\n<p>This is the simple plugin to fetch data from Google Sheets and display it on your website.\nThis plugin only works with Block Editor, doesn't support Classic Editor.<\/p>\n\n<h3>How to use<\/h3>\n\n<ol>\n<li>Create the api key. For more detail. Please refer to <a href=\"https:\/\/developers.google.com\/sheets\/api\/quickstart\/js#step_1_turn_on_the\">https:\/\/developers.google.com\/sheets\/api\/quickstart\/js#step_1_turn_on_the<\/a>.<\/li>\n<li>Move to the settings page from side menu that Plugins &gt; WP Simple Google Sheets Fetcher.<\/li>\n<li>Save your API key at the settings page.<\/li>\n<li>Turn on Get shareable link. For more detail. Please refer to <a href=\"https:\/\/support.google.com\/drive\/answer\/2494822#link_sharing\">https:\/\/support.google.com\/drive\/answer\/2494822#link_sharing<\/a><\/li>\n<li>Choose \"Fetcher\" block at the \"WP Simple Spreadsheet Fetcher for Google\" category, use side panel to indicate the cell to fetch data.<\/li>\n<li>It will display the data in your post or page.<\/li>\n<\/ol>\n\n<p>[youtube https:\/\/youtu.be\/VYMFFMyRK3I]<\/p>\n\n<h3>Contact<\/h3>\n\n<p>If you have anything to tell me, please post it on the plugin's support forum or reply or message me on twitter @naogify.<\/p>","raw_excerpt":"This is the simple plugin to fetch data from Google Sheets and display it on your website. This plugin only works with Block Editor, doesn&#039;t supp &hellip;","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/as.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin\/112747","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/as.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin"}],"about":[{"href":"https:\/\/as.wordpress.org\/plugins\/wp-json\/wp\/v2\/types\/plugin"}],"replies":[{"embeddable":true,"href":"https:\/\/as.wordpress.org\/plugins\/wp-json\/wp\/v2\/comments?post=112747"}],"author":[{"embeddable":true,"href":"https:\/\/as.wordpress.org\/plugins\/wp-json\/wporg\/v1\/users\/naoki0h"}],"wp:attachment":[{"href":"https:\/\/as.wordpress.org\/plugins\/wp-json\/wp\/v2\/media?parent=112747"}],"wp:term":[{"taxonomy":"plugin_section","embeddable":true,"href":"https:\/\/as.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_section?post=112747"},{"taxonomy":"plugin_tags","embeddable":true,"href":"https:\/\/as.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_tags?post=112747"},{"taxonomy":"plugin_category","embeddable":true,"href":"https:\/\/as.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_category?post=112747"},{"taxonomy":"plugin_contributors","embeddable":true,"href":"https:\/\/as.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_contributors?post=112747"},{"taxonomy":"plugin_business_model","embeddable":true,"href":"https:\/\/as.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_business_model?post=112747"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}