Opis
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.
Zrzuty ekranu
Settings page with API configuration 
Function management interface 
Function editor for registering a function 
Execution logs and debug panel 
Log details view
Instalacja
- Upload the
sheetpoetfolder to the/wp-content/plugins/directory. - Activate the plugin from your WordPress dashboard.
- Visit ‘SheetPoet > Settings’ to configure your API key.
- Visit ‘SheetPoet > Functions’ to register your custom functions.
- Install the SheetPoet Add-on in your Google Sheet.
- Start syncing data between Sheets and WordPress!
Najczęściej zadawane pytania
-
How do I authenticate requests?
-
Every request from the Sheets Add-on must include a valid API key, generated in the plugin settings.
-
What types of functions can I create?
-
You can create three types:
– Import to Sheet
– Upload to Website
– One-time Triggers -
Can I return custom results from my functions?
-
Yes, your PHP functions can return data back to Sheets as arrays or string, which is handled by the Add-on.
-
Is it safe to run PHP from Sheets?
-
Yes. Each function is validated, and only accessible via authenticated API calls.
Recenzje
Wtyczka nie ma jeszcze żadnej recenzji.
Kontrybutorzy i deweloperzy
„SheetPoet – Spreadsheet Connector” jest oprogramowaniem open source. Poniższe osoby miały wkład w rozwój wtyczki.
Zaangażowani
Przetłumacz wtyczkę “SheetPoet – Spreadsheet Connector” na swój język.
Interesuje cię rozwój wtyczki?
Przeglądaj kod, sprawdź repozytorium SVN lub czytaj dziennik rozwoju przez RSS.
Rejestr zmian
1.0.4
Release Date: Sep 15, 2025
- Updated plugin info and docs
1.0.3
Release Date: Sep 15, 2025
- Minor bugfixes and updates
1.0.0
Release Date: May 10, 2025
- Initial release.