n8n AI Content Workflow

via Freelancer ·

Budget / Salary$250–750
TypeFreelance project
LocationRemote
Posted1 hour ago
I want a single n8n workflow that ingests our website, marketing-campaign, and social-media performance data, funnels it through two AI agents (Anthropic Claude and Google Gemini), and gives me a ready-to-use social media content plan.

Workflow outline
• Data collection – pull daily metrics from Google Analytics 4, Meta/Instagram, X (Twitter), LinkedIn, plus our email platform’s campaign stats.
• Data preparation – deduplicate, normalise dates and UTM tags, then store the clean set in Postgres (or another lightweight DB you suggest).
• AI processing –
– Claude analyses the fresh data, surfaces trends, audience interests, and high-engagement topics.
– Gemini turns those insights into a weekly calendar: post titles, short copy, suggested visuals, and ideal publish times for each network.
• Output – push the content plan to a shared Google Sheet and send a formatted PDF summary to Slack.

Acceptance criteria
1. Workflow runs on a schedule and can also be triggered manually.
2. Source APIs, DB connection, and both AI calls are fully parameterised with environment variables.
3. Claude’s analysis and Gemini’s content plan are saved separately and timestamped.
4. Clear README showing how to import, configure, and extend the flow.

Please keep the solution entirely inside n8n (no external glue scripts) and use only official or widely adopted community nodes. If anything is unclear, feel free to ask before you start; I’ll respond quickly so we can keep momentum.
data processing google analytics postgresql social media marketing data analysis data integration api development n8n
Apply on Freelancer →

Project sourced from Freelancer.com. Applications happen directly on the original platform — we never collect your data.