Real-time sync pushes data changes from WordPress to Google Sheets instantly as they happen. No waiting for scheduled intervals — your spreadsheet is updated the moment data changes on your site.
How Real-time Sync Works
SyncSheets hooks into WordPress actions to detect data changes. When a change occurs (e.g., a new order, a post update, or a form submission), the plugin immediately syncs the affected data to your Google Sheet.
To prevent performance issues, SyncSheets uses a debounce mechanism — multiple changes within the same request are batched and processed once at the end of the request.
Supported Triggers
- Create: A new item is created (new post, new order, new user, etc.).
- Update: An existing item is modified.
- Delete: An item is trashed or permanently deleted.
- Status Change: An item’s status changes (e.g., order status transitions).
Enabling Real-time Sync
- Create or edit an export sync job.
- In Step 5, enable the Real-time Sync toggle.
- Select which triggers to activate (create, update, delete).
- Save the job.
You can also manage real-time sync from the Automation page for a centralized view of all active real-time jobs.
Supported Providers
Real-time sync is available for all export providers except form plugins (which use submission-based triggers instead). Supported providers include:
- Posts & Pages
- Custom Post Types + ACF
- Users
- WooCommerce Orders, Products, and Customers
- Easy Digital Downloads Orders, Customers, and Licenses
- LearnDash Enrollments and Quiz Results
- Amelia Bookings
Form providers (CF7, Gravity Forms, WPForms, etc.) use their own real-time mechanism that triggers on form submission events.
Tips
- Real-time sync is best for critical data that needs immediate visibility in Google Sheets.
- Combine with scheduled sync as a backup to ensure no data is missed.
- Monitor your sync logs to verify real-time events are being captured correctly.