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

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

Trigger: Form input (keywords, days back) or weekly cron YouTube API: Searches 10 keywords → ~500 videos (past 7 days) Ranking: Views + engagement rates → top performers Google Sheets: Exports channels/videos/keywords/stats GPT-4o: Analyzes trends → content recommendations PDF.co: HTML charts → branded PDF report 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