Google Sheets to WordPress Plugin – LIFETIME LICENSE

Automatically sync content from Google Sheets to WordPress posts with powerful field mapping and real-time synchronization.

Google Sheets to WordPress is a powerful automation plugin that bridges the gap between Google Sheets and WordPress content management. Create, update, and manage WordPress posts directly from Google Sheets with flexible field mapping, automatic synchronization, and comprehensive admin controls.

Perfect for content teams, bloggers, and businesses who want to streamline their content workflow by leveraging the collaborative power of Google Sheets while maintaining the publishing capabilities of WordPress.

• Automatic Synchronization: Real-time sync from Google Sheets to WordPress posts
• Flexible Field Mapping: Map any Google Sheets column to WordPress post fields (title, content, excerpt, etc.)
• Public & Private Sheet Support: Works with both public Google Sheets (API key) and private sheets (OAuth authentication)
• Multiple Configuration Support: Manage multiple Google Sheets with different settings
• Post Type Support: Create posts, pages, or custom post types
• Category Management: Automatically assign categories based on sheet data
• Featured Image Handling: Set featured images from URLs in your sheets
• Custom Fields Support: Map sheet columns to custom post meta fields
• Draft/Published Control: Set post status (draft, published, private, etc.)
• Duplicate Prevention: Intelligent duplicate detection and update handling
• Comprehensive Logging: Detailed sync history and error logging
• Admin Dashboard: Complete WordPress admin interface with sync controls
• Security Features: Nonce verification, capability checks, and input sanitization

1. Connect Your Google Sheet: Add your Google Sheets ID and configure API access
2. Map Your Fields: Define which columns map to WordPress post fields
3. Configure Settings: Set post type, status, author, and other options
4. Sync Content: Manual sync or automatic synchronization
5. Manage Posts: View sync history and manage created content

• PHP 7.4 or higher
• WordPress 5.0 or higher
• cURL extension enabled
• Google Sheets API access (API key or OAuth)

1. Create a Google Cloud Project:

   • Go to Google Cloud Console
   • Create a new project or select existing one
   • Enable the Google Sheets API

2. Get an API Key:

   • Go to APIs & Services → Credentials
   • Click “Create Credentials” → “API Key”
   • Copy the API key for use in the plugin

3. Make Your Sheet Public:

   • Open your Google Sheet
   • Click “Share” → “Change to anyone with the link”
   • Set permission to “Viewer”

1. Create OAuth 2.0 Credentials:

   • In Google Cloud Console → Credentials
   • Create OAuth 2.0 Client ID
   • Add your WordPress site URL as authorized redirect URI
   • Download the credentials JSON file

2. Configure OAuth in Plugin:

   • Upload credentials in plugin settings
   • Complete the authentication flow
   • Grant necessary permissions

1. Download the plugin files
2. Upload to /wp-content/plugins/google-sheets-to-wordpress/
3. Activate the plugin through the Plugins menu
4. Navigate to Sheets to WP in your WordPress admin

1. Add Configuration:

   • Go to Sheets to WP → Configurations
   • Click “Add New Configuration”
   • Enter your Google Sheets ID and range

2. Set Up Authentication:

   • For public sheets: Add your Google Sheets API key
   • For private sheets: Configure OAuth authentication

3. Map Fields:

   • Define which columns map to post title, content, etc.
   • Configure post settings (type, status, author)

4. Test Sync:

   • Click “Sync” to test the connection
   • Verify posts are created correctly

For optimal results, structure your Google Sheet as follows:

1. Use Clear Headers: While not required, clear column headers help with organization
2. Consistent Data Format: Maintain consistent formatting across all rows
3. URL Format for Images: Use complete URLs for featured images
4. Category Names: Use exact category names as they appear in WordPress
5. Tag Separation: Separate multiple tags with commas
6. Empty Rows: Empty rows will be automatically skipped

• Text: Post titles, content, excerpts
• HTML: Rich content with HTML formatting
• URLs: Featured images, custom field URLs
• Comma-separated Values: Categories, tags
• Numbers: Custom field numeric values
• Dates: Custom field date values (YYYY-MM-DD format)

• Post Title (post_title)
• Post Content (post_content)
• Post Excerpt (post_excerpt)
• Featured Image URL (featured_image)
• Categories (categories)
• Tags (tags)
• Custom Fields (any meta key)

• Content Teams: Collaborative content creation and publishing workflow
• Bloggers: Bulk content import and management
• News Sites: Rapid content publishing from editorial sheets
• E-commerce: Product data synchronization
• Event Management: Event listings from planning spreadsheets
• Directory Sites: Location or business data import

The Google Sheets ID is found in the URL of your sheet:https://docs.google.com/spreadsheets/d/SHEET_ID_HERE/edit

Yes! You can create multiple configurations, each pointing to different Google Sheets with their own field mappings and settings.

The plugin includes duplicate detection. You can configure whether to update existing posts or skip them.

Empty rows (where both title and content columns are empty) are automatically skipped during synchronization.

Currently, the plugin supports manual synchronization. Automatic scheduling features are planned for future releases.

Yes! The plugin uses WordPress security best practices including nonce verification, capability checks, and secure API communication.

The plugin includes rate limiting and will pause synchronization if API limits are reached. You can adjust sync frequency in settings.

• Process multiple rows efficiently with built-in rate limiting
• Automatic retry mechanism for failed synchronizations
• Progress tracking for large datasets

• Automatic data type validation and sanitization
• Required field checking before post creation
• Error reporting with detailed feedback

• Intelligent caching system to reduce API calls
• Optimized database queries for large datasets
• Memory-efficient processing for bulk operations

• Action and filter hooks for customization
• Extensible architecture for custom field types
• REST API endpoints for external integrations

“Failed to read Google Sheets data”

• Verify your Google Sheets ID is correct
• Check that your API key has proper permissions
• Ensure the sheet is publicly accessible (for public sheets)

“Google authentication required”

• Complete the OAuth setup process in Settings
• Verify your OAuth credentials are properly configured
• Check that redirect URIs match your WordPress site URL

“No data found in the specified sheet range”

• Verify your sheet range (e.g., “A:Z” or “Sheet1!A1:C100”)
• Check that your sheet contains data in the specified columns
• Ensure column headers are in the first row

Posts not being created

• Check field mappings are correctly configured
• Verify post type and status settings
• Review sync logs for detailed error messages

Enable debug logging in WordPress to get detailed information:

define('WP_DEBUG', true);
define('WP_DEBUG_LOG', true);

Check /wp-content/debug.log for detailed error messages.