AI Affiliate Content Automation

I need an experienced developer to build a fully automated affiliate marketing intelligence system that discovers trending products, generates platform-optimized content, and publishes across 5 social media platforms with embedded affiliate links — all running on autopilot via N8N workflows.
This is a complete end-to-end system, not a simple automation. Read the full spec before bidding.

System Modules Required
Module 1: Trend Discovery Engine

Scrape Google Trends via pytrends for rising product keywords (runs every 6 hours)
Cross-reference with Amazon Best Sellers to validate commercial intent
Score and rank products by trend velocity, search volume, and commission potential
Store ranked product queue in PostgreSQL database

Module 2: Affiliate Data Collector

Connect to Amazon Product Advertising API (PA API 5.0)
Per product: fetch affiliate link, product images, title, description, price, ratings
Fallback integration to ClickBank or ShareASale for non-Amazon products
UTM parameter generation per platform via Bitly API

Module 3: Platform Intelligence Analyzer

Per product, per platform: analyze current trending content structure
YouTube Shorts: YouTube Data API — extract hook patterns, thumbnail styles, title formulas from top-performing Shorts
TikTok: extract trending caption structures, hashtag performance, sound trends
Instagram Reels: engagement pattern analysis, visual style trends
Pinterest: popular pin formats, keyword density, board category mapping
Twitter/X: hashtag trends, tweet structure, optimal posting format
Output: platform-specific content brief per product (hook, thumbnail directive, title formula, hashtags, post time)

Module 4: Content Generation Engine

Video script generator using Claude API (Sonnet for scripts/hooks, Haiku for captions/hashtags)
Thumbnail image generator via Replicate (SDXL) based on platform brief
Voiceover generation via ElevenLabs API
Video assembly via FFmpeg: product images + voiceover + text overlays + background music
Each video must be unique per platform — not the same video reposted
Static content generator for Pinterest and Twitter (image + copy)
Affiliate link embedded in all content per platform rules

Module 5: Distribution Engine

YouTube Data API v3: upload Shorts with title, description, tags, affiliate link in description
TikTok API: upload video with caption, hashtags, affiliate link in bio rotation
Meta Graph API: publish Instagram Reels and feed posts
Pinterest API v5: create pins with image, description, affiliate link
X API v2: post with media, platform-optimized copy, affiliate link inline
Scheduling layer: post at optimal time per platform per timezone

Module 6: Analytics Feedback Loop

Collect engagement data per post per platform (views, likes, shares, saves)
Track affiliate link clicks and conversions via UTM parameters
Feed performance data back into content template engine
Auto-pause underperforming product-platform combinations

Module 7: Admin Dashboard

React frontend
Product queue management (approve/reject trending products)
Post status tracker (scheduled, published, failed)
Revenue and click analytics per platform
Content preview before publishing


Tech Stack Required

Orchestration: N8N (self-hosted on VPS)
Backend: Python (FastAPI or Flask)
Database: PostgreSQL
Queue: Redis + Celery or APScheduler
AI: Claude API (Anthropic) — Sonnet + Haiku models
Image generation: Replicate API (SDXL)
Video assembly: FFmpeg + MoviePy
Voiceover: ElevenLabs API
Frontend dashboard: React + Recharts
Deployment: Docker + VPS (Hetzner or DigitalOcean)


Platform API Integrations Required

Google Trends (pytrends)
Amazon PA API 5.0
Anthropic Claude API
Replicate API
ElevenLabs API
YouTube Data API v3
TikTok for Developers API
Meta Graph API (Instagram)
Pinterest API v5
X API v2
Bitly API


Deliverables

Fully functional N8N workflow file (exportable JSON)
All Python scripts for video assembly, API connectors, analytics
PostgreSQL schema + migrations
React dashboard (production build)
Docker Compose file for full system deployment
Complete documentation: setup guide, API key configuration, workflow explanation
2 weeks post-delivery support for bugs and deployment issues


What I Will Provide

All API keys and platform account access
Amazon Associates account
VPS server access
Anthropic Claude API access
Brand guidelines if needed


Required Skills

N8N workflow automation (must show prior work)
Python backend development
FFmpeg video processing
REST API integration experience
React frontend
PostgreSQL
Docker deployment
Prior affiliate marketing or social media automation projects preferred


Bid Requirements
Your proposal must include:

Have you built N8N automation systems before? Provide examples.
Have you integrated FFmpeg video pipelines programmatically?
Which of the 11 API integrations have you worked with directly?
Your proposed project timeline broken into phases
Fixed price bid only — no hourly. Milestones preferred.
Do you have experience with social media publishing APIs specifically (not just general APIs)?

Proposals without answers to all 6 points will be ignored.

Budget
$1,500 – $4,000 USD fixed price depending on experience and portfolio quality.
Milestone structure preferred:

Milestone 1 (30%): Trend engine + affiliate collector + database
Milestone 2 (30%): Content generation pipeline (scripts + video + images)
Milestone 3 (25%): Platform distribution + scheduling
Milestone 4 (15%): Dashboard + analytics + documentation + deployment


Project Duration
6–10 weeks expected. Faster with demonstrated experience.

Additional Notes

All code must be delivered with full source, no obfuscation
System must run unattended — no manual steps in the daily pipeline
Content must be genuinely differentiated per platform, not copy-pasted
Must comply with each platform's API terms of service
FTC affiliate disclosure must be automated into all post copy Show More