SyncSheets supports syncing data in two directions and offers multiple behaviors to control how data is handled during sync.
Sync Directions
Export (WordPress → Google Sheets)
Export takes data from your WordPress site and sends it to a Google Spreadsheet. This is ideal for:
- Creating backups of your data in Google Sheets.
- Sharing data with team members who prefer spreadsheets.
- Generating reports from WooCommerce orders, form submissions, or user data.
- Building dashboards or visualizations in Google Sheets.
Import (Google Sheets → WordPress)
Import reads data from a Google Spreadsheet and creates or updates content in WordPress. This is useful for:
- Bulk creating or updating posts, pages, or products.
- Updating WooCommerce order statuses from a shared spreadsheet.
- Migrating data from external systems via Google Sheets as an intermediary.
Sync Behaviors
When configuring a sync job, you can choose one of three behaviors:
Create Only
Only new items are synced. Existing items are skipped. This is useful when you want to append new data without modifying what is already there.
Update Only
Only existing items are updated. New items are ignored. Use this when you want to modify existing records without creating duplicates.
Create and Update
Both new items are created and existing items are updated. This provides the most complete sync and is the default behavior.
Unique Key for Deduplication
To determine whether an item already exists, SyncSheets uses a Unique Key field. Common examples include:
- Post ID for posts and pages.
- Order ID for WooCommerce orders.
- Product SKU for WooCommerce products.
- Email for users and customers.
Always set a unique key when using Update Only or Create and Update behaviors to ensure accurate matching.