AI Social Media Content Factory

An asynchronous, human-in-the-loop automated content engine that transforms raw topic ideas into structured LinkedIn drafts using AI, routes them through a Slack review gate for brand safety, and executes live publishing upon approval.

Manual content creation and publishing workflows are slow and prone to context-switching fatigue. Generating drafts, manually reviewing them for quality, and copying text into native publishing tools wastes valuable creative time and leads to inconsistent posting schedules.

1. 01Topic idea is manually brainstormed and logged in a spreadsheet
2. 02Creator writes the LinkedIn draft manually
3. 03Content is proofread and checked against brand guidelines by hand
4. 04Draft is manually copied, pasted, and scheduled or published inside the platform dashboard
5. 05Notifications and reminders are tracked manually across chats

The same process, redesigned as a single automation. Each step runs without manual intervention.

1. 01Trigger: Google Sheets watch module detects a row change set to ready
2. 02AI generation: Google Gemini processes inputs into a structured LinkedIn draft, updating sheet status to pending review
3. 03Review notification: Slack receives a formatted preview card with interactive secure webhook approval/rejection links
4. 04Action handling: Custom webhook captures the reviewer's click event from Slack
5. 05Live publishing: Router directs approved content to automatically push live straight to LinkedIn via API
6. 06Error handling: Built-in error-handling routes catch API or execution failures passively by updating the spreadsheet status and alerting the team via Slack

• Completely eliminates manual drafting and copy-pasting
• Enforces brand safety and quality control via an instant Slack review gate
• Guarantees system reliability and observability through integrated automated error handling