Fully Automated Content Engine
A scalable content automation system built to remove the manual bottlenecks in content planning, creation and distribution. Airtable is the central content hub; Make.com is the automation backbone.
70%
less manual work
across planning, production and publishing
- Date
- Jul – Aug 2025
- Associated with
- AI Agency Lab (freelance)
- Built with
- Warren
- Core platform
- Airtable · Make.com
Context
A content operation publishing to CMS platforms, social media and newsletters, with ideas, assets, deadlines and schedules all needing to stay in step.
The Challenge
Planning, creation and distribution were separate manual handoffs. Moving a piece of content from idea to live meant repeated hand work at each step, and that work grew with every new channel.
My Role
Designed and built the system with Warren as part of AI Agency Lab: the Airtable content hub, the Make.com automations connecting it to production and publishing tools, and the AI-enriched brief step.
The Approach
- Give content one source of truth: every idea, asset, deadline and schedule lives in Airtable.
- Let Make.com carry work between the hub and the tools used to write, design and publish.
- Use AI to enrich briefs, so tone, keywords and brand stay consistent before anyone starts writing.
- Close the loop by feeding performance data back into the hub.
Before and After
Before
- Planning, creation and distribution handled as separate manual handoffs.
- Ideas, assets and deadlines tracked apart from the tools used to produce them.
- Each channel published by hand, so the work grew with every new channel.
After
- 70% less manual work across the content process.
- One Airtable hub for every idea, asset, deadline and schedule.
- AI-enriched briefs, then publishing to CMS, social and newsletters through Make.com.
- Performance data flows back into Airtable to guide the next round of planning.
What I Built
Five stages around one hub. Read in order, 01 to 05; performance data from the last stage feeds the first.
- 01
Plan
Ideas, assets, deadlines and publishing schedules tracked in Airtable.
- 02
Brief
Dynamic briefs generated with AI enrichment for tone, keywords and brand consistency.
- 03
Create
Planning connected to the design and copywriting tools.
- 04
Publish
Content published across CMS platforms, social media and newsletters.
- 05
Measure
Performance data returned to Airtable to guide the next round of planning.
Content hub
Airtable — the single record for every piece of content.
Automation backbone
Make.com — moves work between every stage.
From the build
Screenshots from Make.com and Airtable. Select any image to open it full size.
(opens full size in a new tab)
(opens full size in a new tab)
(opens full size in a new tab)
(opens full size in a new tab)
Outcome
70%
Reduction in manual work
- Faster publishing workflows.
- Less repetitive production work.
- Planning, production and publishing tracked in one place.
Technology
- Content hub
- Airtable
- Automation
- Make.com
- AI
- AI tools for brief enrichment
- Channels
- CMS platforms · social media · newsletters
Key takeaway
Treating content as one connected pipeline, with a single source of truth, made it possible to remove manual handoffs at every stage instead of automating one task in isolation.