AI-powered bulk content publishing automation

The challenge

A large content publishing initiative required approximately 300 video items to be created within a backend CMS.

Each item required around 12 fields to be completed manually, including titles, metadata, categories, language settings, author information, publishing dates, and content classifications. The process would have required several days of repetitive manual data entry.

A further challenge was that the platform offered no public write API, making traditional automation approaches unavailable.

The solution

To optimise the workflow, I designed and developed a Python-based publishing automation system using AI-assisted development workflows with Claude AI.

The solution automated content creation directly within the backend CMS by replicating browser behaviour, handling authentication, validating data, and publishing content automatically from structured Excel spreadsheets.

The workflow included:

• automated content creation
• metadata population
• category assignment
• author mapping
• language resolution
• logging and validation

The system was designed to be reusable by non-technical team members with minimal setup requirements.

Workflow overview

Excel content file
        ↓
Python automation
        ↓
Data validation
        ↓
BackOffice authentication
        ↓
Content creation
        ↓
Category assignment
        ↓
Publishing complete

The workflow dynamically retrieved author and language data, validated content records, managed authentication sessions, and created content directly within the CMS without requiring manual data entry.

Results & impact

Time savings

• Manual workflow: ~1 week
• Automated workflow: under 30 minutes
• Estimated efficiency improvement: 99%+

Workflow improvements

• eliminated repetitive manual publishing tasks
• automated field population and validation
• reduced risk of data entry errors
• reusable across future content imports
• enabled non-technical team members to execute uploads

Scalability

The solution successfully published around 300 video items while remaining maintainable and extensible for future publishing projects.

	Manual workflow	Automated workflow
Content Items	~300	~300
Time required	~1 week	Under 30 minutes
Field population	Manual	Automated
Category assignment	Manual	Automated
Validation	Manual	Automated
Scalability	Limited	High
Repeatability	Low	High