內容簡介
總結：SheetPoet 是一個功能強大的 WordPress 外掛，與其配套的 Google Sheets 外掛相互配合。透過它，您可以在 WordPress 管理員中建立和管理安全的 PHP 函數，並直接從您的試算表中觸發它們。您可以從 WordPress 將數據匯入 Sheets 中，將試算表數據發送到您的網站，或運行一次性自定邏輯。
1. SheetPoet 與 Google Sheets 官方擴展配合使用。
2. 通過管理界面創建和管理自定義 PHP 函數。
3. 3種函數類型：
- 導入至表格：從 WordPress 中提取數據並填充您的試算表。
- 上傳到網站：將試算表行發送到 WordPress 進行處理。
- 一次性觸發：執行同步或清理等邏輯。
**問題與答案：**
1. SheetPoet 可以與哪個 Google Sheets 擴展一起使用？
- SheetPoet 可以與 Google Sheets 的官方擴展配合使用。
2. 使用 SheetPoet 可以執行哪三種函數類型？
- 輸入至表格、上傳到網站、一次性觸發。
3. 如何配置 API 來保護訪問？
- 在'SheetPoet > Settings' 下生成您的安全 API 密鑰。
4. SheetPoet 在 Google Sheets 中如何觸發自定義功能？
- 使用 Add-on 介面觸發您的自定義功能並與 WordPress 進行數據交換。
5. 如果發現 SheetPoet 有幫助，應該如何支持這個項目？
- 請留下 5 星評價，您的支持有助於我們的改進。
外掛標籤
開發者團隊
② 後台搜尋「SheetPoet – Spreadsheet Connector」→ 直接安裝（推薦）
原文外掛簡介
SheetPoet is a powerful WordPress plugin that works hand-in-hand with its companion Google Sheets Add-on. It enables you to create and manage secure PHP functions via the WordPress admin and trigger them directly from your spreadsheet. You can import data from WordPress into Sheets, send spreadsheet data to your site, or run one-time custom logic.
Features
Works with the official SheetPoet Google Sheets addon
Register PHP functions with simple filters and actions
Manage custom PHP functions via admin UI
3 function types:
Import to Sheet: Fetch data from WordPress and populate your spreadsheet
Upload to Website: Send spreadsheet rows to WordPress for processing
One-time Trigger: Perform logic like syncing or cleanup
API key authentication for secure access
React-based interface for a smooth UX
Function execution logs and error tracking
How It Works
Install and Activate the Plugin: Install SheetPoet on your WordPress site.
Configure API: Generate your secure API key under ‘SheetPoet > Settings’.
Install the Sheets Add-on: Install the SheetPoet Add-on in your Google Sheet.
Create Functions: Create PHP functions in your theme or plugin using filter and define your processing logic in PHP functions. Use the admin interface to register your PHP functions.
Trigger from Sheets: Use the Add-on interface to trigger your custom functions and exchange data with WordPress.
Contribute
Active development of this plugin is handled on GitHub.
Contributions are welcome via pull requests.
Use Cases
Import custom post data into Google Sheets
Upload leads or form entries from Sheets to WordPress
Automate recurring tasks or one-time actions like data cleanup
Sync product, order, user data, or any other data between Sheets and WordPress
Use Google Sheets as a control panel for your site
Rate & Support Us
If you find SheetPoet helpful, please leave a 5-star review. Your support helps us improve!
Compatibility
Compatible with WordPress 6.0+
Tested with PHP 7.4+
Works with all major themes and plugins
Support
For questions or issues, visit the support forums.
