Project Summary

Formateur Pro is a consulting agency whose founder needs a strong personal brand to attract clients. But creating quality content across LinkedIn, Instagram, and X takes hours of research, writing, and design work—time the founder doesn't have.

We built an end-to-end AI content system that handles everything: analyzing trending competitor posts, researching fresh ideas, writing engaging copy, generating custom images, and auto-publishing on schedule.

The results: content creation time dropped from 20 minutes to 2 minutes per post—an 90% reduction—while maintaining quality and insights.

How It Works

The system generates 20 posts weekly. The founder reviews them in a Google Sheets dashboard, tweaks as needed, and approves 7 for daily publishing. Approved posts automatically publish across all three platforms throughout the week. In the background, the AI continuously improves by analyzing performance and monitoring competitor success.

The Challenge

Personal branding demands consistency. Founders need to show up regularly with valuable content that resonates with their target audience. But the reality is brutal: researching topics, writing compelling copy, creating visuals, and managing multiple platforms eats hours every week.

Formateur Pro's founder needed to build visibility without sacrificing time better spent on client work and business development. Generic scheduling tools weren't enough—they still required manual content creation. He needed a system that could actually produce the content, not just post it.

Our Solution

We built a comprehensive AI content engine using n8n with five integrated components:

Intelligent Content Creation - This is the core of the system. The AI draws from three idea sources:

  • Web research using Perplexity AI to find trending topics and fresh angles in the consulting space
  • Competitor analysis identifying what's working for similar founders and thought leaders
  • Performance analysis understanding which of the founder's past posts drove the most engagement

For each post, the AI writes compelling copy optimized for each platform, generates custom image prompts, creates visuals, and refines everything based on what's proven to work. The "Humanizer" component ensures text doesn't sound like generic AI output—it maintains the founder's authentic voice.

Automated Publishing - Approved posts publish automatically on schedule (daily at 4 PM, for example) across LinkedIn, Twitter, and Instagram via Blotato. No manual posting, no platform switching, no missed days. The founder's presence stays consistent without requiring daily attention.

Competitor Intelligence - Weekly, the system scrapes posts from competitors listed in the database, identifies which ones went viral (high engagement), and adds them to the analysis pool. This keeps the AI informed about what's working in the market right now, ensuring the founder's content stays relevant and competitive.

Performance Analytics - Every two weeks, the system analyzes the founder's post performance—which topics, formats, and hooks drove the most engagement. These insights automatically feed back into content creation, creating a continuous improvement loop where each batch of posts is smarter than the last.

Google Sheets Command Center - Everything is managed through a simple Google Sheets database:

  • Review and approve generated posts
  • See competitor viral posts for inspiration
  • Track performance analytics and trends
  • Manage publishing schedule

No complex software to learn—just spreadsheets.

The Technical Architecture

Built on n8n with a carefully selected tech stack balancing capability and cost:

  • OpenAI & Anthropic for content generation and analysis (combined: ~$10/month)
  • Perplexity AI for web research and trend identification (~$5/month)
  • Apify for competitor post scraping (~$5/month)
  • Blotato for multi-platform publishing automation ($29/month)
  • Google Sheets & Drive for database and image storage (~$5/month after free period)
  • PDFEndpoint for report generation (free)

Total running cost: under $50/month—far less than hiring a content creator or social media manager.

The modular architecture means each component can be updated independently. Want to change the writing style? Adjust prompts in the content creation component. Need to add new competitors? Update the Google Sheet. Everything is designed for easy customization.

The Interface

The founder interacts with the system exclusively through Google Sheets. Each week, 20 new posts appear with preview text, image prompts, and platform variations. He scans through, makes quick edits if needed, checks an "approved" box for his favorites, and that's it. The system handles everything else.

Execution logs are available in n8n for troubleshooting, but day-to-day operation requires zero technical knowledge.

The Results

Content creation time dropped from 20 minutes to 2 minutes per post—a 90% time savings. The founder reviews and approves content in a fraction of the time it would take to create from scratch.

More importantly, consistency became effortless. The founder maintains a daily presence across three platforms without the mental overhead of "what should I post today?" The system handles ideation, creation, and publishing while he focuses on client work and business growth.

The AI learns continuously from performance data and competitor analysis, meaning content quality improves over time. Posts are informed by real market trends and proven engagement patterns, not guesswork.

Formateur Pro's founder now has the personal brand presence of someone with a dedicated content team, while spending less time on content than most founders spend scrolling social media.

Projects

AI Ad System for Performance Marketing Agency

AI Ad System for Performance Marketing Agency

AI Content System for Executive Personal Brand

AI Content System for Executive Personal Brand

AI Trend-Spotting System for Creative Agency

AI Trend-Spotting System for Creative Agency