This WordPress plugin automates post synchronization from Google Sheets to a WordPress site. It uses WordPress Cron Events to ensure continuous syncing, making content migration seamless and efficient.
- Google Sheets Integration: Fetch posts directly from Google Sheets.
- Automated Syncing: Uses WordPress Cron Events for continuous synchronization.
- Custom Mapping: Define columns for post title, content, categories, and more.
- Effortless Migration: Ideal for bulk importing and updating content.
- ACF & Post Meta Support: When saving ACF fields or post meta fields against a post type, settings must be re-saved after any changes.
- Upload the plugin to
wp-content/plugins/and activate it. - Configure Google Sheets API access and enter the sheet URL.
- Map sheet columns to WordPress post fields.
- Set up Cron Events for automated syncing.
- Add new posts to Google Sheets, and they will be automatically created in WordPress.
- Edit existing posts in the sheet, and changes will reflect on the site.
- Supports scheduled syncing for real-time updates.
- Important: After modifying ACF fields or post meta fields, re-save the plugin settings to apply changes.
In Google Sheets, A2:H refers to a dynamic range:
- A2 specifies the starting cell in column A, row 2.
- H represents all rows from column A to column H.
- This selection includes all data from A2 through H, extending down to the last row of content.
For a fixed range, such as A2:H10, only rows 2 to 10 from columns A to H will be included.
This plugin is open-source and available under the GPL v2 or later license.
🚀 Effortlessly sync content from Google Sheets to WordPress!