Content Pipeline

AI-Powered Sports Content Automation

Make.comPerplexityGPT-4.1AirtableWordPress

Executive Summary

End-to-end content pipeline that ingests RSS feeds, generates SEO-optimized articles, and routes through editorial approval. Two-stage workflow handles everything from news detection to WordPress publishing with Yoast metadata.

Workflow

Pre-Approval Workflow

Make.com workflow: RSS to Perplexity to OpenAI to Airtable

Airtable Approval Hub

Airtable approval table with SEO fields

Post-Approval Workflow

Make.com workflow: Webhook to Markdown to WordPress

System Architecture

Components

  • Ingestion: RSS.app monitoring sports feeds
  • Summarization: Perplexity for context + fact enrichment
  • SEO Engine: GPT-4.1 outputs structured JSON (title, slug, meta, body)
  • Approval Hub: Airtable with editorial review fields
  • Publishing: WordPress REST API + Yoast SEO

Boundaries

  • Pre-approval workflow: RSS → AI packaging → Airtable draft
  • Post-approval workflow: Webhook → HTML compile → WordPress publish
  • Editors only see Airtable; no direct CMS access needed
  • Category routing handled automatically (Soccer, NBA, Other)

Agent Design

Tool Calling

  • HTTP (RSS) — fetch new articles
  • Perplexity — summarize + enrich
  • OpenAI — generate SEO JSON
  • WordPress API — upload media + publish

Routing Logic

  • Soccer keywords → Soccer category
  • NBA/basketball → NBA category
  • Default → Other Sports
  • Duplicate URL detection → skip

Guardrails

  • No publish without editor approval
  • SEO fields validated before submit
  • Featured image required
  • Minimum word count enforced

Escalation

  • AI output unclear → flag for manual edit
  • Image fetch fails → placeholder + alert
  • WordPress error → retry + Slack notification

Reliability & Ops

Implemented

  • Idempotent RSS processing (URL deduplication)
  • Airtable status tracking (Draft → Approved → Submitted)
  • Webhook retry on failure (3x exponential)
  • Featured image pre-upload to WordPress media library

Next Iteration

  • Scheduled publishing (not just immediate)
  • A/B testing for headlines
  • Auto-tagging with entity extraction
  • Multi-site publishing support

Observability & QA

Implemented

  • Make.com execution logs per scenario
  • Airtable audit trail (created/modified timestamps)
  • WordPress post URL logged back to Airtable

Next Iteration

  • SEO score tracking post-publish
  • Engagement metrics feedback loop
  • Content quality scoring (LLM-as-judge)

QA Checklist

  • RSS feed triggers correctly
  • AI summary is accurate to source
  • SEO JSON schema validated
  • Featured image uploads successfully
  • Correct category assigned
  • Yoast fields populated

Impact

Hours → Minutes

Content prep time reduction

100%

Yoast SEO compliance

Dozens

Articles processed in parallel

Zero

Manual CMS work for editors

Downloadable Artifacts

Case Study PDF

Full documentation with workflow diagrams

Make.com Blueprint (Pre-Approval)

Import directly into Make.com

Make.com Blueprint (Post-Approval)

Import directly into Make.com

Interested in a similar system?

I build content automation pipelines for publishers, SEO teams, and media operations.

Get in TouchView More Projects