Project Overview We’re looking for a practical Python automation developer to build a small, focused script that takes YouTube URLs from Google Sheets and publishes AI-generated articles as draft posts in WordPress. This is not a UI job. No dashboards. No over-engineering. What the Script Must Do Read YouTube URLs from a Google Sheet Pull transcripts if available Conditionally transcribe only when a toggle column = YES Send content to OpenAI with a supplied prompt Do light web enrichment (title-based) Create draft posts in WordPress via REST API Mark rows as processed / error Log failures without breaking the run Be cron-friendly Tech Stack (Preferred) Python Google Sheets API YouTube transcript / captions OpenAI API WordPress REST API Docker (nice to have, not mandatory) What’s Already Provided Clear flow & requirements Prompt structure Google Sheet format WordPress endpoint No guessing required Deliverables Clean, commented Python script README with setup instructions Basic logging One successful test run (YouTube → WP draft) Budget $90 fixed Fast delivery preferred (2–3 days) No scope creep How to Apply (Important) To avoid time-wasters, include: One example of a Python automation you’ve built Confirmation you’ve worked with WordPress REST API Your estimated delivery time If you can’t explain how you’d handle retries, logging, and API limits, this isn’t the right job.