This template fully automates the process of generating, refining, and publishing blog posts to WordPress. It leverages Google Sheets as a planning and configuration hub, dynamically generates content using OpenAI (via OpenRouter), and handles post-processing, publishing, and logging — all without manual intervention. Ideal for content teams, bloggers, or businesses that want to streamline their content pipeline.
Features:
- Google Sheets Integration:
- Manage schedules, topics, and configurations in a single spreadsheet.
- Automatically logs actions and publishing statuses back into Sheets.
- AI-Powered Content Generation:
- Uses configurable LLM models (OpenAI via OpenRouter) for drafting, structuring, and finalizing blog posts.
- Supports placeholder replacement and structured prompts per authoring stage.
- Automated Publishing:
- Creates and publishes posts to WordPress using XML-RPC requests.
- Handles publishing status updates, including draft or publish modes.
- Scheduling & Triggers:
- Supports manual or automated runs on a defined schedule.
- Checks if content is ready to publish at the scheduled time.
- Data Post-Processing & Normalization:
- Cleans and merges generated data with existing spreadsheet rows.
- Extracts post IDs or error messages for clear tracking.
- Error Handling & Logging:
- Records errors, publishing responses, and status changes for audit and troubleshooting.
