Automated Social Media Content Creation with n8n

Creating social posts used to be a manual, repetitive process — writing, rewriting, and tailoring for each platform. Now, it’s just one form, a few workflows, and some AI magic. We automated everything from idea development to approval, ready-to-publish content using n8n, OpenAI (gpt-4o-mini), and Google Sheets.

Start with a Simple Form

Everything begins with a single message. The form is provided by n8n – just a URL, ready to take command.

Once submitted, this form triggers the first workflow.

Workflow 1 – Create Social Posts

This is the main orchestrator. It takes your input message and calls a sub-workflow to create post drafts for every social platform – LinkedIn personal, Linkedin company, X [formerly twitter] etc.

Each post goes through its own generation and approval loop before being stored.

Workflow 2 – Create Social Post Content

This workflow runs in a loop — once for each social media platform. It uses OpenAI’s gpt-4o-mini model to generate post text based on a system prompt tailored to that platform.

Human-in-the-Loop (HITL) Approval

AI doesn’t always get it right, so we added a human approval loop. The generated post is emailed to the user, who can either approve or comment. If they comment, the LLM revises the text and resends it for approval. This loop continues until the user is happy.

Tracking in Google Sheets

Once all platform posts for a single prompt are approved, the workflow records them in Google Sheets with the status left empty — ready for the publishing workflow to pick up later.

Result

This flow now runs end-to-end without manual coordination. The LLM drafts content for each platform. The user stays in control through approvals. Even Google sheet can be modified. Everything is logged and ready for the publishing step. It saves hours every week and keeps content consistent across all channels without losing the human touch.

Coming Next

In the next post, we’ll cover how we automated the publishing schedule — how posts from this tracker are automatically published at the right time across all social platforms.