Daily YouTube Trending Digest: Google Sheets + Gmail

Get a daily “what’s trending” email—automatically—by ranking YouTube videos stored in Google Sheets

This n8n workflow scans your YouTube channel data in Google Sheets every day, selects only above-average videos per channel, and sends a formatted HTML trending digest via Gmail with thumbnails, titles, views, and duration.

What this workflow does

• Runs daily at 10:00 using a Schedule trigger.
• Reads the list of channels from your Google Sheets spreadsheet (via your “Channels” sheet).
• For each channel, loads that channel’s video rows from a Google Sheets tab named after the channel ID.
• Calculates an average views baseline per channel.
• Filters for above-average performers: keeps videos where views >= channel average views.
• Aggregates results across channels into a single dataset for the email.
• Sends an HTML email via Gmail including: thumbnails, titles, channel name, views, duration, and a views-to-average multiplier for each selected video.

Use cases

• Creator analytics: send yourself (or your team) a daily roundup of which videos are outperforming the channel’s usual average.
• Media ops / SaaS dashboards: use Google Sheets as your data layer, then deliver digest-style insights to stakeholders by email.
• Automation engineers: deploy a repeatable n8n workflow pattern for “read → filter → aggregate → email” using YouTube metrics.

Technical details

• Triggers: Schedule (daily at 10:00)
• Integrations: Google Sheets (OAuth), Gmail (OAuth)
• Workflow logic: set, filter, aggregate, google sheets access, split in batches
• Setup requirements: update the spreadsheet ID and ensure your “Channels” sheet and per-channel tabs are named correctly; each per-channel sheet must include the expected columns so the digest can render (including channel/tab reference, video ID, title, channel title, views, and duration).