這個外掛並未在最新的 3 個 WordPress 主要版本上進行測試。開發者可能不再對這個外掛進行維護或提供技術支援,並可能會與更新版本的 WordPress 產生使用上的相容性問題。

WP Simple Spreadsheet Fetcher for Google

外掛說明

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.
  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
  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.

螢幕擷圖

  • Fetch and display data from Google Sheets.

適用於區塊編輯器

這個外掛提供 4 個可供 Gutenberg/區塊編輯器使用的區塊。

  • Table
  • Advanced (Deprecated in next update)
  • Fetcher Item
  • Chart

安裝方式

  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.

使用者評論

2020 年 9 月 18 日 1 則留言
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.
2020 年 6 月 11 日 1 則留言
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
閱讀全部 7 則使用者評論

參與者及開發者

以下人員參與了開源軟體〈WP Simple Spreadsheet Fetcher for Google〉的開發相關工作。

參與者

〈WP Simple Spreadsheet Fetcher for Google〉外掛目前已有 1 個本地化語言版本。 感謝全部譯者為這個外掛做出的貢獻。

將〈WP Simple Spreadsheet Fetcher for Google〉外掛本地化為台灣繁體中文版

對開發相關資訊感興趣?

任何人均可瀏覽程式碼、查看 SVN 存放庫,或透過 RSS 訂閱開發記錄

變更記錄

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.