AI-Driven Social Media Automation System
Budget: ₹12,500 – ₹37,500 INR
I’m building an end-to-end social media agent inside n8n that can analyse trends and competitors with Claude, write engaging captions, generate both images and videos through affordable APIs you’ll help me choose, and finally publish to Facebook, Instagram, LinkedIn and YouTube. Before anything goes live, each drafted post must appear in a Google Sheet where I can mark it Approved/Reject; only approved rows trigger the publish node.
Implementation thoughts
• n8n will be self-hosted, so the workflow needs to run entirely inside an existing Docker stack.
• Trend and competitor data can be fetched via public endpoints or scraping solutions you recommend, then summarised by Claude for quick human review.
• For media creation I’m open to any low-cost API—Stable Diffusion, DALL-E, Runway, Pika, etc.—as long as quality is solid and pricing stays manageable.
• I haven’t committed to a fixed posting schedule; please design the workflow so it can either push immediately or respect a datetime column in the Sheet.
• Publishing should cover multiple accounts per platform through official APIs or reliable third-party connectors.
Deliverables
1. Modular n8n workflow (trend analysis, caption writing, media generation, approval gate, posting)
2. API integrations with keys stored in environment variables
3. Google Sheet template with Approval column already wired to n8n
4. Short loom or written guide showing how to swap APIs, add new accounts and toggle scheduled posting
5. One-week support period to iron out edge cases
Acceptance criteria: a test run that pulls today’s trending topic, produces an image and a 15-sec video, writes captions for all four platforms, waits for my “Approved” mark in the Sheet, then publishes without errors.
Implementation thoughts
• n8n will be self-hosted, so the workflow needs to run entirely inside an existing Docker stack.
• Trend and competitor data can be fetched via public endpoints or scraping solutions you recommend, then summarised by Claude for quick human review.
• For media creation I’m open to any low-cost API—Stable Diffusion, DALL-E, Runway, Pika, etc.—as long as quality is solid and pricing stays manageable.
• I haven’t committed to a fixed posting schedule; please design the workflow so it can either push immediately or respect a datetime column in the Sheet.
• Publishing should cover multiple accounts per platform through official APIs or reliable third-party connectors.
Deliverables
1. Modular n8n workflow (trend analysis, caption writing, media generation, approval gate, posting)
2. API integrations with keys stored in environment variables
3. Google Sheet template with Approval column already wired to n8n
4. Short loom or written guide showing how to swap APIs, add new accounts and toggle scheduled posting
5. One-week support period to iron out edge cases
Acceptance criteria: a test run that pulls today’s trending topic, produces an image and a 15-sec video, writes captions for all four platforms, waits for my “Approved” mark in the Sheet, then publishes without errors.