
Category
Portfolio
Publication Date
December 15, 2025
Developer
giovanniromero.dev
Project Description
Overview
This project is a fully autonomous AI-powered content engine built with n8n, designed to generate and publish long-form, expert-level technical content on X (formerly Twitter) without any manual intervention.
The system automates the entire content lifecycle, from concept selection to publication, ensuring consistency, quality, and scalability over time.
Problem Statement
Maintaining a consistent flow of high-quality technical content on social platforms is time-consuming and difficult to scale. Manual content creation introduces bottlenecks, inconsistency in tone, and a high risk of repetition when managing large concept lists.
This project addresses these challenges by introducing a deterministic yet flexible automation pipeline powered by artificial intelligence.
Solution Architecture
The workflow uses Google Sheets as a lightweight content management system where AI-related concepts are stored and tracked using state flags. A scheduled trigger initiates the pipeline at a fixed time each day.
A custom JavaScript logic layer filters out previously used concepts and randomly selects an unused entry, ensuring content diversity while preserving strict control over data integrity and content lifecycle.
The selected concept is then sent to an OpenAI language model using a carefully engineered prompt that enforces:
- Expert-level technical depth
- Precise terminology and controlled structure
- Output optimized for long-form X posts
- Non-marketing, educational tone
Content Generation Pipeline
Once the AI-generated content is produced, it is automatically published on X. Immediately after publication, the system updates the original data source, marking the concept as used and closing the automation loop.
This guarantees that each concept is published exactly once and allows the system to scale indefinitely as new concepts are added.
Key Features
- Fully automated daily content generation
- AI-driven technical writing with strict prompt constraints
- Duplicate prevention through state-based tracking
- Scalable concept management via spreadsheets
- Clear separation between orchestration, logic, AI, and publishing layers
Technical Stack
- Automation & Orchestration: n8n
- Data Management: Google Sheets
- AI Model: OpenAI (GPT-4o mini)
- Publishing Platform: X (formerly Twitter)
- Logic Layer: JavaScript
Why This Project Matters
This project demonstrates a production-ready implementation of AI automation beyond simple experimentation. It combines workflow orchestration, prompt engineering, data validation, and social publishing into a cohesive and scalable system.
It is particularly relevant for technical educators, developer-focused personal brands, and teams aiming to scale educational content without compromising quality or consistency.

