Title: WP Simple Spreadsheet Fetcher for Google Author: Naoki Ohashi Published: November 22, 2019 Last modified: December 15, 2020 --- Search plugins ![](https://ps.w.org/wp-simple-spreadsheet-fetcher-for-google/assets/banner-772x250. png?rev=2211649) This plugin **hasn’t been tested with the latest 3 major releases of WordPress**. It may no longer be maintained or supported and may have compatibility issues when used with more recent versions of WordPress. ![](https://ps.w.org/wp-simple-spreadsheet-fetcher-for-google/assets/icon-128x128. png?rev=2211637) # WP Simple Spreadsheet Fetcher for Google By [Naoki Ohashi](https://profiles.wordpress.org/naoki0h/) [Download](https://downloads.wordpress.org/plugin/wp-simple-spreadsheet-fetcher-for-google.0.7.9.zip) * [Details](https://test.wordpress.org/plugins/wp-simple-spreadsheet-fetcher-for-google/#description) * [Reviews](https://test.wordpress.org/plugins/wp-simple-spreadsheet-fetcher-for-google/#reviews) * [Installation](https://test.wordpress.org/plugins/wp-simple-spreadsheet-fetcher-for-google/#installation) * [Development](https://test.wordpress.org/plugins/wp-simple-spreadsheet-fetcher-for-google/#developers) [Support](https://wordpress.org/support/plugin/wp-simple-spreadsheet-fetcher-for-google/) ## Description 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’t support Classic Editor. ### How to use 1. Create the api key. For more detail. Please refer to [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). 2. Move to the settings page from side menu that Plugins > WP Simple Google Sheets Fetcher. 3. Save your API key at the settings page. 4. Turn on Get shareable link. For more detail. Please refer to [https://support.google.com/drive/answer/2494822#link_sharing](https://support.google.com/drive/answer/2494822#link_sharing) 5. Choose “Fetcher” block at the “WP Simple Spreadsheet Fetcher for Google” category, use side panel to indicate the cell to fetch data. 6. It will display the data in your post or page. ### Contact If you have anything to tell me, please post it on the plugin’s support forum or reply or message me on twitter @naogify. ## Screenshots [⌊Fetch and display data from Google Sheets.⌉⌊Fetch and display data from Google Sheets.⌉[ Fetch and display data from Google Sheets. [[ ## Blocks This plugin provides 4 blocks. * Table * Advanced (Deprecated in next update) * Fetcher Item * Chart ## Installation 1. Download the zip, extract it and upload the extracted folder to your-wp-directory/ wp-content/plugins/ 2. Go to the plugins administration screen in your WordPress admin and activate the plugin. ## Reviews ![](https://secure.gravatar.com/avatar/f25b3a48a0878cd4a8fc8c4ca43a1cdca343b266d9b481e9b9a87ddb700881a5? s=60&d=retro&r=g) ### 󠀁[ありがとうございました](https://wordpress.org/support/topic/%e3%81%82%e3%82%8a%e3%81%8c%e3%81%a8%e3%81%86%e3%81%94%e3%81%96%e3%81%84%e3%81%be%e3%81%97%e3%81%9f/)󠁿 [Taufan](https://profiles.wordpress.org/taufanxxx/) October 8, 2021 🙏 ![](https://secure.gravatar.com/avatar/667ccdea9664d56a73be14d8a339434cf91a57dfd9e7de3f2ae668a5356dcfcd? s=60&d=retro&r=g) ### 󠀁[good idea but not working](https://wordpress.org/support/topic/good-idea-but-not-working-4/)󠁿 [Wong](https://profiles.wordpress.org/wsjwong/) May 28, 2021 “Error loading block: The response is not a valid JSON response. “ ![](https://secure.gravatar.com/avatar/139ecda5ecf675bb742c6c7cfdf32c572d698fcc032a879850128624b398e4de? s=60&d=retro&r=g) ### 󠀁[Only fetches simple data, no HTML](https://wordpress.org/support/topic/only-fetches-simple-data-no-html/)󠁿 [webblish](https://profiles.wordpress.org/webblish/) September 18, 2020 1 reply It works fine, but you have to realise that it only fetches simple data. HTML or images are not parsed. A pity, since I would like to use it as a simple price comparison table (with affiliate links etc). I’ll unse the more extensive TablePress plugin( with lots of extensions…) inbstead. ![](https://secure.gravatar.com/avatar/996c9ba9ef445a249682ba6802928a7641ef9c6d4232ae0cc89c8b0a83d93cb9? s=60&d=retro&r=g) ### 󠀁[Make it CLEAR this only works with BLOCKS](https://wordpress.org/support/topic/make-it-clear-this-only-works-with-blocks/)󠁿 [adabob](https://profiles.wordpress.org/adabob/) June 11, 2020 1 reply There are many people who don’t care for Gutenberg or Block Editors we use Classic and need a way to embed sheets. But again another plugin that has no clear info as to it ONLY works with Blocks ![](https://secure.gravatar.com/avatar/eca203e57fe992012ae0d24c9943cd1cf031fb0e6a8d37523cfc23f609402100? s=60&d=retro&r=g) ### 󠀁[Amazing Spreadsheet Fetcher for Google](https://wordpress.org/support/topic/amazing-spreadsheet-fetcher-for-google/)󠁿 [Jobert Buys](https://profiles.wordpress.org/jabumite/) May 9, 2020 Great work thanks for the plugin. Absolutely wonderful! ![](https://secure.gravatar.com/avatar/937fa36961b5bdd18b73d4eb34b06d11cb13cb9f8c2f2e36e22ed5edfd5d11d7? s=60&d=retro&r=g) ### 󠀁[Great. We can synch page with spreadsheet!](https://wordpress.org/support/topic/great-we-can-synch-page-with-spreadsheet/)󠁿 [Akira Tachibana](https://profiles.wordpress.org/atachibana/) January 5, 2020 This plugin synchronizes the web page with Google spreadsheet at real time. Setup of Google side is messy but detailed instruction plus video made it easy. Great works. [ Read all 7 reviews ](https://wordpress.org/support/plugin/wp-simple-spreadsheet-fetcher-for-google/reviews/) ## Contributors & Developers “WP Simple Spreadsheet Fetcher for Google” is open source software. The following people have contributed to this plugin. Contributors * [ Naoki Ohashi ](https://profiles.wordpress.org/naoki0h/) “WP Simple Spreadsheet Fetcher for Google” has been translated into 3 locales. Thank you to [the translators](https://translate.wordpress.org/projects/wp-plugins/wp-simple-spreadsheet-fetcher-for-google/contributors) for their contributions. [Translate “WP Simple Spreadsheet Fetcher for Google” into your language.](https://translate.wordpress.org/projects/wp-plugins/wp-simple-spreadsheet-fetcher-for-google) ### Interested in development? [Browse the code](https://plugins.trac.wordpress.org/browser/wp-simple-spreadsheet-fetcher-for-google/), check out the [SVN repository](https://plugins.svn.wordpress.org/wp-simple-spreadsheet-fetcher-for-google/), or subscribe to the [development log](https://plugins.trac.wordpress.org/log/wp-simple-spreadsheet-fetcher-for-google/) by [RSS](https://plugins.trac.wordpress.org/log/wp-simple-spreadsheet-fetcher-for-google/?limit=100&mode=stop_on_copy&format=rss). ## Changelog #### 0.7.9 * Tested up to WordPress 5.6. #### 0.7.8 * [Feature][Table] remove auto convert url to link feature. #### 0.7.7 * [Feature][Table] enable to fetch HTML from Google Sheets. #### 0.7.6 * Fix bug, and add validation message. #### 0.7.5 * Fix bug. #### 0.7.3 * Add notification for turning on sharing setting. #### 0.7.2 * Translate button text in api key setting page. #### 0.7.1 * Introduce Chart block. * Change minimum required version 5.0 to 5.3. = 0.6.8= – Add css backward compatibility. #### 0.6.4 * Fix sidebar css for WordPress5.4 * Simplify sidebar UI. * Fix RangeControl bug in WordPress5.4. #### 0.6.1 * Fix css. #### 0.6.0 * Add sidebar settings to customize table style * Deprecated css style. #### 0.5.2 * Fix version. #### 0.5.1 * Fix to load translation file for text in javascript. #### 0.4.9 * Fix version. #### 0.4.8 * Fix version. #### 0.4.7 * Fix version. #### 0.4.6 * Fix version. #### 0.4.2 * Fix version. * Fix develop tool. #### 0.4.1 * Fix version. #### 0.4.0 * Fix version. #### 0.3.9 * Fix version. #### 0.3.7 * Fix text message in fecher advanced block * Fix css. * Fix CSRF. #### 0.3.6 * Add japanese translation for text in javascript. #### 0.3.4 * Fix text and i18n. #### 0.3.3 * Fix text and i18n. #### 0.3.2 * Fix user interface. #### 0.3.1 * Fix user interface. #### 0.3.0 * Fix user interface * Enable to set sheet id from each fetcher block. #### 0.2.7 * Bug fix. #### 0.2.6 * Bug fix. #### 0.2.5 * Delete parser block, add fetcher and fetcher advanced blocks. * Fix some. #### 0.2.4 Just fix text. #### 0.2.3 Fix the description, and add event register layout. #### 0.2.0 Fix to register wordpress.org. #### 0.1.0 First commit. ## Meta * Version **0.7.9** * Last updated **6 years ago** * Active installations **100+** * WordPress version ** 5.3 or higher ** * Tested up to **5.6.19** * Languages * [English (US)](https://wordpress.org/plugins/wp-simple-spreadsheet-fetcher-for-google/), [Japanese](https://ja.wordpress.org/plugins/wp-simple-spreadsheet-fetcher-for-google/), [Spanish (Chile)](https://cl.wordpress.org/plugins/wp-simple-spreadsheet-fetcher-for-google/), and [Spanish (Spain)](https://es.wordpress.org/plugins/wp-simple-spreadsheet-fetcher-for-google/). * [Translate into your language](https://translate.wordpress.org/projects/wp-plugins/wp-simple-spreadsheet-fetcher-for-google) * Tags * [api](https://test.wordpress.org/plugins/tags/api/)[fetcher](https://test.wordpress.org/plugins/tags/fetcher/) [Google Sheets](https://test.wordpress.org/plugins/tags/google-sheets/) * [Advanced View](https://test.wordpress.org/plugins/wp-simple-spreadsheet-fetcher-for-google/advanced/) ## Ratings 4.1 out of 5 stars. * [ 5 5-star reviews ](https://wordpress.org/support/plugin/wp-simple-spreadsheet-fetcher-for-google/reviews/?filter=5) * [ 0 4-star reviews ](https://wordpress.org/support/plugin/wp-simple-spreadsheet-fetcher-for-google/reviews/?filter=4) * [ 1 3-star review ](https://wordpress.org/support/plugin/wp-simple-spreadsheet-fetcher-for-google/reviews/?filter=3) * [ 0 2-star reviews ](https://wordpress.org/support/plugin/wp-simple-spreadsheet-fetcher-for-google/reviews/?filter=2) * [ 1 1-star review ](https://wordpress.org/support/plugin/wp-simple-spreadsheet-fetcher-for-google/reviews/?filter=1) [Your review](https://wordpress.org/support/plugin/wp-simple-spreadsheet-fetcher-for-google/reviews/#new-post) [See all reviews](https://wordpress.org/support/plugin/wp-simple-spreadsheet-fetcher-for-google/reviews/) ## Contributors * [ Naoki Ohashi ](https://profiles.wordpress.org/naoki0h/) ## Support Got something to say? Need help? [View support forum](https://wordpress.org/support/plugin/wp-simple-spreadsheet-fetcher-for-google/)