AI-assisted weekly content generation

The challenge

A recurring weekly workflow involved producing structured learning digests for a corporate learning platform across multiple languages.

Each digest required selecting and scheduling content across five categories: Spotlight, AI, Communication, Wellbeing, and Management. Done manually, this meant cross-referencing a content database of 2000+ titles, tracking recently used items, checking author uniqueness, respecting format limits, filtering out unsuitable content, and writing localised headlines and descriptions every week.

The workflow was repetitive, detail-heavy, and difficult to scale consistently across languages.

The solution

To optimise the workflow, I created a dedicated Claude AI project configured with the content rules, categorisation logic, exclusion criteria, and required output format.

The workflow was reduced to a few simple inputs:

• Number of weeks to generate
• Starting date
• Target language
• Awareness days or topic overrides for specific weeks

Claude retrieves and evaluates content from a live API-powered catalogue before applying editorial rules and generating the final output.

Claude then handles content selection, applies the exclusion list, enforces editorial constraints, and generates a ready-to-use CSV file.

Workflow overview

Content database
        ↓
Claude AI project
        ↓
Rules & exclusion logic
        ↓
Multi-language content selection
        ↓
Structured CSV output
        ↓
CMS upload

The workflow encoded rules such as no duplicate URLs, no duplicate authors per week, format limits, language-specific filtering, category relevance checks, and awareness day alignment.

Results & impact

Time savings

• Manual workflow: 6-8 hours per weekly batch
• Automated workflow: 20 minutes per weekly batch
• Estimated improvement: around 18-24× faster

Workflow improvements

• reduced repetitive manual planning
• improved consistency across languages
• structured CSV output ready for upload
• stronger editorial control through encoded rules
• scalable weekly production process

Scalability

The workflow supports recurring multilingual content planning across EN, DE, NL, and FR, with 120+ content items curated per week.

	Manual workflow	AI-Assisted workflow
Content selections per batch	~100	~100
Time required	6-8 hours	20 minutes
Duplicate checking	Manual	Automated
Rule validation	Manual	Automated
Language support	Manual per language	EN · DE · NL · FR
Output format	Manual compilation	Structured CSV
Scalability	Limited	High