Back to Portfolio
AI-Powered SaaS & SEO Automation

1000+ Posts/Day Auto Blogpost Generator

Python (Flask)Celery & RedisSQLAlchemy (SQLite)SpaCy NLPWordPress API & XML-RPCMulti-LLM Failover
1000+
Posts Capacity / Day
3+
LLMs Integrated
Celery
Task Queue Engine
SpaCy
NLP Analysis Model
Hybrid
WP REST & XML-RPC

Project Overview

The 1000+ Posts/Day Auto Blogpost Generator is an advanced, automated SaaS-like platform engineered to orchestrate high-volume content generation and drip-feed publishing pipelines. Operating on an asynchronous queue system, it automates keyword analysis, competitor website scraping, AI article writing, image enrichment, real-time SEO scoring, and WordPress remote publishing.

Built with **Flask** for the control center and **Celery + Redis** for managing heavy concurrent worker tasks, the platform allows super administrators to manage user accounts, coordinate API keys with automatic failover limits, monitor server queues, and publish thousands of high-quality, SEO-optimized blog posts across a network of WordPress websites without locking the web server thread.

Core Feature Modules

🧬

Multi-LLM API Manager

Seamless orchestration of OpenAI GPT-4, Google Gemini Pro, and local Ollama (DeepSeek-R1) models. Implements key priority failover groups, token rate-limiting, and error-handling fallback logic.

Celery Asynchronous Tasks

Delegates heavy tasks (AI text expansion, SEO scoring, competitor scraping, image indexing) to multiple Celery background workers. Keeps GUI and web dashboards perfectly responsive.

📊

Real-Time SEO & NLP Auditor

Evaluates keyword density, generates meta descriptions, and calculates readability scores using natural language processing (SpaCy). Auto-injects JSON-LD article schemas.

🌐

Resilient WordPress Publisher

Connects to multiple WordPress sites using Application Passwords. Integrates a hybrid publishing mechanism using the WP REST API with an XML-RPC fallback to bypass firewalls.

🖼️

Automated Image Enrichment

Connects to Unsplash and Pexels APIs using rotation keys to index, select, and assign contextually relevant high-resolution featured and inline images with custom alt text.

🕵️

Competitor Website Scraper

Analyzes competitor sites to extract writing styles, common topics, average post lengths, and structural outlines to train prompt templates for target content.

Auto Blogpost Pipeline Workflow

1
Competitor Analysis & Keyword Discovery

Scrapes organic terms or scans competitor sites to discover high-volume search parameters and store them in the database.

2
AI Title & Outline Suggestion

Uses LLM APIs to generate high-CTR title suggestions and structures structured outlines for review.

3
Background Article Compilation

Queue handles long-running AI content generation, applying prompt guidelines for SEO density and logical layouts.

4
Image & Schema Enrichment

Downloads relevant images, writes SEO meta tags, and generates JSON-LD Schema markup automatically.

5
WordPress Remote Publishing

Publishes content directly to WordPress via REST/XML-RPC or schedules post releases for future drip schedules.

Database Relational Schema

The backend utilizes SQLAlchemy ORM mapping SQLite models optimized for high-volume content storage:

post Core Content
idPK
titleString(255)
contentText
seo_scoreInteger
meta_descriptionText
keyword_densityFloat
readability_scoreFloat
featured_image_urlString(500)
wordpress_site_idFK
wordpress_post_idInteger
statusdraft / published / failed
ai_provider_key API Keys
idPK
provideropenai / gemini / deepseek
api_keyString(255)
priorityInteger (Failover Queue)
is_activeBoolean
rate_limit_hitBoolean
task_queue Celery Tasks
idPK
task_typeString(50)
task_statuspending / completed / failed
progressInteger (0-100)
task_dataText (JSON)
error_messageText

Technical Architecture Decisions

  • Asynchronous Task Isolation: AI generation, scraping, and remote publishing can take up to 2 minutes per post. Using Celery workers isolates these operations from the Flask web server, guaranteeing instant page response speeds.
  • SpaCy Local NLP Pipeline: Real-time readability audits are run locally using SpaCy (English model) to analyze syntax complexity and grade readability without making costly external API calls.
  • Encryption Guard: WordPress credentials and Application Passwords are saved with Fernet encryption keys in the database, protecting customer credentials from SQL injection exposure.
  • Failover Key Rotation: Built-in cron jobs automatically rotate Pexels, Unsplash, OpenAI, and Gemini API keys when rate-limiting triggers occur, maintaining a 99.9% pipeline uptime.