WP Manifestindependent plugin directory
manifest / integrations / sheet-to-wp-migration

Google Sheet to WP Post migration

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.

by Shimanta Das · github.com/iamshimantadas/sheet-to-wp-migration

★ 0stars

Install

Download source zip No release zip yet

This is the repository archive. It installs, but the folder name will carry the branch suffix and updates will not flow.

Install straight from GitHub with WP-CLI:

wp plugin install https://github.com/iamshimantadas/sheet-to-wp-migration/archive/refs/heads/main.zip
No built-in updater. New versions won't appear under Dashboard → Updates. Install new releases yourself, or let Git Updater track the repository.
Readme github.com/iamshimantadas/sheet-to-wp-migration ↗

Google Sheets to WordPress Sync Plugin

Overview

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.

Features

  • 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.

Installation

  1. Upload the plugin to wp-content/plugins/ and activate it.
  2. Configure Google Sheets API access and enter the sheet URL.
  3. Map sheet columns to WordPress post fields.
  4. Set up Cron Events for automated syncing.

Usage

  • 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.

Google Sheets Range Reference

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.

License

This plugin is open-source and available under the GPL v2 or later license.

🚀 Effortlessly sync content from Google Sheets to WordPress!