Available in: Free and Pro
A sync job says what to sync, where it goes and how. Go to Sync Jobs in the PushRow menu and start a new job. The wizard has five steps.
Step 1: Name and direction
- Job name: a descriptive name, for example “Export blog posts”. It appears in the jobs list and in the logs.
- Direction: WordPress → Sheet exports WordPress data to a spreadsheet. Sheet → WordPress imports rows into WordPress and needs Pro. See sync directions and behaviors.
Step 2: Choose the data
Pick a data type. The free plugin offers Posts & Pages and Users. Pro adds the other data types, and each one appears only when its plugin is active (for example, the WooCommerce data types need WooCommerce).
Most data types have optional filters, such as post type, status, role, form or a date range.
Step 3: Pick the sheet
Choose one of your Google spreadsheets or create a new one, then pick a tab or create a new tab.
Step 4: Map the columns
For an export, choose the fields to write as columns. If the tab already has headers, PushRow matches them to fields for you.
You can also set:
- A unique key, such as Post ID or email, so that re-running the job updates existing rows instead of adding duplicates.
- The sync behavior: create only, update only, or create and update.
Step 5: Review
Check the summary, then click Save as draft or Save and run now. You can also:
- Tick the option to clear the tab before each sync, so every export replaces the tab’s rows.
- In Pro, change Rows per batch (100 by default). Lower it if large syncs time out on your host.
- In Pro, choose a schedule and turn on real-time sync.
Before a big first run, use Test run in the jobs list. It syncs 10 rows so you can check the columns.