Automated Blog Writer & Publisher

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.