AUTOMATION PROJECT

EtsyBot

End-to-end automated pipeline that researches trending niches, generates printable art with AI, writes SEO-optimised listings, and publishes to Etsy — fully autonomous.

5
Pipeline Modules
3
AI Integrations
0
Manual Steps

Tech Stack

Built with production-grade tools and APIs

🐍Python 3.12
🤖Gemini 2.0
🎨Leonardo.ai
🤗HuggingFace
🛒Etsy API v3
🐘PostgreSQL
Supabase
🐳Docker
🔐OAuth2 PKCE
APScheduler
🔄Tenacity
🚂Railway

Pipeline Architecture

Five autonomous stages, scheduled and orchestrated

┌─────────────────────────────────────────────────────────────────┐ SCHEDULER (APScheduler / Cron) Mon 08:00 ─→ Research ─→ Google Trends + Gemini Niche Discovery Tue 09:00 ─→ Assets ─→ Leonardo/HF Image Gen + 3 Mockups Every 6h ─→ SEO ─→ Gemini 2.0 Flash Copywriting Wed 10:00 ─→ Upload ─→ Etsy v3 API (Draft → Files → Active) Sun 20:00 ─→ Analytics ─→ Stats + Score Refresh + Feedback Database: Supabase (PostgreSQL) Logs: Rotating File (5MB×3) └─────────────────────────────────────────────────────────────────┘

Automated Pipeline

From trend discovery to live Etsy listing — zero manual intervention

🔍

Research

Discovers trending niches via Google Trends scoring and AI-powered keyword expansion using Gemini. Ranks opportunities by demand vs competition.

AI-POWERED
🎨

Asset Generation

Generates print-ready art via Leonardo.ai with HuggingFace FLUX fallback. Creates 3 mockup variations (cream, dark, multi-size) per product for Etsy's gallery.

AI-POWERED
✍️

SEO Copywriting

Gemini 2.0 Flash generates keyword-rich titles, 13 long-tail tags, and buyer-focused descriptions with print sizes, file formats, and care instructions.

AI-POWERED
🚀

Upload to Etsy

Creates draft listing via Etsy v3 API → uploads digital files + thumbnail + mockups → attaches shipping profile → activates listing. Automatic retry with exponential backoff.

API INTEGRATION
📊

Analytics & Feedback

Pulls views, favourites, sales, and revenue per listing. Recalculates niche scores so future research prioritises what actually sells.

AUTOMATED FEEDBACK LOOP

Key Features

Built for reliability and scale

🔐 OAuth2 PKCE Auth

Full browser-based PKCE flow with local callback server. Tokens auto-refresh and persist to environment.

🧠 AI Niche Discovery

Gemini suggests 5 new trending keywords each cycle, expanding beyond seed niches automatically.

🖼️ Multi-Mockup Generation

3 styled variations per product (cream, dark, multi-size) fill Etsy's image slots for higher conversion.

🔄 Retry & Backoff

Tenacity decorators with exponential backoff on all API calls. Handles rate limits gracefully.

📋 Draft → Active Flow

Listings created as drafts, files and images uploaded, then explicitly activated — matching Etsy's recommended workflow.

📈 Self-Improving

Analytics feedback loop recalculates niche scores based on real sales data, prioritising profitable niches.