[WordPress] 外掛分享： Simple Event Listing feed from Google Sheets

WordPress 外掛 Simple Event Listing feed from Google Sheets 的封面圖片。

前言介紹

  • 這款 WordPress 外掛「Simple Event Listing feed from Google Sheets」是 2024-07-25 上架。
  • 目前尚無安裝啟用數，是個很新的外掛。如有要安裝使用，建議多測試確保功能沒問題！
  • 上一次更新是 2024-07-31，距離現在已有 276 天。
  • 外掛要求網站主機運作至少需要 PHP 版本 8.0 以上。
  • 尚未有人給過這款外掛評分。
  • 還沒有人在論壇上發問，可能目前使用數不多，還沒有什麼大問題。

外掛協作開發者

pjaudiomv |

外掛標籤

events | event listing | Google Sheets |

內容簡介

總結：Simple Event Listing feed from Google Sheets是一款外掛程式，旨在從Google試算表中提取活動數據並在您的網站上顯示。

問題與答案：
1. 這個外掛程式的主要功能是什麼？
- 答：從Google試算表中提取活動數據並在網站上顯示。

2. 使用時的基本用法是什麼？
- 答：使用基本範例：[simple_event_sheets]，確保您的Google表具有行標題：日期、名稱、URL、活動信息、卡車信息。日期應該以mm/dd/yyyy格式化。實施日期和URL行的數據驗證以防止錯誤。此外，這個外掛程式也提供內建的數據驗證。

3. 使用該外掛程式時需注意什麼？
- 答：有關Google API金鑰：您需要一個具有試算表訪問權限的API金鑰。該試算表應設置為“任何人都可以查看鏈接”或您應添加服務用戶。如果您正在使用服務器端事件加載，請通過服務器IP限制金鑰。對於客戶端加載，請通過域名限制金鑰。

4. 這個外掛程式依靠哪個第三方服務來正常運作？
- 答：Google Sheets。

5. 這個外掛程式從Google Sheets中提取數據的情況是什麼？
- 答：當檢索事件數據以在應用程序中顯示時。

原文外掛簡介

Simple Event Listing feed from Google Sheets is a plugin designed to fetch event data from a Google Spreadsheet and display it on your website.
SHORTCODE
– Basic Usage: [simple_event_sheets]
* Ensure your Google Sheet has the row headers: date, name, url, event_info, day_info. The date should be formatted as mm/dd/yyyy. Implement data validation on the date and url rows to prevent errors. Note: This plugin also offers built-in data validation.
* event_info: Additional information about the event, displayed next to the event name.
* day_info: Additional information about the day of the event, displayed next to the date.
* Regarding the Google API Key: You’ll need an API key with Spreadsheet access. The sheet should either be set to “anyone with the link can view” or you should add a service user. If you’re utilizing server-side event loading, restrict the key by server IP. For client-side loading, restrict the key by domain.
You can use this Google Sheet as a template if wanted, it includes data and url validation to help ensure good data quality. https://docs.google.com/spreadsheets/d/18NnmKKU7P6bFOPEHgyUMWeKQWQJnAfYb5gmn0-fne1E/
Third-Party Service Disclosure
This plugin relies on a third-party service, Google Sheets, to function properly. The plugin fetches data from Google Sheets under the following circumstances:

When retrieving event data to display within the application.

Service Information

Service: Google Sheets API
Terms of Use: Google API Terms of Use
Privacy Policy: Google Privacy Policy

Creating a Google API Key with Sheets API Access

Go to the Google Cloud Console:

Open the Google Cloud Console at console.cloud.google.com.

Create a New Project:

Click on the project dropdown and select “New Project”.
Enter a project name and click “Create”.

Enable the Sheets API:

With your project selected, go to the API Library.
Search for “Google Sheets API” and click on it.
Click “Enable” to enable the API for your project.

Create API Credentials:

Go to the Credentials page.
Click “Create Credentials” and select “API key”.
Your API key will be created. Copy it and keep it safe.

Restrict Your API Key:

Click on the edit icon next to your API key.
Under “Key restrictions”, select either “HTTP referrers (web sites)” or IP (server).
Add the referrer(s) for your site, such as https://yourdomain.com/* or Server IP.
Save your changes.

Set Spreadsheet Access:

Ensure your Google Sheet is either set to “anyone with the link can view” or you should add a service user with the necessary permissions. This step is crucial for the API key to access the data.

MORE INFORMATION
https://github.com/pjaudiomv/simple-event-sheets

各版本下載點

  • 方法一：點下方版本號的連結下載 ZIP 檔案後，登入網站後台左側選單「外掛」的「安裝外掛」，然後選擇上方的「上傳外掛」，把下載回去的 ZIP 外掛打包檔案上傳上去安裝與啟用。
  • 方法二：透過「安裝外掛」的畫面右方搜尋功能，搜尋外掛名稱「Simple Event Listing feed from Google Sheets」來進行安裝。

（建議使用方法二，確保安裝的版本符合當前運作的 WordPress 環境。

1.0.0 | 1.0.1 | trunk |

延伸相關外掛（你可能也想知道）

文章
Filter
Apply Filters
Close
Mastodon