Self-Hosted AI Social Media Engine

A self-hosted content automation system combining n8n, Python, AI generation, and human approval to help businesses scale posting without losing control.

Overview

This project was built for small businesses that want the efficiency of automation without losing control over what actually gets published.

The system turns a simple Google Sheet into a content command center. A link is entered, AI generates platform-specific content, a human approval step confirms quality, and the workflow then posts and logs the result automatically. The goal is to reduce the time burden of social posting while keeping quality and brand control intact.

It is also a strong example of how I combine Python, AI, workflow orchestration, and operational thinking to create automation systems that are practical for real businesses.

Demo (Video)

Business value

1. Save founder/operator time

Instead of spending hours every week switching between content tools and social apps, the user only needs to submit the source link and approve the final draft.

2. Keep human control in the loop

Many automation setups fail because they remove the human checkpoint. This workflow includes an approval step so nothing is posted blindly.

3. Reduce tool sprawl and recurring costs

Because the system is self-hosted, it avoids stacking multiple SaaS subscriptions just to achieve a workflow that can be custom-built around the business.

4. Build a repeatable content pipeline

The real value is not just AI writing. It is the operational system: input, generation, approval, posting, and logging in one repeatable flow.

Tech Stack

Below is the Google Sheets sample table, where the owner only needs to paste the link and set a date/time for when they want the post to go live.

Below is the Apps Script which automatically triggers the workflow.

Below is the email approval system, which allows the owner to have the final say on what goes live.

Workflow summary

1. The owner pastes a product URL or article link into a Google Sheet.
2. A Python worker and AI model analyse the content and generate a draft.
3. The owner receives an approval email and can approve or edit the content.
4. The workflow posts the final version and logs the result back into the sheet.

This kind of system is useful for businesses that want practical, high-control automation rather than generic off-the-shelf workflows. It can also be adapted beyond social media into other approval-based operational automations.