PBJ Sheets Sync 1.0.0: Google Sheets and Your WordPress Database, Finally in Sync
PBJ Sheets Sync 1.0.0 is out. Your WordPress database and a Google Sheet, finally speaking the same language: two-way sync, living backups of any WordPress table, and CSV in and out — with a five-minute Apps Script bridge in your own Google account instead of a Google Cloud project or a monthly sync service.
Two-way synced tables
The plugin creates and manages its own database tables. Edit a row in the Sheet or in WordPress — at the next sync the most recent change wins, per row. New rows added at the bottom of the sheet are inserted and get their id written back automatically. Deletions are safe by default: a deleted row is restored from the surviving side unless you opt into deletion propagation per table.
Living backups of any WordPress table
Point it at posts, users, WooCommerce orders, or any other plugin’s table and every sync rewrites a sheet tab with a fresh copy — a browsable backup your whole team can read. One-way only; sheet edits never touch the database.
CSV in and out
Export any synced table as CSV. Download a header template that matches an existing table so re-imports line up perfectly (rows with an _id update in place, rows without insert). Or import any CSV with “create new” and its header row becomes a fully synced two-way table.
The bridge
Google Sheets can’t be written from PHP without a Google Cloud account, so PBJ Sheets Sync ships with a small Apps Script bridge that lives in your own Google account. One script, pasted once, deployed once — the numbered walkthrough is on the plugin’s User Guide tab and in the download.
Getting it
$15 one-time, license key by email, automatic updates for 3 sites. Grab it on the WordPress Plugins page.
PBJ Sheets Sync 1.0.0 is out. Your WordPress database and a Google Sheet, finally speaking the same language: two-way sync, living backups of any WordPress table, and CSV in and out — with a five-minute Apps Script bridge in your own Google account instead of a Google Cloud project or a monthly sync service.
Two-way synced tables
The plugin creates and manages its own database tables. Edit a row in the Sheet or in WordPress — at the next sync the most recent change wins, per row. New rows added at the bottom of the sheet are inserted and get their id written back automatically. Deletions are safe by default: a deleted row is restored from the surviving side unless you opt into deletion propagation per table.
Living backups of any WordPress table
Point it at posts, users, WooCommerce orders, or any other plugin’s table and every sync rewrites a sheet tab with a fresh copy — a browsable backup your whole team can read. One-way only; sheet edits never touch the database.
CSV in and out
Export any synced table as CSV. Download a header template that matches an existing table so re-imports line up perfectly (rows with an _id update in place, rows without insert). Or import any CSV with “create new” and its header row becomes a fully synced two-way table.
The bridge
Google Sheets can’t be written from PHP without a Google Cloud account, so PBJ Sheets Sync ships with a small Apps Script bridge that lives in your own Google account. One script, pasted once, deployed once — the numbered walkthrough is on the plugin’s User Guide tab and in the download.
Getting it
$15 one-time, license key by email, automatic updates for 3 sites. Grab it on the WordPress Plugins page.