PageForge 1.3: check every run before it writes, update generated pages, spintax and resumable batches. See what changed
Account Get it free

Link a template to a Google Sheet. New rows create pages, changed rows update them, and removed rows go to draft or trash only after you review a preview.

Pro Updated November 18, 20263 min read

Pro Google Sheets is included in the PageForge Pro Professional and Enterprise plans. It is not part of Starter.

A Google Sheets sync keeps a set of generated pages in step with a sheet your team edits. New rows create pages, changed rows update their pages, and rows you delete can send their pages to draft or the trash. Every sync starts with a preview, and nothing is removed until you have seen what would happen.

Google Sheets sync updates pages for changed rows and moves pages for removed rows to draft.

Before you start

  • The sheet’s first row holds column names, exactly like a CSV.
  • To read a specific tab, copy the sheet URL from your browser while that tab is open. The URL includes the tab’s ID, and PageForge reads that tab.
  • If the sheet is not public, add a Google Sheets API Key under PageForge > Settings, as the Data Sources screen notes.
  • Synced rows are processed by the queue, so turn on Enable Daily Scheduler in Settings. The Daily Limit you set there applies to synced rows too. See Queue, scheduling and drip publishing.

Add a sync

Open PageForge > Data Sources and find the Google Sheets sync card. Under Add a sync, fill in:

FieldWhat to choose
TemplateThe template that builds these pages
Google Sheet URL / IDThe full sheet URL, or just the sheet ID
Status for new pagesPublish or Draft
When a row is removed from the sheetMove its page to draft, Move its page to the trash, or Keep its page as it is
Automatic syncOff (Sync now only), Hourly, Twice daily or Daily
Hand-edited pagesTick to overwrite pages edited by hand after generation

Click Save sync. The sync appears in the table with its removal rule, schedule and last run.

Preview, then apply

Click Preview (dry run) on the sync. PageForge reads the sheet and reports what it would do, without changing anything:

Sheet has 48 rows: 3 new, 5 to update, 39 unchanged, 1 skipped.
2 pages are no longer in the sheet:

The pages no longer in the sheet are listed with the action each would get: keep, move to draft, move to trash, or “edited by hand, kept”. Read the list, then click Apply this sync. Rows go into the queue, the removals you saw are applied, and the result tells you how many rows were queued and how many pages were removed.

Sync now applies the sync straight away. If the sync would remove pages and you have not previewed it recently, PageForge asks you to preview first.

What is protected

  • Only this sync’s pages. Removals only affect pages this sync created or updated. Pages from other templates, other syncs and hand-built pages are never removed.
  • Hand-edited pages. A page edited after PageForge wrote it is skipped on update and kept on removal, unless you ticked the overwrite option.
  • Scheduled removals wait for you. An hourly, twice-daily or daily sync removes nothing until one sync has been previewed and applied by hand. Until then, new and changed rows still sync, and removals wait.
  • An empty sheet is a failure. If the sheet comes back with no rows, PageForge reports a failure instead of treating it as “remove every page”. If you really want every page gone, remove them yourself.
  • Trash can be undone. Pages moved to the trash can be restored from the WordPress trash.

Who the sync runs as

Scheduled syncs run as the user who set up the sync, with that user’s permissions. If that account is deleted, the sync stops and its last run explains why. Open the sync and save it again from a current account.

Failures and retries

Rows that fail are listed with the sync, each with a Retry button. Rows that cannot succeed, such as a URL that belongs to another page, are marked as skipped with the reason.

Next: Per-row images, categories, tags and authors.

Was this page helpful?

↑↓ to move↵ to open