Social Media Content Automation System

I need an automation expert to build a complete end-to-end social media content generation and posting system using n8n and other free, open-source tools wherever possible.
The system must automatically:


Generate content ideas based on defined topics or inputs.


Create captions using AI text generation.


Generate images or creatives automatically (e.g., via open-source image generation models or APIs).


Combine caption and image into post-ready content.


Schedule and auto-post to multiple social media platforms (LinkedIn, Instagram, X, Facebook, etc.).


Allow review or approval before posting (optional toggle).


Store all generated content in a database or Google Sheets for tracking and re-use.


Include monitoring and logging for success/failure of each post.


Requirements:


Strong experience with n8n automation workflows.


Familiarity with AI text and image generation models (e.g., OpenAI, Stable Diffusion, Hugging Face).


Integration knowledge for social media APIs (LinkedIn, Meta, X/Twitter).


Ability to use self-hosted and open-source solutions to minimize costs.


Deliver a fully functional, self-running automation pipeline.


Goal:
A fully automated, self-sustaining content creation and posting system that runs continuously, generating and publishing new, platform-ready content without manual intervention.