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

1. Install and Activate the Plugin: Install SheetPoet on your WordPress site.
2. Configure API: Generate your secure API key under ‘SheetPoet > Settings’.
3. Install the Sheets Add-on: Install the SheetPoet Add-on in your Google Sheet.
4. 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.
5. 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.