n8n AI Social Scheduler

I need a fully-automated n8n workflow that generates fresh, real-life situations, affordability, myth busters, mortgage breakdowns, on-brand content every day, then schedules and posts it to Facebook, Instagram, X/Twitter, LinkedIn, TikTok, and YouTube with no manual touch points. The Perfect reference style is the daily feed at https://www.instagram.com/canadianfinancialliteracy/?hl=en — crisp visuals, concise captions, and consistent timing.
Post after every 3 hours

Here is the flow I have in mind:

• Content generation
– Pull a daily prompt from a Google Sheet or Airtable queue. (can discuss)
– Pass it to OpenAI (or a comparable LLM) to draft the post copy, relevant hashtags, and a short-form hook.
– Create a matching image or short video via DALL-E, Midjourney, or another AI image tool, then format it for each network’s ideal dimensions.( not visualize , no videos but can discuss)

• Approval & storage
– Drop the AI output into a Notion (or Airtable) table for traceability.
– Allow one optional human approval step that times out after X hours so the queue never stalls.

• Scheduling & publishing
– Push approved assets to each platform’s API (Meta, Twitter/X, LinkedIn, TikTok, YouTube) using n8n nodes or custom webhooks.
– Respect platform-specific character limits, thumbnail requirements, and optimal posting times.
– Log the final post URLs back to the database.

• Monitoring
– Capture basic engagement metrics (likes, comments, views) 24 h after posting and append them to the same record for reporting.

Deliverables
1. Exported n8n workflow (.json) with clear node naming and inline comments.
2. README covering environment variables, required API keys, and setup steps.
3. Loom or screen recording that walks through a full run from prompt to live posts, proving true hands-off automation.

Acceptance criteria
– At least one successful end-to-end run that publishes to all six networks in a sandbox or test account.
– No failed nodes when the approval step is skipped.
– Metrics returned and written back for each platform.

If additional licenses or external services are required, outline them up front so I can provision access. Once the workflow is stable, I’ll handle the creative prompts—your focus is the architecture, error handling, and reliable scheduling inside n8n.