Follow for free plugins, new theme releases and theme news
Plugin Description
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 extension for Google Sheets
- Create and 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: Use the admin interface to define your processing logic in PHP.
- 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.
Screenshots
Settings page with API configuration
Function management interface
Function editor with validation and syntax highlighting
Execution logs and debug panel
Log details view