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.
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:
| Field | What to choose |
|---|---|
| Template | The template that builds these pages |
| Google Sheet URL / ID | The full sheet URL, or just the sheet ID |
| Status for new pages | Publish or Draft |
| When a row is removed from the sheet | Move its page to draft, Move its page to the trash, or Keep its page as it is |
| Automatic sync | Off (Sync now only), Hourly, Twice daily or Daily |
| Hand-edited pages | Tick 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.
