The Posts & Pages provider allows you to export and import your WordPress posts, pages, and any registered custom post type to and from Google Sheets.
Available Fields
The following fields are available for syncing:
- Post ID — The unique identifier for the post.
- Title — The post title.
- Content — The full post content.
- Excerpt — The post excerpt.
- Status — Post status (publish, draft, pending, private, etc.).
- Author — The post author’s display name or ID.
- Date — The published date.
- Modified Date — The last modified date.
- Slug — The URL-friendly post name.
- Featured Image — The URL of the featured image.
- Categories — Assigned categories (comma-separated).
- Tags — Assigned tags (comma-separated).
- Custom Taxonomies — Any registered custom taxonomy terms.
Filtering Options
You can filter which posts to sync by:
- Post Type: Select a specific post type (post, page, or any custom post type).
- Post Status: Filter by publish, draft, pending, or other statuses.
- Date Range: Export only posts within a specific date range.
Real-time Sync
Enable real-time sync to automatically push changes to Google Sheets when posts are created, updated, or deleted. This works with the following triggers:
- Create: When a new post is published.
- Update: When an existing post is modified.
- Delete: When a post is moved to trash or permanently deleted.
Import Support
You can import posts from Google Sheets back into WordPress. When importing:
- Use Post ID or Title as the unique key for matching existing posts.
- Fields like status, categories, tags, and content will be updated based on sheet data.
- New rows in the sheet will create new posts in WordPress.
Example Use Cases
- Export all blog posts for content auditing in Google Sheets.
- Bulk update post statuses by editing the sheet and importing changes.
- Create a shared editorial calendar with your team.
- Back up all pages to Google Sheets automatically on a daily schedule.