07

Automated Social Media Content Publishing Factory

System Prompt Composition & Approval Workflow

An n8n content-production workflow that combines external schemas and system prompts, uses AI to create structured social content, gathers supporting imagery, prepares review material, and stores the resulting content package in Google Drive. Content is not treated as approved until a person approves it.

Class
AI Content Automation
Built with
n8n · Google Gemini · SerpAPI · Google Drive · Gmail · Telegram
Walkthrough
None recorded

The work

Producing structured social media content involves managing system prompts, managing output schemas, generating the content, sourcing images, preparing review material, organising files and storing the final assets.

The friction

The same coordination work repeats every time a new content package is created.

n8n workflow canvas for the Automated Social Media Content Publishing Factory, showing schema and system prompt parsing, prompt composition, a social media content creator using a Google Gemini chat model with SerpAPI, image retrieval, download and Google Drive storage, and a split into a Gmail review branch with an approval check and a Drive storage branch that formats and saves the final social post.
The full n8n canvas, with the visible workflow groups preserved. The review branch and the storage branch run from the same merge.1836 × 813 · 286 KB

The system

The workflow is called by another workflow and takes a schema and a system prompt as inputs. After generation it splits into a review branch and a storage branch.

  1. Triggered by Another Workflow

    Inputs

    • Social Media Schema
    • System Prompt
  2. Parse Schema
  3. Parse System Prompt
  4. Merge Prompts and Schema
  5. Compose Prompt and Schema
  6. Social Media Content Creator

    Uses

    • Google Gemini Chat Model
    • SerpAPI where configured
  7. Social Content
  8. Get Images
  9. Optional Telegram success or error messages
  10. Download Image
  11. Save Image to Google Drive
  12. Merge

Review and storage branches

  1. Review: Prepare Social Media Email
  2. Review: Gmail
  3. Review: Is Approved?
  4. Storage: Google Drive Image Metadata
  5. Storage: Social Content Doc Formatter
  6. Storage: Save Social Post to Google Drive
  7. Storage: Respond with Google Drive ID

What it handles

  • Prompt loading
  • Schema loading
  • Schema parsing
  • Prompt composition
  • AI content generation
  • Image retrieval
  • Image download
  • Google Drive storage
  • Gmail review packaging
  • Approval flow
  • Content-document formatting
  • Final Drive asset creation

What stays human

Human approval is part of the workflow before content is treated as approved.

  • Approving or rejecting the content package
  • Prompt strategy
  • Judging content quality

The principle

The factory assembles the package. Approval is still a person's call.

Exceptions

  • Invalid schema
  • Conflicting prompt instructions
  • Weak content output
  • Unavailable images
  • Image download failure
  • Gmail failure
  • Drive storage failure
  • Approval rejected

How it improves the workflow

It turns prompt composition, content creation, image gathering, review preparation and file organisation into one coordinated content-production workflow.