Amazon Q in Production: 72 Percent Time Saved

Description and use

An automated pipeline generates and uploads videos to 9 YouTube channels daily, saving 72% of time and incurring zero monthly cost.

Problem

Manual content creation for 9 channels would take over 8 hours daily, which is unsustainable for a full‑time VP at JPMorgan.

Outcome

Automated pipeline reduces daily content creation time by 72%, enabling zero manual work for 9 YouTube channels at zero monthly cost.

Workflow

• 1. Pull trending topics from a CSV file.
• 2. Generate video script using AI (Ollama or Gemini).
• 3. Convert script to audio with Google Cloud TTS.
• 4. Fetch relevant images from Pexels API and assemble video with MoviePy.
• 5. Upload finished video to YouTube via YouTube API.
• 6. Schedule each channel’s upload with a Mac LaunchAgent plist.
• 7. Run the pipeline daily at scheduled times.

Evidence

Creating content manually for 9 channels would take 8+ hours daily.

Source

Total: ₹0/month

Source

One plist per channel. Runs at the exact scheduled time.

Source