SyncSheets includes a smart field mapping system that automatically matches WordPress data fields to Google Sheets columns. This saves you time during job setup and ensures accurate data alignment.
How Auto-Mapping Works
When you select a spreadsheet tab that already has headers, SyncSheets uses an intelligent matching algorithm to map sheet columns to WordPress fields:
- Exact Match: Column header exactly matches a field name or key.
- Substring Match: Column header contains or is contained within a field name.
- Similarity Match: Uses text similarity scoring to find the closest match.
- Alias Matching: Recognizes common aliases (e.g., “e-mail” maps to “email”).
Only matches with a confidence score of 70% or higher are applied. You can always review and adjust auto-detected mappings manually.
Manual Field Selection
When creating a new export job, you can manually select which fields to include. Fields are organized by category for easy browsing:
- Core Fields: ID, title, status, date, etc.
- Content Fields: Content, excerpt, description.
- Meta Fields: Custom fields, ACF fields.
- Taxonomy Fields: Categories, tags, custom taxonomies.
- Relationship Fields: Author, customer, assigned user.
Data Type Handling
SyncSheets automatically converts field values to the correct format for Google Sheets:
- Text: Sanitized string values.
- Numbers: Numeric values formatted as numbers in Sheets.
- Dates: Converted to Google Sheets-compatible date format.
- Emails: Validated and sanitized email addresses.
- URLs: Properly escaped URLs.
- Booleans: Converted from various truthy values (1, true, yes, on) to True/False.
Validation
The field mapper includes a validation endpoint that checks for potential issues like:
- Duplicate field mappings (same field mapped to multiple columns).
- Missing required fields.
- Type mismatches between source and destination.