Content automation · SEO

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.

  1. 01

    Ingest

    Ideas are picked up from Airtable; webhooks retrieve context and metadata.

    AirtableWebhooks
  2. 02

    Analyse

    Content type and platform requirements set the length, structure, tone and formatting.

  3. 03

    Research

    Gemini adds real-time research and industry insight.

    Gemini
  4. 04

    Write

    Writing frameworks for hooks, narrative flow, human tone and hashtags produce social posts, blogs, lead magnets, carousels and newsletters.

  5. 05

    Build for SEO

    Semantic HTML, internal linking, keyword strategy, alt text and CTA blocks.

  6. 06

    SEO QA

    Checks readability, metadata, schema opportunities, keyword density and publishability.

  7. 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

n8n workflow canvas for the Automated Content Generator Agent (opens full size in a new tab)
The full n8n workflow. From the Airtable trigger, through research, writing and SEO QA, to storage. Select the image to open it full size.

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.