Back to Templates

Generate an AI YouTube trend report with GPT-4o, Google Sheets and PDF.co

Created by

Created by: Milo Bravo || milobravo1

Milo Bravo

Last update

Last update 4 hours ago

Share


AI YouTube Trend Intelligence Report: YouTube API + GPT-4o + PDF Dashboard

Who is this for?
AI creators, marketers, agencies, and researchers tracking YouTube trends who need weekly high-signal insights without 4+ hours manual research.


What problem is this workflow solving?
Trend hunting is exhausting:

  • Scanning 500+ videos across keywords

  • Manual engagement calculations

  • No automated filtering or analysis

  • Scattered spreadsheets vs polished reports

  • This workflow auto-discovers top videos, ranks by engagement, and delivers branded PDF + Sheets dashboard.


What this workflow does

  1. Trigger: Form input (keywords, days back) or weekly cron
  2. YouTube API: Searches 10 keywords → ~500 videos (past 7 days)
  3. Ranking: Views + engagement rates → top performers
  4. Google Sheets: Exports channels/videos/keywords/stats
  5. GPT-4o: Analyzes trends → content recommendations
  6. PDF.co: HTML charts → branded PDF report
  7. Gmail: Delivers to inbox

Setup:(5 minutes)

  • YouTube Data API v3 key (HTTP Query Auth)

  • Google Sheets OAuth2 for exports

  • OpenAI API (GPT-4o-mini)

  • PDF.co for HTML-to-PDF

  • Gmail OAuth2 + recipient email

  • Fully configurable env vars—no hardcoded IDs.

How to customize:

  • Edit 10-term list for your niche

  • Filters: Adjust min views (1k), engagement (2%)

  • Schedule: Daily/weekly cron

  • Output: Swap Gmail for Slack/Notion

  • Scale: 1000s videos/month

ROI:

  • 4+ hours saved weekly

  • 20% higher content performance

  • Automated competitive intel

  • Zero manual spreadsheet work


Need help customizing?
Contact me for consulting and support: LinkedIn / **[Message](https://tally.so/r/E


Keywords: YouTube trend analysis, AI YouTube research, YouTube analytics automation, content trend tracker, video engagement ranking, YouTube API n8n, weekly YouTube report, YouTube keyword monitoring