Pushrow uses a step-by-step wizard to help you create sync jobs. A sync job defines what data to sync, where to sync it, and how often.
Step 1: Name and Direction
Navigate to Pushrow → Sync Jobs and click Create New Job. You will be asked to:
- Job Name: Give your job a descriptive name (e.g., “Export WooCommerce Orders”).
- Direction: Choose Export (WordPress → Google Sheets) or Import (Google Sheets → WordPress).
Step 2: Select Data Type
Choose the data provider you want to sync. Available providers depend on your installed plugins:
- WordPress Core: Posts & Pages, Custom Post Types + ACF, Users
- WooCommerce: Orders, Products, Customers
- Forms: Contact Form 7, Gravity Forms, WPForms, Elementor Forms, Ninja Forms, Fluent Forms, Formidable Forms
- EDD: Orders, Customers, Licenses
- LMS & Booking: LearnDash Enrollments, LearnDash Quiz Results, Amelia Bookings
After selecting a provider, configure any available filters (e.g., specific post type, form, date range, or order status).
Step 3: Choose Spreadsheet and Tab
Select an existing Google Spreadsheet from the dropdown, or create a new one. You can also:
- Paste a spreadsheet URL or ID directly.
- Create a new tab within an existing spreadsheet.
- Use the refresh button to reload your spreadsheet list.
Step 4: Map Fields
Select which fields to include in the sync. Fields are grouped by category for easy browsing. You can also:
- Set a Unique Key field for deduplication (e.g., Post ID, Order ID, Email).
- Choose the Sync Behavior: Create Only, Update Only, or Create & Update.
Step 5: Schedule and Review
Configure how often the job should run automatically:
- Manual Only: Run on demand.
- Scheduled: Every 5 minutes, 15 minutes, 30 minutes, hourly, every 6 hours, every 12 hours, daily, or weekly.
Additional options include:
- Clear sheet before sync: Wipe existing data before each export.
- Chunk size: Number of rows per batch (default 100).
- Real-time sync: Enable live push on data create, update, or delete events.
Review all settings and click Save & Run to execute immediately, or Save as Draft to save without running.