Automated Content Generator Agent
A fully automated content engine that turns a single raw idea into platform-ready, SEO-optimised content without manual drafting, formatting or uploading. n8n orchestrates the AI models, Airtable and Google Workspace.
One idea in
Social posts, blogs, lead magnets, carousels and newsletters out
- Date
- Oct – Nov 2025
- My role
- Design and build
- Orchestration
- n8n
- Data & storage
- Airtable · Google Drive
Context
Content produced for several platforms, where each format has its own length, structure, tone and SEO requirements.
The Challenge
Turning one idea into a blog, a set of social posts or a newsletter meant drafting, reformatting, checking SEO and uploading assets by hand for every format.
My Role
I designed and built the agent in n8n: the workflow logic, the AI prompting and writing frameworks, the SEO QA step, and the structured storage in Airtable and Google Drive.
The Approach
- Work out the content type and platform requirements before any writing happens.
- Keep research (Gemini) separate from writing, so drafts start from current information.
- Run SEO QA before anything is marked ready to publish.
- Store every output in a structured way, so publishing can be automated downstream.
Before and After
Before
- Every format drafted separately from the same idea.
- Formatting, SEO checks and HTML done by hand.
- Assets uploaded and organised manually before publishing.
After
- One idea in Airtable becomes social posts, blogs, lead magnets, carousels and newsletters.
- Gemini research and writing frameworks shape every draft to its platform.
- SEO QA runs before anything is marked ready to publish.
- Content, HTML, metadata, tags and slugs stored automatically; media saved to Google Drive.
What I Built
Seven stages from raw idea to stored, ready-to-publish assets. Read in order, 01 to 07.
- 01
Ingest
Ideas are picked up from Airtable; webhooks retrieve context and metadata.
AirtableWebhooks - 02
Analyse
Content type and platform requirements set the length, structure, tone and formatting.
- 03
Research
Gemini adds real-time research and industry insight.
Gemini - 04
Write
Writing frameworks for hooks, narrative flow, human tone and hashtags produce social posts, blogs, lead magnets, carousels and newsletters.
- 05
Build for SEO
Semantic HTML, internal linking, keyword strategy, alt text and CTA blocks.
- 06
SEO QA
Checks readability, metadata, schema opportunities, keyword density and publishability.
- 07
Store & prepare
Content, HTML, metadata, platform settings, images, tags and slugs saved to Airtable; media uploaded to Google Drive.
AirtableGoogle Drive
What's stored for every piece — ready for publishing
- Final copy
- HTML
- Metadata
- Platform settings
- Images & alt text
- Tags
- Slugs
From the build
(opens full size in a new tab)
Outcome
The system creates ready-to-publish content assets and takes on the repetitive work around them:
- Drafting for each format and platform.
- Formatting, semantic HTML and SEO structure.
- Quality review before content is marked ready.
- Preparing and storing assets for distribution.
Technology
- Orchestration
- n8n · Webhooks
- AI
- Gemini · LLM tools
- Data
- Airtable
- Workspace
- Google Drive · Google Workspace
Key takeaway
Generating text is the easy part. The value is in the structure around it: knowing the platform's requirements before writing, and checking SEO and publishability before anything is called ready.