Available in: Pro
Real-time sync sends a row to your sheet the moment a record changes in WordPress, without waiting for a schedule.
How it works
PushRow listens to the WordPress and plugin events for the job’s data type. When one fires, the item is queued, and at the end of the request each queued item is synced once. Several changes to the same item in one request cause a single update.
Triggers
Each data type offers its own triggers. The most common are:
- Created: a new post, order, user or entry.
- Updated: an existing item changes.
- Deleted: an item is trashed or deleted.
- Status changed: for example, an order moves from processing to completed.
Some data types have their own, such as a license activation, an order refund, a course completion or a rescheduled booking. Each data type guide lists them.
Turn it on
- Create or edit an export job.
- In Schedule and review, tick Sync this job in real time.
- Choose the events that should send a row.
- Save the job.
The Automation page lists your export jobs with their real-time switches and events in one place.
Form entries
- Contact Form 7, Gravity Forms and WPForms have their own Google Sheets settings in the form editor, which send each submission as it arrives.
- For Ninja Forms, Fluent Forms and Formidable Forms, turn on real-time sync for the job.
Data types without real-time sync
Custom database tables have no WordPress events, so use a schedule for them.
Tips
- Combine real-time sync with a schedule as a safety net.
- Check the Logs page to confirm that events are being sent.